Dynamics Financial Reporting

All about financial reporting and consolidations for Microsoft Dynamics ERPs

Creating Consolidated Financial Statements using Management Reporter – Consolidating with multiple Dynamics AX 2009 instances (AOS) (Part 4 of 7)

Creating Consolidated Financial Statements using Management Reporter – Consolidating with multiple Dynamics AX 2009 instances (AOS) (Part 4 of 7)

  • Comments 5

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.

  • Part 1 contains an overview of consolidating data across one or multiple Dynamics ERPs with the same chart of accounts and same fiscal periods.
  • Part 2 describes consolidating across one or multiple Dynamics ERPs with different chart of accounts
  • Part 3 defines the process for consolidation across one or multiple Dynamics ERPs with different fiscal periods
  • Part 4 is focused on reporting with multiple Dynamics AX 2009 instances (AOS).
  • Part 5 will show you how to report on consolidation data that resides in non-Dynamics ERPs.
  • Part 6 will discuss how to produce a consolidated report in Management Reporter that includes a column for elimination entries.
  • Part 7 will focus on scenarios where a company does not own 100% of a subsidiary.

If you are using multiple Dynamics AX 2009 instances, 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:

  • Consolidation, Export – use this in conjunction with “Consolidation, Import” when you need to consolidate across multiple Dynamics AX databases.
  • Consolidation, Import– use this in conjunction with “Consolidation, Export” when you need to consolidate across multiple Dynamics AX databases.
  • Consolidation, Online – use this when you need to consolidate, translate or eliminate within one Dynamics AX database.

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, and can use Management Reporter for currency translation and eliminaions.

Leave a Comment
  • Please add 3 and 2 and type the answer here:
  • Post
  • Using a dimension for a company ID in an AX consolidation process results in not being able to drill down to all dimension combinations or you have to maintain an extra dimension that users have to key a value in all transactions processed. This is not a good solution to getting drill down data that is converted from a functional currency to a reporting currency. There is a real need for Management Reporter to contain a feature to convert from functional currencies to reporting currencies without using the ERP consolidation features.

  • Management Reporter needs a feature set that converts from a functional currency to a reporting currency to streamline the closing process of customers that have multiple companies in different functional currencies. Running a consoldiation process is significantly more time consuming that simply converting in a report writer, particularly when companies want to do this multiple times during the closing process.

  • I couldn't agree more.  

    We need the flexibility in MR 2012 to do the conversion in MR not without having to use AX Consolidating feature which adds complexity and limited reporting for a company that uses many currencies from several Subsidiaries.  This is a great

    feature that the treat FRX had on top of being able to extract data from different ERPs at the same time.

  • I couldn't agree more with the posts below.  I'm an FRx user migrating to MR and find this currency translation limitations really bad.  Would anyone know if there are any plans by Dynamics to correct this with the release of a new service pack?

  • Agree on the posts on this topic. We need the flexibility in MR 2012 to do the conversion in MR not without having to use AX Consolidation. our company needs to do balance sheet reporting and use rates as of certain dates and we cannot do this right now in MR. Any updates or info from MS on this?

    Tnx.

Page 1 of 1 (5 items)