Downloading Transactions

Downloading GL transactions from the source companies and loading these into the Group Consolidation entity is the main function of the InterCompany module. To download transactions:

Select Utilities > Download Transactions:

Set these options:

Field	Description
Company	Select the source company from the dropdown list.
Up to	Select the last Accounting Period that transactions should be extracted from.
Initials	The user initials entered here are recorded against the GL transactions created in the Group Consolidation Entity.
Level of detail	Select the level of detail for loading into the Group Consolidation Entity. This defaults to the option set for the Group Consolidation, but can be overridden here. Three levels are available: All Details - Individual GL Transactions from source companies will be loaded into the Group Consolidation Entity Summarised by period and branch - GL Transactions from the source companies will be subtotalled by Period, Branch, Account and Sub-Account. Summarised by period - GL Transactions from the source companies will be subtotalled by Period, Account and Sub-Account.
Validate GL account mappings	If selected, InterCompany checks that the GL account mapping is complete, with valid GL accounts in the target database.
Report GL mapping errors	If selected, InterCompany reports any GL account mapping differences.
Report GL batch imbalances	If selected, InterCompany checks that GL batches are balances on the source system. Out of balance batches are not downloaded.

Click Report to run a pre-check of the download. InterCompany performs the selected validations for the data to be downloaded.

Click Download to download of GL transactions from the selected source company to the Group Consolidation entity.

Note: InterCompany attempts to connect to the specified source company by using the name and password of the user who is running the InterCompany module. Therefore this username with the same password must exist in each of the source databases.

The Download Process

When you click Download:

If the source company is in foreign currency, InterCompany displays this window. Confirm the rates:

If the rates are incorrect, click Cancel and go to the Setup Conversion Rates window to change them.
InterCompany connects to source company’s database.
InterCompany checks to see if the accounting periods in the source company are aligned to those in the consolidation company, i.e. that the PERIOD_SEQNO field in the PERIOD_STATUS table for period 0 for the General Ledger is the same in both the source company and the consolidation company. By default, an error message will appear if the periods are not in sync, and the download will not proceed.

Note: This behaviour is controlled by the Inter-Company ledger period synchronisation Company-level profile setting. This setting is set to enforce synchronisation by default, but it can be set to allow transactions to be downloaded when periods are not in sync, or to warn the user and ask if they want to proceed.
InterCompany selects all GL transactions that have not yet been downloaded. GLTRANS.UPLOADED = "N".
InterCompany checks for GL Batches that are out of balance – these GL transactions will not be downloaded.
InterCompany checks the GL account mapping, and reports any errors.
InterCompany flags the GL transactions in the source database that they have been uploaded. GLTRANS.UPLOADED set to "Y".
InterCompany creates Other Equity Interest (OEI) journals, if the Calculate OEI option is enabled for this company in the Setup Source Companies window.
InterCompany creates GL transactions in the Group Consolidation database:
- Summarising if Level of detail is "Summarised by period and branch" or "Summarised by period".
- Converting the account codes according to the Setup GL Account Mappings window.
- Stamping source company code on the new GL transactions.