Consolidation - Test Database Report

This report tests all the financial data that are designated for consolidation in the Business Unit table and are found in the Microsoft Dynamics NAV database.

The report processes posted G/L entries in the business units' financial data and displays the G/L accounts and the global dimensions that in the individual business units are set up with a reference to the consolidated company but are not found in the consolidated company.

You can define what will be included in the report by setting filters. You can set additional fields on the tab by clicking the Field field, then clicking the AssistButton that appears to the right. You can also determine what is shown in the report by filling in the fields on the Options tab. Fill in the fields as follows:

Business Unit

Code: Select the codes for the business units to be included in the report. Click the AssistButton to the right of the field to see the options.

Click the up-arrow at the lower left-hand corner of the window to see the result of the filters you have defined for the table.

Options

Starting Date: Enter the first date in the period from which the business units' entries will be tested. If a business unit has a different fiscal year than the consolidated company, its starting and ending dates must be entered in the Business Unit table.

Ending Date: Enter the last date in the period from which the business units' entries will be tested. If a business unit has a different fiscal year than the consolidated company, its starting and ending dates must be entered in the Business Unit table.

Copy Dimensions: Select which dimensions you want to be included in the completed consolidated company.

Click the Print button to print out the report. If you want to see the report on the screen before printing, click the Preview button. If you do not want to print the report now, click Cancel to close the window.



© 2009 Microsoft Corporation. All rights reserved.