Sage Evoluiton Alphanumeric accounts Error

From Sage Intelligence Knowledgebase
Revision as of 05:45, 20 October 2017 by Keeveshin (Talk | contribs)

Jump to: navigation, search

Sage Evolution Alphanumeric Accounts Error

Symptoms

You receive the message "Incorrect Mathematical Expression" in your Sage Intelligence reports if you use character account numbers instead of numerical numbers, for example, the word "Sales" instead of "4000".


Resolution

1. Download the two files from the links below.

2. Navigate to the following location on your local machine: C:\Program Files (x86)\Common Files\BIExcelfunctions1.1\64bit

3. Backup the two original files in the directory. You can do this by appending the work "Backup" to the end of their filenames for example.

4. Place the two new files in the directory.


https://www.dropbox.com/s/uelt5yf9q8aewn1/Sage.BI.ExcelFunctions.dll?dl=0

https://www.dropbox.com/s/opwxcj793ctpne9/Sage.Evolution.V7.ExcelFunctions%20-%20True.rdaconfig?dl=0