This batch job is used from a consolidated company to import entries from the business units that will be included in a consolidation. The batch job can be used if the business unit comes from the same database in Navision as the consolidated company. Before a business unit can be included in the batch job, it must be set up in the Business Unit table and have a check mark in the Consolidate field.
Business units that come from other databases in Navision must be imported with the Import Consolidation from File batch job.
The batch job processes all the entries in the business unit that must be included in the consolidation. The entries in the consolidated company are created from the entries in the business units. 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 sheet accounts. All exchange rate differences are calculated and posted afterward to 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.
You can define what will be included in the batch job by setting filters. You can select additional fields on the tab by pressing F3 and then clicking the AssistButton that appears to the right of the Field field. 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:
Code: Select the business units to be included in the batch job.
Click the up-arrow at the lower left-hand corner of the window to see the result of the filter you have defined for the table.
Starting Date: Enter the first date in the period from which entries will be imported. If you use a closing date, the starting date and ending date must be the same.
Ending Date: Enter the last date in the period from which entries will be imported. If you use a closing date, the starting date and ending date must be the same.
Copy Field Contents: Select here if you want the entries to be classified by shortcut dimension values when they are transferred.
Document No.: Enter the Document numbers on all the entries that will be imported.
Parent Currency Code: This field contains the currency code for the parent company. It is copied from the LCY Code field in the General Ledger Setup. It should only be changed if the business unit's Currency table refers to the parent company's currency using a different currency code.
Click OK to start the batch job. If you do not want to run the batch job now, click Cancel to close the window.