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

Announcements

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
Harisgillani Profile Picture

Harisgillani 4

#2
dekion Profile Picture

dekion 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans