How to run Consolidation in Microsoft Dynamics NAV 2016

In this blog I will take you through the steps for running Consolidation in Microsoft Dynamics NAV 2016, for companies within the same database as the consolidated company.

Consolidation is combining the financial data of two or more separate companies (subsidiaries) into one consolidated company for financial reporting.

Below I outline the setups required to be completed for the Consolidation and the process of consolidating the data in Microsoft Dynamics NAV 2016.

Setting up the Consolidation

1. Set up a Consolidated Company

A new consolidated company needs to be set up first. You can use the ‘Copy’ functionality from the ‘Companies’ page in Microsoft Dynamics NAV, to easily create the consolidated company.

2.Set up Consolidation information on all G/L Accounts for each subsidiary company

Specify the Consol. Debit Account, Consol. Credit Account and the ‘Consol. Translation Method’ for all the G/L Accounts in Microsoft Dynamics NAV.

How to run consolidation in NAV2016 im1

3. Setting up Business Unit Information

Set up a Business Unit for each subsidiary on the consolidated company.

How to run consolidation in NAV2016 im2

4.Specify Exchange Rates for Consolidations

There are three exchange rates that the program uses when consolidating the financial data of subsidiary companies involving foreign currency, in Microsoft Dynamics NAV. They are Average Rate (Manual), Closing Rate and Last losing Rate.

How to run consolidation in NAV2016 im3

5.Setting up Dimension Information for Consolidations on each subsidiary company

It is also possible to consolidate dimension information as well as G/L Accounts in Microsoft Dynamics NAV.

Only fill in the Consolidated Code field where the dimension value code in the subsidiary company is to be consolidated to a different dimension value code in the consolidated company.

How to run consolidation in NAV2016 im4


Consolidating the data

Open the Business Unit page on the consolidated company and then click on Actions → Import Database. Specify the ‘Consolidation Period’, ‘Copy Dimensions’ ‘Document No.’ and the Business Unit Code. Then click on ‘OK’.

This function will import the financial data from the subsidiary and post it to the consolidated company automatically.

 How to run consolidation in NAV2016 im5


Processing Consolidation Eliminations

Any elimination entries will need to be calculated manually and posted using a General Journal.

Note: For more information on any field, hit on F1 and online help will be displayed for the field. You can ‘Search’ in Microsoft Dynamics NAV to locate any pages.

This blog post was written by Elvin Narain, Microsoft Dynamics NAV Developer/Consultant at EBS

If you have outdated business software that’s limited in its reporting and analytical capabilities – then you should to talk to EBS about a powerful business management software solution – Microsoft Dynamics NAV. To find out more about Microsoft Dynamics NAV or other Microsoft business management software solutions, please call Paul Woods at EBS for an obligation free discussion on 1300 303 973.

Microsoft Dynamics NAV is global enterprise resource planning (ERP) software that helps more than 100,000 companies worldwide manage their accounting and finances, supply chain, and operations. Start with what you need now, and easily adapt as your business needs change. In the Microsoft cloud or on your servers—the choice is yours.

Evolution Business Systems (EBS) is a Microsoft Gold ERP Partner and business management software specialist that equips its clients with software designed to achieve their business goals. EBS offers a complete, fully featured, whole of business system that can meet their needs: Microsoft Dynamics NAV, Microsoft Office 365, Microsoft Dynamics CRM and Microsoft Power BI.  It’s available for deployment on Microsoft’s own Cloud servers – Azure – and packaged at an affordable monthly subscription price. EBS works alongside its clients to understand their business and vision, and offer solutions to support these both now and into the future.

Subscribe here to get our free EBS monthly enewsletter to get valuable blog articles from EBS and the latest updates on the Microsoft Dynamics product suite.