Changing multiple accounts from one Object code to another

Description of Issue

How can I change the object code on a lot of accounts without entering a change for each account separately?

How can I mass change the object code on accounts?

Context

11.3

Change General Ledger Account Codes

Cause

Object code changed and many accounts already exist with current object code.

Resolution

This process can only be completed when ALL users are off the system.  We recommend testing in a non-Live environment first and saving a backup of the database before updating in Live.

To update:

Financials > General Ledger Menu > Setup/Chart of Accounts > Change General Ledger Account Codes

  1. In the Change General Ledger Account Codes program, Click Account Change.

  2. Select Import Changes.

  3. Use Excel to create a file. 

  4. If you use Org/Obj/Proj, the import must include: Old Org, Old Object, Old Project, New Org, New Object, New Project, Account Status (optional) or

  5. If you use Long Account, the import must include:

    Old Fund, Old Seg2, Old Seg3, Old Seg4, Old Seg5, Old Seg6, Old Seg7, Old Seg8, Old Object, Old Project, New Fund, New Seg1, New Seg2, New Seg3, New Seg4, New Seg5, New Seg6, New Seg7, New Seg8, New Object, New Project, New Account Status (optional).  Delimiter used between segments must match delimiter designated in GL Settings. 

  6. Save the file as comma-delimited with .csv as the file extension.

  7. Click Define and select option.  Accept. 

Additional Information

Â