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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter Currency Translation

(0) ShareShare
ReportReport
Posted on by

Hi,

I am trying ti understand how the Currency Translation feature works in MR. Specifcally,

1) Does it calculate the Average Rate, if the exchange table used has daily rates in it. or does it expect an exchange table that only has the average rate for each period put in.

2) Does MR look at the "Rate Calculation Method" used on the exchange table assigned for use in translation? Meaning, if the calculation method is "Multiply", and the functional amounts are in Euros and we are trying to report in USD, MR will multiply the Euro Functional amounts with the average rates in the exchange table to arrive at the USD amounts? Would the opposite be true if the table was set to "Divide"?

3) Is it possible in MR to translate Balance Sheet acounts at a month-end rate, similar to the DAX functionality in FRx.

Thanks,

Sandeep.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at
    Re: Management Reporter Currency Translation

    Hi - any help to answer the above is appreciated.

  • Suggested answer
    Ryan Sandness Profile Picture
    on at
    Re: Management Reporter Currency Translation

    Hi Sandeep,

    These should help - let me know if any questions.

    There is some good information on these two links:

    gp.rosebizincblogs.com/.../currency-translation-default-exchange-table-idsdemystified.html

    mbs2.microsoft.com/fileexchange (user guide for currency translation in in GP2010)

    1) Does it calculate the Average Rate, if the exchange table used has daily rates in it. or does it expect an exchange table that only has the average rate for each period put in.

    A: It uses a single exchange rate for each column (period). Does not actually calculate an average rate, as we expect that people enter an average rate in the table.

    2) Does MR look at the "Rate Calculation Method" used on the exchange table assigned for use in translation? Meaning, if the calculation method is "Multiply", and the functional amounts are in Euros and we are trying to report in USD, MR will multiply the Euro Functional amounts with the average rates in the exchange table to arrive at the USD amounts? Would the opposite be true if the table was set to "Divide"?

    A: Dynamics GP assumes you are entering rates to go from your originating currency to USD. You will want to setup rates for Euros to USD. So most likely multiply so 1EUR = 1.4 USD.

    3) Is it possible in MR to translate Balance Sheet acounts at a month-end rate, similar to the DAX functionality in FRx.

    A: Yes - there are current rates, historical rates, average rates, and budget rates. In account maintenance you will set the Currency Translation type to select which accounts should be translated at which rate.

    Thanks,

    Ryan

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans