GL Administrator Change Account Number Report overview
Function acronym: GLAC
Use this report to change an existing account code to a new account code. The account number field lengths will be compared with the SA Administrator Options-Financials-Acct Structure account size specifications. An error occurs if you specify account codes that exceed the size specified.
You can budget for accounts that have not been set up in the current budget period. If you have established new accounts while creating your budget, the GL Budget Setup account codes can be updated with the new account code if the account is not set up in GL Account Setup.
For example, when you created your budget for 2020, you created a new account code in GL Budget Setup called Utilities - Administrative, and you assigned the number 1-04-4100-07. After you finished your budget, you realize the account code should have a different number. You can change the account code to 1-04-5100-07 in the GL Administrator Change Account Number Report function.
You may have stored account numbers in modules with a wild card in the division section of the account number. For example, on the Customer Setup, you specified the AR Control account as * - 1-1111-01. The * designates all divisions, because you have several divisions with similar department, account, and sub account numbers for the AR Control account. GL Administrator Change Account Number Report will search for account numbers with a division wild card if you leave all ranges and the first two options blank. If you use Divisionalized Accounting, an account is changed in the setup only if the report options are used and if both the Old Div # and New Div # fields are left blank.
If Customer Transaction Entry and Vendor Invoice Center Entry have active invoices, the account numbers are changed on those invoices.
All records found within the account code parameters specified are changed to contain the new account code, including these files and fields:
| Function Name | Fields Updated |
|---|---|
| GL Account Setup | Account # |
| GL Budget Setup | Account # |
| GL Auto Distribution Setup |
Master Account Account # |
| GL Transaction Entry | Account # |
| SA Administrator Options-Financials-Profit Dist |
Account # Clearing Account |
| Vendor Invoice Center Entry | GL Distribution Account # |
| Vendor Setup-GL |
A/P Control Bank Discount Expense/Asset Addon 1 Addon 2 |
| Customer Setup-General |
Control Bank Discount Income |
| CR Bank Setup | G/L Account # |
| Product Warehouse Description Setup |
Addon Expense Addon Revenue Inventory In Transit Addon In Transit |
| Product GL Distribution Setup |
Cost of Goods Adjustment DO Sales DO Cost of Goods |
| SA Company Setup |
Suspense Debit Suspense Credit |
| SA Setup Local Taxes | State Tax Account City Tax Account County Tax Account Other Tax Account |
| SA Tariff Rate Setup |
Tariff Rate Account G/L Account # |
| SA Operator Setup-GL | All General Ledger default account codes |
| SA Currency Setup | Loss/Gain G/L Account # |
| SA Table Code Value Setup | Sales Order Entry, Purchase Order Entry Addon Codes Payment Types-Credit Card and ACH Petty Cash Transactions Return Adjust Reasons-Scrap Return Type |
| SA Sales Use Tax Setup | Cash Basis GL Tax Account #s |
| SA Administrator Options-Documents-Transfer Orders | Intercompany Transfers |