Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter to FRx (GP) - Historical Exchange Rates Per Account

(0) ShareShare
ReportReport
Posted on by

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

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Management Reporter to FRx (GP) - Historical Exchange Rates Per Account

    I ran into the same issue with a client and opened a case with Microsoft.  They indicated that MR only reads GP's currency translations if you are using MR's legacy provider.  MR's datamart is lacking this functionality.

  • Community Member Profile Picture
    on at
    RE: Management Reporter to FRx (GP) - Historical Exchange Rates Per Account

    Hello George

    Have you resolved this problem. I am experiencing the same problem

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans