Testing 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 – that is, to transfer the figures from the business units to the consolidated company.

Before you do so, 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 for this purpose – one for testing a database and one for testing a file.

To Test Databases before Consolidating:

  1. On the menu bar, click File, Company, Open. Select the consolidated company from the list.

  2. Open the Business Unit List window.

  3. Click Functions, Test Database.

  4. On the Business Unit tab, you can set a filter to select the business units to be tested. If you do not set a filter, all business units that have a check mark in the Consolidate field will be tested.

  5. On the Options tab, fill in the appropriate fields. For Help about a specific field, click the field and press F1. In the Copy Dimensions field, click the Assistbutton and select the dimension codes.

  6. After filling in the tabs, click Preview to print the report to the screen or Print to print the report to the printer.

The program checks whether you have used account numbers or dimension codes that are not in the consolidated company. If it finds any errors, they are listed one by one in the report. If there is not enough space to display all the errors on the screen, the program prints a message.

If the report contains errors, you must correct them before you run the consolidation.

Related Topics

Processing Consolidations

Entering Basic Information for Consolidated Companies

Entering Consolidation Information on G/L Accounts

Exporting Business Unit Information from Databases in the Program

Consolidating from Databases

Consolidating from Files

Dimension



© 2009 Microsoft Corporation. All rights reserved.