How to: Test Databases Before Consolidating
After you have set up the consolidated company and the business units and exported the necessary data, you are ready to do the consolidation. This means you can transfer the figures from the business units to the consolidated company.
Before you do this, it is a good idea to check whether there are differences between the basic information in the business units and in the consolidated company. There are two reports that you can use to test the database and file.
For more information, see How to: Export Business Unit Information and How to: Test Files Before Consolidating.
To test databases before consolidating
Open the consolidated company.
In the Search box, enter Business Units, and then choose the related link.
In the Business Unit List, on the Actions tab, in the Functions group, choose Test Database.
On the Business Unit FastTab, you can set a filter to select the business units to be tested. If you do not set a filter, all business units that are selected in Consolidate field will be tested.
On the Options FastTab, fill in the appropriate fields. For more information about a specific field, select the field, and then press F1. Choose the Copy Dimensions field and select the dimension codes.
Choose the Print button to print the report or choose the Preview button to view it on the screen.
Microsoft Dynamics NAV checks whether you have used account numbers or dimension codes that are not in the consolidated company. If any errors are found, they are listed in the report. If there is insufficient space to display all the errors on the screen, Microsoft Dynamics NAV prints a message.
If the report contains errors, you must correct them before you run the consolidation.
See Also
Tasks
How to: Process Consolidations
How to: Enter Basic Information for Consolidated Companies
How to: Enter Consolidation Information on General Ledger Accounts
How to: Export Business Unit Information
How to: Consolidate from Databases
How to: Consolidate from Files