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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / MR - Currency Requirem...
Microsoft Dynamics GP (Archived)

MR - Currency Requirements for Consolidated Financials

(0) ShareShare
ReportReport
Posted on by Rennecia Barran

Hello,

Are there any currency requirements to obtain consolidated financial reports?

i.e. Does all companies on my instance need to have:

- The same reporting currency or

-The same functional currency

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Greg Byer Profile Picture
    Greg Byer 2,586 on at

    The companies would not need to be in the same functional or reporting currency for MR to consolidate them.  Let's say that I have two companies, one with a functional currency of USD and another with CAD.  I want to consolidate them and see the amounts in USD.  In my CAD company, I would need to have an exchange rate set up between CAD and USD.  In MR, I would need to select the USD currency in the Currency Display cell of the column definition.  I can add both companies to the report tree and when the report is generated, both companies would display in USD.  

    The KB article below has steps for setting up currency translation in GP.

    support.microsoft.com/.../2986068

  • Rennecia Barran Profile Picture
    Rennecia Barran on at

    Thanks Greg, so they can have different functional and reporting currencies set?

  • JoshP Profile Picture
    JoshP on at

    Hello Ali,

    You are correct. The companies do not need to have the same functional currency or the same reporting currency.

    In addition to the link Greg provided, here are some further resources on using Currency Translation for Management Reporter 2012 with Dynamics GP:

    Legacy Currency Translation:

    2575539 Consolidated Currency Translation with Management Reporter GP Legacy Provider

    support.microsoft.com/.../2575539

    Data mart Currency Translation:

    2986068 Currency Translation for Microsoft Management Reporter 2012 with Microsoft Dynamics GP 2013 data mart

    support.microsoft.com/.../2986068

    On Demand Learning: Management Reporter Multicurrency Configuration for Microsoft Dynamics GP 2015

    community.dynamics.com/.../on-demand-learning-management-reporter-multicurrency-configuration-for-microsoft-dynamics-gp-2015

    Management Reporter currency translation using the Current translation type

    community.dynamics.com/.../management-reporter-currency-translation-using-the-current-translation-type

    Management Reporter currency translation using the Historical translation type

    community.dynamics.com/.../management-reporter-currency-translation-using-historical-translation-type

    Management Reporter currency translation using the Average translation type

    community.dynamics.com/.../management-reporter-currency-translation-using-the-average-translation-type

    Thanks!

  • Rennecia Barran Profile Picture
    Rennecia Barran on at

    Thanks Josh,

    How coincidental, I have those links saved for review. I just haven't had time to review and thought someone in the community already knew and save me the time of reviewing all the documents to not find a straight answer and then have to test.

  • JoshP Profile Picture
    JoshP on at

    Hi Ali,

    Just to clarify that the answer to your question "Can companies have different functional and reporting currencies set?" is "Yes". Sorry for any confusion! The additional links are just for your reference to assist with setting up Currency Translation.

    Thanks!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans