Click Validate to check that the source account numbers are correct. Any invalid numbers will be deleted from the list.
Select an existing mapping table, or enter a code to create a new mapping table.
Enter the closing segment number for the target account. If you leave this field blank, the program uses the closing segment of the source account.
Specify whether you are exporting from a single currency company to a multicurrency company.
- Yes. Select Yes if the destination account in the destination company is multicurrency, and the account in the source ledger is single currency.
- No. Select No if the destination account in the destination company is single currency, and multicurrency in the source ledger.
- N/A. Select N/A to use the setting of the source account in the source company.
Example: If the source ledger is set up as single currency with a functional currency of USD, and the destination ledger is set up as multicurrency with a functional currency of CAD, select Yes. Upon successful import in the destination ledger, both the source currency (USD) and the functional currency (CAD) will be displayed in the transaction exported to the destination ledger.
- You can change a single currency account to a multicurrency account.
- You cannot change a multicurrency account to a single currency account.
- If you select Yes (that is, a single currency account in the source ledger becomes a multicurrency account in the target ledger), G/L Consolidations assumes that all currencies are valid for that account in the target ledger.
Specify the type of posting to use:
- Consolidate. Select if the target account in the destination company is "consolidated."
- Detail. Select if the target account in the destination company is "detailed."
- N/A. Select to use the setting of the source account in the source company.
If currency translation is relevant for the consolidation process, use this field to specify a different rate type from the default rate type.
This lets you ensure compliance with Generally Accepted Accounting Principles when certain account balances need to be translated using different rate types. For example, you may have to translate some account balances at spot rates, others at average rates, and others at historic rates. All these rate types can be set up and recorded in the mapping table to ensure consistent application of the different rate types.
G/L Consolidations uses the default rate type specified on the G/L Consol Export Setup screen for the export process.
This field displays the description of the rate type.
Specify the general ledger account number for the account in the source ledger that you want to map.
The source account description is provided for information purposes and cannot be changed.
Enter the account number for the account in the destination company that you want to map to. If this field is empty, the program uses the source account number.
Enter a description for the target account. If this field is empty, the program uses the description for the source account.
Enter the general ledger account structure code for the target account. If this field is empty, the program uses the general ledger account structure for the source account.
Overview
Use the G/L Consol Mapping Table screen to specify how individual accounts can be consolidated, created or converted.
Note: Using a mapping table is optional in the G/L Consolidations process.
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).
For more information about consolidating information, see About Consolidating Account Codes, Segment Codes, and Source Codes.
For setup instructions, see Setting Up a Mapping Table.