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)

Retained Earning Outage in the Consolidation Entity in AX 2012 R3

(0) ShareShare
ReportReport
Posted on by

Hello All,

I have an issue with the P&L accounts rolling forward in our Consolidation Entity. In our consolidations, we have some entities functioning in currencies other than USD. In the below example I have considered an entity operating in GBP 

The beginning balance for 2017 for the Net Income Account – 399999 had to be -36,853,198.23 USD i.e. the sum of the balances of the account 399999 and 900200 in 2016.

0743.Img1.png

Transactions for account 900200 and the totals in GBP and USD are in the image below.

7725.Img2.PNG

Instead of posting the value -36,853,198.23 USD it is totaling upto -36,953,020.55 USD, the Reporting Currency value increased by 98,822.32 i.e. from 11343776.09 to 11442550.41. 

5277.Img3.PNG

Our finance team is not sure how this happened, as till 2016, we didn’t have this problem. Can you please help by answering the following questions

1) The reason behind the system not considering the historical reporting currency value and posting the USD value by multiplying transaction currency value the average exchange rate.

2)   How can we correct these transactions in the Consolidation Entity?


Thanks.

*This post is locked for comments

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

    Hi,

    Can you share details of how you run the consolidation and the exchange rate that has been setup for the consolidations?

    Do you know what changed in 2017 for example in regards to the exchange rate or consolidation process as the issue did not exist before.

    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
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
Basit Profile Picture

Basit 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans