Changing, Merging, or Moving an Account to another Folder

An account number can be changed which may also require the account to be moved to another folder.   Changing the general ledger code within EBMS requires a few quick steps.   This change will retain the transaction history.  The general ledger account can be changed using one of the following processes:

Two accounts can be merged into a single general ledger account without losing any history.   This process is ideal if the financial manager decides to combine general ledger accounts.   This preferred process rather than making one of the accounts inactive, consolidates the history of both accounts.    The merge process can be completed using either of the following processes:

Change a General Ledger Account and Move to another Folder

The Change ID option allows the user to move an account to another folder as well as to change the account number.

NOTE:  It is not recommended that a General Ledger code be changed without proper consultation with an accountant or financial officer.

  1. Open the general ledger account by selecting Chart of Accounts from the Financials menu and selecting the account that must be changed. Right-click on the G/L Account with the mouse to open the context menu

  2. Select Change ID from the context menu.

  3. Enter the new General Ledger account number and click the OK button.

  4. Go to the Financials > Options > General Ledger Folders tab and click the Properties button to view the allowable range for any general ledger folder. Review the  Financials > Chart of Accounts > Chart of Account Folders section for more details on the allowable range of an account.

  5. The following dialog will appear if the new account code is not within the allowable range contained in the general ledger folder. Review the Chart of Accounts Folders section for more details.

  6. Click the Yes button to move the account and the following Choose Folder dialog will appear:

  7. Select the folder that you wish to place the changed account into. Note that the new account code must be within the Allowable Range of the selected folder. Click the Properties button to view the allowable range of any available folder. Click the OK button to continue and the following message will appear unless the account cannot be placed within the selected folder:

  8. Click Yes to continue. This process could require five or ten minutes to complete the change, depending on the amount of data within EBMS. No user should be posting any transactions during this process. This process will scan all history files and change the General Ledger code from the original account to the new account including journals, invoices, advanced tab settings, etc. THIS PROCESS MAY NOT BE ABORTED.

Batch Change Merge Account Codes

A entire list of general ledger accounts can be changed using a batch process within EBMS.   This utility uses a spreadsheet list of the old accounts and new accounts and changes them as a batch.  

Complete the following steps to batch change and/or merge general ledger account codes:

  1. Create a parallel lists of account codes within a spreadsheet or CSV file:  Create one list with the current GL account and a parallel list with the new GL account.  

    This spreadsheet or CSV file can be created manually or exported from EBMS.  Review [Main] Features > Exporting to CSV Files for more exporting lists including a list of accounts.

  2. Create a new column if the column does not exist.

  3. Populate the New Account column with one of the following GL accounts:   

    1. A new GL account code which prompts a change ID process.  This process will replace the old account with the new account code.  Verify that the  All history will be maintained with the account change.

    2. An existing GL account code which prompts the merge process.  This process will merge the old id history with the new or existing GL account.   Warning:  This process can not be reversed.  

  4. Verify the following relationship between the original Account and the New Account before continuing with the next step.

    1. The account Type is the same:   The account Type is found in the general tab of the account.  The account type must match the Type of Accounts setting within the account folder.

    2. The Allowable Range found in the folder properties of the account.   Note that the new account code must fit within the range of the old account's folder.   Review Chart of Account Folders for instructions to broaden the Allowable Range if needed.

  5. Make a copy of the EBMS data before continuing if information is being merged.

  6. Map the original and new account columns using the File > Utilities > Text Import/Export Mappings utility as shown below:

    1. Enter a Description to identify the change GL account process.

    2. Set the spreadsheet or CSV file as the Text File

    3. Click on the From Text File button to generate mapping.   The system should map both the original account and the new account properly without additional configuration.  The other columns do not need to be mapped.  Review [Main] Utilities > Text Data Import and Export Utility > Overview for more details on this mapping utility.

    4. Click OK to save the mapping.   Do not use the Update Data, Replace Data, or Create Data buttons.  

  7. Select Financials > Utilities > Change/Merge Account IDs from the main EBMS menu.

  8. Select the Mapping description file created in the previous step.

  9. Select the Old ID Field setting that identifies the original GL account.

  10. Select the New ID Field that identifies the column that contains the new account or the merge GL account.

  11. Disable the Perform a merge if new ID already exists only if no general ledger accounts should be merged.  Enabling this option will merge any account that already exists within the New ID Field column.  Warning:  A merge can not be reversed.  

  12. Click OK to complete process