Account import function

You can use the import function to import general ledger accounts from the flat file of the foreign general ledger system into the core ledger system.

We recommend that you perform this function on a regular basis or when changes are made to the chart of accounts.

Before using this function, you must establish the format and sequencing of the fields in the Export/Import Format Maintenance form within the Query module. You should define the import format over the CRPFI05 table. It is important that the import format and the source ASCII data being provided match exactly. If the Boolean flags for the Active and Posting Account fields are not specifically provided, then the system automatically assigns the values as "On". The Taxable field is only updated if the value is supplied in the import file. If the value is blank, then it retains the value currently in the Account Maintenance form.

When the account import function is selected from the General Ledger Interface menu, the displayed control form is a Query Module form (CQYC8010). The displayed form title is Account Import Control.

You can use this function to perform these tasks:
  • Amend and modify any field within the core general ledger account file
  • Add new general ledger account records
  • Remove any records where they exist in the core general ledger account file but do not exist in the new import file
    Note: You must select the Delete/Deactivate existing records not imported check box in the Account Import Control form.
  • Retain and produce an exception report for any general ledger account that exists in the core general ledger account file, not in the new import file

You can have a link to a parameter or code within any Pathway or Strategy module. The accounts are suspended and not deleted.