/
Account Import Functionality

Account Import Functionality

Description of Issue

Site has a number of new accounts they need added to the chart of accounts. 

Context
  • Account master 

  • Account Import 

  • Chart of Accounts

Cause

Resolution

The account import functionality can be used to import GL accounts, Project Ledger Strings, and Cross reference account relationships. To use this function the account segments must already exist in EERP. 

General Ledger> Set up/ Chart of Accounts > Account Import

  1. Create template to generate a template based off your chart of accounts

  2. Define desired segments and column values, save

    1. Budgetary should be populated with a Y if you want to have the account used for budget

    2. Minimum required is Org and Object or full account segments. Other fields can be blank. Object settings will be used to populate account settings if not specified otherwise in file. Refer to help screen for more information.

  3. Define

  4. Select newly saved file

  5. If errors or warnings are shown in the define results select display to view error

  6. import

Additional Information

New account imports can be tested in a non-live server like TEST or TRAIN before moving to LIVE.