web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hello George

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

  • Suggested answer
    Community Member Profile Picture
    on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans