Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 5600 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 900 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

ID:20337
Title:Creating Consolidated Financial Statements using Management Reporter – Consolidating data across one or multiple Dynamics ERPs with different chart of accounts (Part 2 of 7)
URL:http://blogs.msdn.com/b/dynamicscpm/archive/2012/01/04/creating-consolidated-financial-statements-using-management-reporter-consolidating-data-across-one-or-multiple-dynamics-erps-with-different-chart-of-accounts-part-2-of-7.aspx
Description:

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.

  • 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) and/or if currency translation and eliminations are required.
  • 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 for consolidating when different charts of accounts exist in each company are:

  1. Verify each company is created in Management Reporter. (See Part 1 of the series).
  2. Create a row definition with multiple Links to Financial Dimensions, one for each chart of accounts.
  3. Create a reporting tree and define each company as a reporting unit in the Reporting tree. Indicate which link to financial data from the row definition that each company uses.
  4. Use the reporting unit restriction in the column definition to assign each company to its appropriate column.

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.

Category:REPORTING: MANAGEMENT REPORTER
Link Owner:
Date Added:January 05, 2012 12:59:07 AM
Number Hits:29
RatingsAverage rating: (0 votes)
Reviews

No Reviews Yet.

 
GPWindow.com

Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.