Solution:
This article clarifies how to recalculate General Ledger (GL) account balances.
Discrepancies in the GLBALS table can cause serious problems with critical financial reports such as the Income Statement and Balance Sheet. The Recalculate GL Account Balances function identifies and repairs out-of-balance batches and accounts. This feature replaces the FIXBALS and GLBLREC programs that were separately installed in previous versions.
Follow the steps below to execute this function:
Important
Create a full and verified backup before proceeding. The data in the tables will be updated when choosing to repair discrepancies.
- Open System Manager.
- Under the Transaction menu, point to System Recovery and click Recalculate GL Account Balances.
- Select all appropriate options and click Proceed.
- Click Yes when asked if ready to recalculate.
- Once complete, a message appears stating how many discrepancies were found and fixed.
- Click OK.
The recalculation routine performs a number of validations. Refer to the table below for a list of routines that will be fixed if Update Records was enabled in the option grid.
Recalculate Routines
| Validation | Update Records Enabled |
| Check for blank records | Records with a blank account number deleted |
| Check for duplicates | Duplicate records deleted |
| Check for missing records | Missing records added to the GL balance table |
| Check for unbalanced records | Unbalanced batches are reported but not corrected |
| Check posting amounts | Discrepancies in period-to-date debits, period-to-date credits, and year-end closing amounts in the GL balance table updated. |
| Check YTD amounts | Discrepancies updated |
| Checks fiscal year beginning balance amounts | Discrepancies updated |
| Checks file totals | Totals reported but not corrected |
