Creating Consolidated Financial Statements using Management Reporter – Consolidating data across one or multiple Dynamics ERPs with different fiscal periods (Part 3 of 7)

Sometimes, different companies will be using different fiscal calendars, but you may still want to create consolidated financial statements for these companies. This blog (3rd in a series of 7), will show you how to create consolidated reports with varying fiscal calendars. .

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

The high level steps to consolidating when different fiscal periods exist are:

1. Verify each company is available in Management Reporter. (See Part 1 of the series)
2. Create a column definition and use the period and year to ‘map’ the appropriate periods for each company.
3. Use a reporting unit restriction in the column definition to assign each company to its appropriate column.

The important thing to consider when designing the column definition for multiple companies with differing fiscal periods is what company will be assigned in the report definition. This is the company that you will use as the base fiscal calendar for any report definitions.

The following table describes the fiscal setup for companies CEU and CEE. Assuming CEU uses the fiscal calendar that you prefer to use for consolidated reports, if a report is desired for June 30, 2008, the mapping column shows the equivalent period and year for each company.

Company	Fiscal Year	Mapping
CEU	Fiscal Year, July 1 – June 30	Period 12, Fiscal Year 2008
CEE	Calendar Year, January 1 – December 31	Period 6, Fiscal Year 2008

 If the Report Definition has CEU defined as the company, then Base-6 would be appropriate for the Period in the column definition for CEE. CEU will use the Base period, which is Period 12 based upon the report definition and CEE will use Base – 6, which is Period 6. Both columns will include data for June 2008.

Comments

• Anonymous
  May 14, 2012
  Although this does work, there is no information shown for either the YTD column for these companies, or how this works without requiring the customer to manually maintain the columns every month. I have a company with 18 companies that have a total of 6 different fiscal year ends. When I asked, pre-sales, whether Management Reporter would handle this for them, I was told an enthusastic "yes"! If the customer has to manually manipulate somewhere around 15 different columns, multipled by the number of column layouts they have, then I would say this is a bit "NO"! I have been told by more than one support engineer that Mgt Reporter 2012 will "fix" this, and have had it referred to as a "bug" (and have Microsoft case notes to prove it). Is any of this true? I have a pretty irate customer who has had to have me come in for a half day of chargeable time because one of his companies just moved into a new fiscal year. I do not plan to have to go out there every time this happens, can you please tell me when this will be fixed? Thank you.

• Anonymous
  May 14, 2014
  Hi, I have different companies in my AX and the financial statement is working properly, but the issue were we getting is, one company have one currency code(USD) and other have Euros, the company with USD showing correct report but the other company is showing the wrong report. I have gone through many docs but unable to get the solution. Looking for valuable replies..... Thanks in advance...

• Anonymous
  August 03, 2014
  The comment has been removed