Thursday, September 27, 2018

Dynamics NAV - How to Setup and Run the Consolidation Process

https://community.dynamics.com/nav/b/navvlogbypittis/archive/2017/10/20/how-to-consolidate-the-financial-statements-of-two-or-more-separate-companies-into-a-consolidated-financial-statement-in-microsoft-dynamics-nav-2017-microsoft-dynamics-nav-2017-features
  1. Create Parent Company
    1. Define Consolidated COA, Posting Groups, Dimensions, Accounting Periods
    2. Define Children Business Units
    3. Define Exchange Rates used for consolidation (Companies>Business Units)
      1. Average Rate
      2. Closing Rate
      3. Last Closing Rate
  2. In Children companies
    1. Fill in Consol Debit Acc. and Consol Credit Acc., Consol Rate for each GL account 
    2. Fill in the Consolidation code field on each GL account if you wish to map the dimension to a new consolidated dimension
  3. Test consolidation from Parent Company
    1. Go to Business Units>Select Child Company>Actions>Test Database
    2. Resolve all errors
  4. Run Consolidation
    1. Go to Business Units>Select Child Company>Actions>Test Database
    2. Enter Time period
    3. Repeat for each Parent if multiple tier Parents are configured
  5. Process Elimination Entries
    1. Run elimination report to identify elimination entries
      1. Business Units>Navigate>Eliminations
    2. Manually enter and post elimination entries in Consolidation company
  6. Re-Run consolidation for previous period if required
    1. Go to Business Units>Select Child Company>Actions>Test Database
    2. Enter Time period
    3. The original imported entries for that time period will be modified to 0 value, and new entries will be imported

No comments:

Post a Comment