Mapping Accounts and Unit Codes for Imported Journals from Other Sites

Use the Account Cross Reference utility to map account/unit code combinations on the current site with account and unit code combinations on other sites. The other sites might be using an external financial system. The old and new account and unit code combinations are used by the Import Journal utility when it loads journal entries into the current site. During the data loading process, the account/unit code combination from the source entries are examined to determine whether it matches any account/unit code combinations that already exist in the application. If a matching combination exists, the source combination is substituted with the new account/unit code combination. If a matching combination does not exist, an error message is displayed.

To create the cross reference:

  1. Specify this information in the Account Cross Reference Utility:
    Old Account and Old Unit 1-4
    Specify the account and its corresponding unit codes that are used at the source sites.
    New Account and New Unit 1-4
    Specify the accounts and any unit codes that are to be used as replacements at the current site.
  2. Save your changes.
Related topics