|Title:||Creating Consolidated Financial Statements using Management Reporter – Consolidating with multiple Dynamics AX 2009 instances (AOS) and/or if currency translation and eliminations are required (Part 4 of 7)|
If you’re using Dynamics AX 2009 with Management Reporter and wish to consolidate financial information across companies, we have a few additional tips for you. This blog entry (4th in a series) will help you bring together data from multiple Dynamics AX 2009 instances.
If you are using multiple Dynamics AX 2009 instances, require currency translation, or require hard eliminations, the consolidation process must occur within Dynamics AX 2009 before data is reported in a consolidated report. Use one of the three options in Dynamics AX to consolidate, translate currencies, and/or produce eliminations:
These options can be found in the General Ledger Area under Periodic > Consolidate.
Once the consolidation process has been run, the consolidated company is updated within Dynamics AX. Management Reporter can report on the consolidated company. If a dimension is used as a company account during the consolidation process in Dynamics AX, then as the user drills down, they will see the company listed as a dimension in Management Reporter.
Keep in mind that using a consolidation company is only required in Dynamics AX 2009, because Dynamics AX only allows one for one connection to an AOS server. If you’re using Dynamics AX 2012, you can connect Management Reporter directly to multiple AOS servers, but will still need to use a consolidation company if you need hard eliminations or currency translation.
|Date Added:||January 20, 2012 02:59:06 PM|