FAQ #: 26
My customer balances on the main screen in Customer Inquiry are not correct.


The customer balances are maintained on the Customer Master File. These balances are normally updated anytime activity takes place that affects the customer balance, such as new invoices posted or payments applied. There are times however, when the balance may not be updated properly. This can be due to power failures, PC's hanging up, or programs terminated abnormally by the user (such as with CTRL+ALT+DEL).

The easiest way to clean up the customer balances and reset them is to run the Detail Aging Report by Customer #. This report first zeroes out the customer balances and then it re-calculates the appropriate balance for each bucket as it goes through the open items on the customer's account. Running the Detail Aging by Customer # will reset all the balances on customer accounts. It is not necessary to print the report, it can be run and viewed on screen if desired.