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.
It’s common that different companies may have different charts of accounts but still wish to produce consolidated financial statements. In this situation, Management Reporter can still consolidate the data, allowing you to produce consolidated financial reports. This blog (2nd in a series of 7), will highlight how to create consolidated reports with varying chart of accounts.
The high level steps for consolidating when different charts of accounts exist in each company are:
Multiple links to Financial Dimensions can be added to each row in the row definition for each unique company’s chart of accounts. In this example, you can see that CEU is using the set of accounts in the first Financial Dimension link (Column J), and CEE is using the accounts in the second Financial Dimension link (Column K).
Use a reporting tree to define which Link to Financial Dimensions from the row definition is used with each company. You can do this by first selecting the Row Definition in column E, and then selecting the appropriate Row Link in column F.
TIP: When creating the Link to Financial Dimensions, use the Description to identify which companies the link applies to. This makes it easy to select the correct company when creating a reporting tree.
In the column definition, the Reporting Unit field allows you to restrict each column to a particular unit of the reporting tree, so you can view the data side by side, if you wish. If you don’t indicate a specific company for a column, consolidated date for all companies will be displayed.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics