| | How to use the Change Accounts utility in the General Ledger |
| Resolution | [BCB:1:Backup warning:ECB]
- Have all users exit Sage 100 ERP
- Update all journals.
- Open General Ledger, Setup, Main Account Maintenance. Verify that all the Main accounts for accounts to be changed are set to 'Active'. Create new Main Accounts if necessary.
- Open General Ledger, Setup, Sub Account Maintenance. Verify that all the segments for accounts to be changed are set to 'Active'.
- Open General Ledger, Utilities, Change Accounts.
- Select one of the following change types:
-
- Select Account to change a full account
- Select Segment to change a main segment or a sub account segment.
- Note: If Account is selected, the 'Segment' field displays 'Full Account' and cannot be changed.
- In the Starting Value field, select the starting value of the range to change. The entry must be a valid account or segment, and must exist in the General Ledger Chart of Accounts.
- In the Ending Value field, select the ending value of the range to change.
-
- Note: If the starting and ending values are the same and the 'New Value' field is not defined, the range of accounts or segments defined are renumbered.
- In the New Value field, enter the new value to apply to the range of accounts or segments selected.
- Select Recalculate Description to apply the description of the account entered in the New Value field to the new range of accounts or segments.
-
- Note: If Account is selected, the Short Description field from Main Account Maintenance or Sub Account Maintenance determines the description entered in the New Value field.
- To process the changes immediately, click Proceed. To delay the process, click Delayed.
- Click Print button to print a report of the changes entered and to verify that the information is correct.
Important Notes:
- The Change Accounts utility is irreversible. Always make a backup before performing this task.
- Multiple changes to accounts can be entered at one time. The changes are performed in sequential order.
- Specific accounts or segment values can be merged. The default action is to merge all accounts (or all accounts within specified segments) into the destination account or segment.
- Specific accounts or segment values can be renumbered. To renumber an account, specify the same value for the starting and ending value and a new value for the destination value.
- When accounts are deleted, account history is maintained for the account. In history, the user, time and date is recorded. The user who requested the change is recorded as the deletion user.
- Audit trail of account changes is only available if option is selected in General Ledger Options (under General Ledger, Setup)
- Memos are not merged into new accounts if more than one memo exists in the source account. Only the first memo is merged into the new account; subsequent memos are ignored.
DocLink: How to merge or renumber General Ledger accounts DocLink: How to create or change an Account Group
|
|