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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / consolidation single e...
Microsoft Dynamics AX (Archived)

consolidation single exchange rate

(0) ShareShare
ReportReport
Posted on by Abdo Khoury 14,855

Dear 

I am almost sure about this , i just need to confirm it with you guys 

i am doing Consolidation online on 3 legal entities and each of them has a different Accounting Currency. 

now when i run the consolidation form , the Currency translation tab asks me to enter the legal entities and their accounting currency and the exchange rate type that they are using , and the consolidation is done on a single fixed Rate per currency

my question is: there is no way for me to setup the consolidation so that it takes each transaction at it's historical rate , is this correct ?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Silvano,

    You can specify that the exchange rate from the transaction date is used for consolidation purposes by selecting 'transaction date' in the exchange rate date field.

    If you want to apply different rates for different accounts, you have to Setup additional lines in the currency translation tab.

    Question:

    Why don't you use the Management Reporter for consolidation purposes? This is the recommended tool for making consolidations.

    Best regards,

    Ludwig

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,855 on at

    Dear Ludwig

    1. where do i specify this the exchange rate is used for consolidation ?

    2. and regarding the Management reporter , i personally would rather use it but each of my individual legal entities have a separate Accounting currency , how will management reporter manage to translate the transaction to the consolidation currency ?

    thanks

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Silvano,

    Here is a screenprint that shows how you can setup different exchange rates for different account ranges

    consol1.png

    The currency translation in MR is described here: https://blogs.msdn.microsoft.com/dynamics_financial_reporting/tag/currency-translation/

    Best regards,

    Ludwig

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans