Hard to believe but the default SAI Consolidated statements reports based on each database's functional currency. Therefore, if you have CAD, USD and EUR functional databases, the numbers in the consolidated financial is reported in each respective functional currency which make the report very difficult if not impossible to interpret.

Would be nice to:

1. Allow user to identify the reporting currency and translation rate type (similar to GL Consolidation).
2. Link to CS currency table to automatically pull up the translation rate.

I know the above can be accomplished by Business Partners editing the exiting report but the client expect an out-of-the box consolidation report to be able to report the data in a single specified currency.

by: James T. | over a year ago | Reports / BI