This batch job is used in a business unit whose entries must be exported to a consolidated company. When the consolidated company is set up, all the entries must be imported from the Business Unit table in the consolidated company with the Import Consolidation from File batch job.
All the entries in every G/L account are processed. For every combination of global dimensions and date, the contents of the entries' Amount fields are totaled and exported. Afterward the next combination of global dimensions and date with the same account number is processed; then the combinations in the next account number are processed, and so on.
The exported entries contain the following fields: Account No., Posting Date, Debit Amount, Credit Amount, Add.-Currency Credit Amount, and possibly dimension codes.
The Date used is either the period's ending date or, if the Historical Rate is used as the Consol. Translation Method for the account, the exact date of the transaction.
You can define what will be included in the batch job. Fill in the fields as follows:
File Format: Select the file format that you want to use for the consolidation. If the parent company that will perform the consolidation 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) that the data will be exported to.
Starting Date: Enter the first date in the period from which entries will be exported. 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 exported. The period defined in the Starting Date and Ending Date fields cannot be longer than 500 days. If you use a closing date, the starting date and ending date must be the same.
Copy Field Contents: Place checks in the boxes if you want the entries to be classified by Dimensions when they are transferred.
Parent Currency Code: Select the currency code of the company that will perform 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.