Consolidation in AX 2012 - Tips & Tricks

Consolidation of financial accounts of a parent company and its subsidiaries is the need of the hour when a company operates in a globalized scenario

Ax 2012 allows us to consolidate transactions from multiple legal entities (both on AX and out of AX). In the consolidation company, it will be of great utility if we can identify a transaction by the company of origin. 

 It will be of great utility if we can identify a transaction by the company of origin in the consolidated accounts in AX 2012.

Below is a trick which helps us achieve this task in a simple yet powerful manner.

• Create a financial dimension "LegalEntity" and select use values from "Legal Entity" master. (You need not add it to Ledger or link it to a company)
• Go to the consolidation Company > Periodic > Consolidate and choose Consolidate (Online)
• Go to "Financial Dimensions" tab in the Consolidate Online Dialog Box
• Select the LegalEntity Dimension and choose "Company Accounts" in specification as below:

• After all the other parameters are filled in, Click "Ok".

That's it your transactions in the Consolidation Company will also list out the "company of origin" as below:

 

Consolidation in AX 2012, has many such simple but powerful tricks and this series of articles will explore into each such possibility through AX