G/L Consolidations transfers account codes, segment codes, and source codes from the source company to the destination company.
When you consolidate these codes, you are importing the complete account code, segment code, or source code record into the destination general ledger.
If the record already exists in the destination ledger, it is updated with the new information.
Import will fail if the records being imported cause an invalid update.
For example, if a single currency account is imported to a ledger where the existing account is multicurrency, import will fail because you cannot change the multicurrency setting for an account back to single currency.
Using the Mapping Table to Consolidate Account Codes, Types, and Structures
You can consolidate companies with dissimilar account numbers, account types, and account number structures. The tool that lets you do this is the mapping table.
The mapping table lets you specify individual accounts that have different account numbers, structures, or settings from the equivalent accounts in the source ledger. This includes:
- Changing destination accounts—numbers, descriptions, structures, and consolidation options.
- Mapping multicurrency accounts to single currency destinations, and single currency accounts to multicurrency destinations.
- Changing exchange rate types.
The mapping table that is used during the export process is in the source company database.
You can use a mapping table to match source company accounts to destination company accounts as follows:
- Source company accounts can be matched to destination company accounts on a one-to-one basis, where account numbers are dissimilar.
- Source company accounts can be matched to destination company accounts on a many-to-one basis, if you need to merge source accounts.
- Source company accounts and destination company accounts can have different consolidation options or different multicurrency settings.
- The rate types for individual accounts can be different from the default rate type (where translation occurs).
Tip: We strongly recommend that both the exporting and importing companies have the same account structure codes. If they do not, you should use the mapping table to map all exported accounts. For more information, see G/L Consol. Mapping Table.
About Multicurrency and Single Currency Account Consolidations
If you are consolidating accounts, you must use the mapping table to export account records from a single currency company to a multicurrency company – or from a multicurrency company to a single currency company.
Note: You cannot import account data to an account with a different multicurrency/single currency setting.
Restrictions on Consolidating Account Codes, Segment Codes, and Source Codes
The main restrictions to consolidating involve transferring accounts between multicurrency and single currency ledgers.
The rule is that you can only import accounts that you can save in the destination ledger. This means, for example, that you cannot import:
- Multicurrency accounts in a single currency destination.
- Single currency accounts that replace multicurrency accounts in the destination ledger.
- Segment codes that are the wrong length or that are for a segment that does not exist in the destination ledger.
- Accounts that use allocation accounts that do not exist in the destination ledger.
- Accounts with account groups that do not exist in the destination ledger.
For more information, see Troubleshooting Import Problems.