Sage Intelligence Reporting: Incorrect value for Foreign Currency Bank account on Sage Intelligence Financial Report Designer report

You may observe an incorrect value for a Foreign Currency Bank account on the Sage Intelligence Financial Report Designer report.

To explain this issue, consider the following steps to describe the scenario:

1. The Evolution company’s local currency = US Dollar $ (but it may also be any local currency)

2. Find and inspect a GL Cash and Cash Equivalent (Bank) account type (Account 8410)

3. This account is setup as a foreign currency account e.g. Mauritius Rupee (MUR)

4. If you run the standard Evolution Trail Balance report (March 2018 to February 2019) you’ll notice the correct and expected balance of $3 480.81 for this account.

5. Now run the Sage Intelligence Financial report Designer (FRD) 1-9 report for the same accounting year (01/03/2018 to 28/02/2019)

6. When the report has run to Excel, click the Manage button on the right.

7. Select the Trial Balance report and click the Edit button

8. Complete the fields below and click the Generate button

9. Notice the unexpected and incorrect balance value below which is clearly different from the above expected amount of $3 480.81