Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Changing currency rate in management reporter

Posted on by 5

Hi

I have a question... 

Where do the management reporter get the exchange rate from when it converts the currency from EUR to DKK when I am making a report???? 

In our AX2012 the convertion says 5128 eur is 38000 DKK, but the report says 40000 DKK, which is a exchange rate of 795 DKK for 100 EUR, and nok 747 DKK for 100 EUR as the rate is in AX... 

How do I chance that????

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Changing currency rate in management reporter

    Hi ASA,

    The exchange rate and currency translation is defined in the main account where you can define e.g. to use the average rate of the period for the conversion.

    What has been setup in your case?

    Can you also share what selections you made in the column definition of your report?

    Many thanks and best regards,

    Ludwig

  • Zain Mehmood Profile Picture
    Zain Mehmood 2,715 on at
    RE: Changing currency rate in management reporter

    Hi A.S.A,

    Does changing any other criteria than the transaction date effects your report or not?

    Regards,

    Zain

  • A.S.A Profile Picture
    A.S.A 5 on at
    RE: Changing currency rate in management reporter

    Hi Thank you, but it still won´t work... its still the same... issue.

  • Suggested answer
    Zain Mehmood Profile Picture
    Zain Mehmood 2,715 on at
    RE: Changing currency rate in management reporter

    Hi A.S.A,

    Please go in the Main accounts of the company. Open the details of the Main account and go to the Management reporter tab. In the currency translation type select your criteria. There are plenty of options there you have to select Transaction date.

    Do it for all the remaining accounts and try again. Hopefully this will help your issue.

    Warm Regards,

    Zain

  • WillWU Profile Picture
    WillWU 22,350 on at
    RE: Changing currency rate in management reporter

    Hi A.S.A,

    Please refer to the following links:

    https://blogs.msdn.microsoft.com/dynamics_financial_reporting/2013/10/23/currency-translation-for-microsoft-dynamics-ax-2012-part-1-setup-cu7-feature/

    Hope this can help you.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans