This blog communicates with customers, partners, and the Dynamics community about the exciting developments related to CPM (Management Reporter, Forecaster and Enterprise Reporting) across all of the Microsoft Dynamics ERPs.
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. .
The high level steps to consolidating when different fiscal periods exist are:
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.
Fiscal Year, July 1 – June 30
Period 12, Fiscal Year 2008
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.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics