/
Changing multiple accounts from one Object code to another

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

 

Related content

Changing multiple accounts from one Organzation code to another in the same fund
Changing multiple accounts from one Organzation code to another in the same fund
More like this
Change general ledger account codes - account change
Change general ledger account codes - account change
More like this
Changing an Account From One Object Code to Another
Changing an Account From One Object Code to Another
More like this
Is there an option to Mass update organization codes
Is there an option to Mass update organization codes
More like this
Copy all Existing Accounts from one Org Code to another Org Code
Copy all Existing Accounts from one Org Code to another Org Code
More like this
Without Manually Entering, Mass Creating Object Codes for all Funds
Without Manually Entering, Mass Creating Object Codes for all Funds
More like this