You can consolidate the general ledger entries of two or more separate companies (subsidiaries) into a consolidated company. Each individual company involved in a consolidation is called a business unit. The combined company is called the consolidated company.
You can import data into the consolidated company from other companies in the same database, from other Microsoft Dynamics NAV databases, or from files.
If the financial statements of a business unit are in a different currency than those of the consolidated company, you must set up exchange rates for consolidation. There are three different exchange rates for consolidation: Average Rate (Manual), Closing Rate and Last Closing Rate. For each general ledger account that is consolidated from the business unit, the content of the Consol. Translation Method field determines which exchange rate is used.
On each business unit card, you specify in the Currency Exchange Rate field whether the consolidation should use exchange rates from the business unit company or the consolidated company. If you use exchange rates from the consolidated company, you can change the exchange rates for a business unit.
Before you import data into the consolidated company, you can test that the setup of the companies is compatible. Then you can import the data.
The following table describes a sequence of tasks, with links to the topics that describe them. These tasks are listed in the order in which they are generally performed.
| To | See |
|---|---|
Learn what you can accomplish with the consolidation features in Microsoft Dynamics NAV. | |
Get an overview of how to perform a consolidation, from setup through finalization of the consolidation process. | |
Update exchange rates for a business unit that has financial statements in a foreign currency. | |
Export data from a company in a different Microsoft Dynamics NAV database. | |
Check whether there are differences between the setup of the consolidated company and the setup of the business units in a different Microsoft Dynamics NAV database. | |
Check whether there are differences between the setup of the consolidated company and the setup of the business units in a file. | |
Import consolidations data from business units in the same database. | |
Import consolidations data from a file. |