After you set up G/L Consolidations, the process of consolidating general ledger data is very straightforward. You can consolidate account nets and balances, transactions from a fiscal period or range of posting sequences, budget balances, source codes, segment codes, accounts, optional fields, account groups, and transactions.
In the simplest case, you perform the following steps:
- Export data from the branch general ledger.
For more information, see Exporting General Ledger Data.
- Send the exported data to the head office.
If the head office general ledger is on the same network as the branch office, the exported data can be easily copied to the directory used by the head office.
- Import the data to the head office general ledger.
Importing data replaces information in records that already exist. For example, if you import budget data for an account that already exists in the head office database, the imported information will replace the original head office information, which also means that you cannot import a single-currency account that replaces an existing multicurrency account.
The import process performs the following steps:
- Creates batches for all transactions you are importing, such as account balances, net amounts, or transactions for a fiscal period or range of posting sequences.
- Adds account information, account code segments, source codes, account groups, budgets, and optional field data directly to the head office general ledger database.
Note: You cannot change the sort code of an account group that already exists in the destination company.
- Post the imported transactions.