Import Consolidation from File Batch Job

This batch job is used from a consolidated company to import entries from the business units that will be included in a consolidation if the business units come from a different database than the one that contains the consolidated company. Before this can be done, the entries from the business units must first be exported to a file with the Export Consolidation batch job. Only business units that are set up in the Business Unit table and have a check mark in the Consolidate field can be imported.

Business units that come from the same database in Navision as the consolidated company can be imported with the Import Consolidation from DB batch job.

The batch job processes all the entries in the file and imports them to the consolidated company. When the batch job has begun, a status message on the screen will indicate which business unit, as well as which account number and date, is being processed.

The date on the new entries in the consolidated company will be either the period's ending date or, if the Historical Rate is used as the Consol. Translation Method, the exact date. The amounts on the new entries in the consolidated company are converted from the business units' amounts by means of the information on the business unit in the following fields on Business Unit table: Consolidation %, Income Currency Factor and Balance Currency Factor, and also by means of the information on the business unit in the Consol. Translation Method field on the G/L Account table for each consolidated account.

The total is transferred to the accounts in the consolidated company that on the individual G/L accounts in the business unit are already set up as Consol. Debit Acc. or Consol. Credit Acc., depending on whether the total consists of a debit or a credit. If there are already entries for the business unit in the consolidated company, they will be overwritten and the following text will be attached: "Changed by consolidation on (work date)."

When you import Closing-Rate balance sheet accounts that already have a balance from a prior period's consolidation, it may be necessary to adjust the opening balance. By using the Balance Currency Factor and Last Balance Currency Factor fields, the program checks whether there are any exchange rate differences between the last import and the current one. If there is a difference, the opening balance on the balance sheet accounts is adjusted to the applicable exchange rate for the balance accounts. All exchange rate differences are calculated and posted afterward on the accounts for exchange rate gains and losses that are set up in the Business Unit table. A possible remaining amount is calculated for all the imported entries and posted afterward to the Residual account in the consolidated company.

Fill in the fields as follows:


File Format: Select the file format that you want to use for the consolidation. If the business unit whose data you are importing also has version 4.00 or later of the program, select the .xml format. Otherwise, select the .txt format.

File Name: Enter the name of the file (on diskette or hard disk) to be imported.

Document No.: Enter the document number to be used on all new ledger entries created from the consolidation.

Click OK to start the batch job. If you do not want to run the batch job now, click Cancel to close the window.