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.
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?