Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / MR RU7 and multi currency
Microsoft Dynamics GP (Archived)

MR RU7 and multi currency

(0) ShareShare
ReportReport
Posted on by Ian Richardson 4,150

hi folks

another multicurrency MR question.  I am still baffled as to if I have bugs, set up issues or MR functionality.

I have a Canadian parent company and a Sub in China.  The sub in China has functional currency and reporting currency of Hong Kong dollar.

In the multicurrency set up on the CAD currency line I have

HKD to CAD AVG set as the exchange table for CAD average.

That rate table is set up as a multiply table.  To get management reporter to correctly display the correct CAD values however I have to enter the divide rate onto the table.

I have switched to a divide rate table and have to enter the multiply rate to get the correct values in CAD through MR.

MR seemingly uses the inverse of whatever amount you put on the exchange table.

Is that by design?  Do I have a set up issue?  Do I have a bug in MR?

confused.

thanks for any advice / assistance.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: MR RU7 and multi currency

    What you described is working correctly. MR is supposed to use the opposite multiplier from GP because it does the translation the opposite way from GP. When configured correctly, both GP and MR share the same rates and both work correctly.

    To explain the issue a bit further, GP calculations the translation as reporting currency back to functional currency. MR calculates the translation as functional currency to reporting currency. For this reason, you need to enter rates in a way that may seem backwards in GP, but doing this will actually allow both programs to work correctly.

    Let's suppose an example of Functional Currency A and Reporting Currency B. Let's say that Functional Currency A is worth twice as much as Reporting Currency B. Below are the two options you have for how to enter the rates into GP. Both of these options will allow both MR and GP and work correctly:

    $100 (Functional) = $50 (Reporting)

    Option 1: In GP, set the rate table to multiply by 2.

    -This will allow GP to multiply the reporting currency by 2 and MR to divide the functional currency by 2.

    Option 2: In GP, set the rate table to divide by .5.

    -This will allow GP to divide the reporting currency by .5 and MR to multiply the functional currency by .5.

    The above information, along with additional translation information, is noted in the following KB:

    mbs.microsoft.com/.../KBDisplay.aspx

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

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 >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans