General ledger is the core of accounting information summarizing all financial transactions into accounts and gathering all data into balances that will be used to prepare financial statements or for various other reporting purposes.
- Maintaining correct balances is crucial for reporting purposes
- Financial users may want to verify balances periodically to make sure they are accurate
In order to gather information needed for analyzing problems related to General Ledger balances, in addition to the usual period closure activities such as running specific diagnostics from Doc ID 1416402.1 that would spot balances issues, you should also consider our Glbalfix - Gl Balances Corruption Script.
We have gathered all the useful information related to Glbalfix script, from installation to detailing all checks performed, preparation and execution along with potential errors and suggestions to spot and eliminate the root cause prior to performing any fix, in this new document:
Glbalfix: GL Balances Corruption Script - Master Note (Doc ID 1563019.2).
Once installed, the script can be safely submitted to run anytime in report mode, to verify the balances only - here's a sample output:
Remember, running the script does not mean it would change any data, you can use it just to verify the balances are correct! If a problem is detected, you decide further if and when to fix it!
Why don't you give Glbalfix a try?