Hello
In the process of migrating a client from FRx to MR we have run into issues with regards to currency translation and historical exchange rates. FRx's currency translator allowed users to setup a separate rate table per GL account, which provided the ability to translate different accounts at different historical rates with in the same month.
For example if additions were made to various fixed asset accounts in the month of May 2014 it was quite simple to enter the amounts and the different rates into the FRx rates tables such as below:
- Leasehold Improvements $10,000 x 1.10 = $11,000.00
-Computer Hardware $5,000 x 1.12 = $5,600.00
From what I have found in MR there seems to be a single historical rate that can be used across all accounts which need to be translated on a historical rate basis. This is causing issues with clients that have multiple years of data in FRx, as it is not possible to balance back to their historic financial statements if they took advantage of the different historical rates in the FRx Currency Translator.
The "Currency Translation" window under Financial > Routines seemed promising however these figures do not seem to impact the MR reports.
Any help with the above would be greatly appreciated.
*This post is locked for comments