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 :
Microsoft Dynamics AX (Archived)

Currency translation in management reporter at historical rates for opening balances (different company different historical rates)

(0) ShareShare
ReportReport
Posted on by

Hi,

I am doing consolidation in Management reporter and facing issue in currency translation for opening balances translation.

I have parent co. in INR and 2 A and B subsidiaries in EUR currency. Consolidation will be in INR therefore need to convert EUR TB in to INR. As per Indian consolidation rules I need to translate

S.capital - Historical rates

Reserves - Closing rate

Investments - Historical rates

Fixed assets - Historical rates

Other Balance sheets items - Closing rate

P&L item - Average rate

Now I am facing issue in using historical rates for opening balance taken from legacy system - AX is live from 31st march 2015. I have uploaded the opening balance TB as on 31st march in AX 2012 from legacy system.

My chart of account is shared across all the companies. I have defined for share capital main account

- exchange rate type = default and

- method = transaction date.

Now Historical rate for s. capital of company A is 60 $ as it was done in April 2012, Company B historical rate for s. capital is 62$ as it was done in June 2012.

On 31st march 2015 when I uploaded the TB my rate is 61.50.

In management reporter translation for share capital happens at 61.50 where as it needs to be for company A at 60 and company B at 62.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Couldn't get solution for this in management reporter. Now going back traditional way of consolidation through AX where foreign currency involvement is there. In AX hard consolidation I can choose exchange rate company wise and account wise...

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
Basit Profile Picture

Basit 1

#1
GL-01081504-0 Profile Picture

GL-01081504-0 1

#1
Roya Profile Picture

Roya 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans