Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

MR - Currency Requirements for Consolidated Financials

Posted on by

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

  • JoshP Profile Picture
    JoshP on at
    RE: MR - Currency Requirements for Consolidated Financials

    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!

  • RE: MR - Currency Requirements for Consolidated Financials

    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
    RE: MR - Currency Requirements for Consolidated Financials

    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!

  • RE: MR - Currency Requirements for Consolidated Financials

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

  • Verified answer
    Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: MR - Currency Requirements for Consolidated Financials

    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

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans