Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

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

Posted on by Microsoft Employee

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
    Community Member Microsoft Employee 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
    Community Member Microsoft Employee 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans