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.

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

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.

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

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.

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

Select the “Company Code” and “General Ledger Module.”

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

 

Scroll down to find the GL_Period Posting History File.

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

Only check the GL_PeriodPostingHistory box.

Click “Proceed.”

The following warning will appear.

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

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.

Colleen Gutirrez

Colleen, a senior consultant with BKD Technologies, has more than 18 years of experience as a technology consultant, performing needs assessments and analyses and providing system selections, implementations, installations, training and support for a variety of industries. She also implements, supports and provides training on Sage ERP 100 and 500 accounting applications and Sage Intelligence.

Colleen Gutirrez – who has written posts on Sage ERP Insights.


Print Friendly, PDF & Email
The following two tabs change content below.
Colleen Gutirrez
Colleen, a senior consultant with BKD Technologies, has more than 18 years of experience as a technology consultant, performing needs assessments and analyses and providing system selections, implementations, installations, training and support for a variety of industries. She also implements, supports and provides training on Sage ERP 100 and 500 accounting applications and Sage Intelligence.
Colleen Gutirrez

Latest posts by Colleen Gutirrez (see all)

Tagged on: ,

Leave a Reply

Your email address will not be published. Required fields are marked *