Sage 100: Out of Balance

Our system is reflecting an "Out of Balance" message when trying to reconcile our Bank Rec for month end. Now when converting quotes into sales orders and sending an email confirmation to our customers 1) it's not show all the lines items and 2) there is a message showing "Order Out of Balance".

Does anyone know what this means? On Monday, September 25th I did "Rebuild Sort Files" for the following modules AP, AR, Sales Order, Inventory Management, Return Merchandise Authorization, and Purchase Order. Would this have caused the "Out of Balance" issues we are now receiving?

Thank you!

  • 0

    Although the messages are the same they are two entirely different situations. In Bank Rec and out of balance message means the amount in bank rec for that bank does not match the amount in the GL.  This can happen when you flag a check or deposit that as cleared but is not present on the bank statement. Or you might have done a transaction that hit the GL account for the bank but did not hit the bank in bank rec, for example a general journal entry to record a bank transaction which does not hit bank rec.

    In the second situation in Sales Order if the form says Order Out of Balance this means the lines total in the detail file do not match the header totals.  This is an unusual situation and you might need to get your reseller/Sage support involved to see what is going on. 

  • 0 in reply to BigLouie

    Extra tip: always check for a blank bank code before running Rebuild Sort files for the BR module.  A blank record in GL_Bank can adversely affect that utility (corrupting some values...).