This content was published prior to the merger of equals between BKD and DHG on June 1, 2022. See all FORsights for the most up-to-date articles, webinars, and videos.
Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances
If you ever wind up in this situation, the first thing to do is ensure you have a good working backup of your data. This function has the possibility of changing the information in the general ledger. Contact your Sage Business Partner for help.
Update transactions from all modules and post them to the General Ledger.
Confirm all users are logged off SAGE 100 ERP. This guarantees that no transactions are being updated when using this utility.
Select General Ledger | Utilities | Recalculate Account Balances.
This notice will immediately appear.
The timing of this varies and is based on how much history is being kept for that company code.
Recheck the balances. Be sure that “Year to Retain General Ledger History” is sufficient for the number of years containing data.
In this picture, you’ll only have data for two years of history. If an item was posted to 2012, you’d have to change the number of years to three. Then recalculate account balances and beginning balances (BB) for all three years should be visible.
If the issue persists, reinitialize GL PeriodPosting History. NOTE: If beginning balances were initially entered as a BB journal entry, they may need to be reentered after reinitializing this file.
To reinitialize this file go to Library Master | Utilities | Reinitialize Data Files.
The following warning will appear.
Select the “Company Code” and “General Ledger Module.”
Scroll down to find the GL Period Posting History File.
Only check the GL PeriodPostingHistory box.
Click “Proceed.”
The following warning will appear.
Select “Yes.”
Return to General Ledger | Utilities | Recalculate Account Balances and click “Proceed.”
If the balances still don’t match or you’re uncomfortable with this process, please contact us for additional help.
