FAQ #: 25
My customers either have zero balance or no balance at all. What happened?

One of the things that the Detail Aging Report by Customer does is to zero out all the balances on the customer accounts. Then, as the open items are processed, the balances are re-calculated and totaled up. They are then updated onto the customer's account.

If the Detail Aging Report by Customer is started, but does not finish properly, or if you use a cut-off date that does not pick up all the open invoices and payments, then the balances may not be accurate. The Detail Aging Report by Customer is run automatically at night, so if it was interrupted during the day-end process and did not complete, it can result in this situation.

Re-running the report with the most current cut-off date will reset the balances.

One other note: if you need to run a report to get customer balances at the end of a specific period, other than the current period, you should run either the Summary Aging Reports, or the Detail Aging by Alpha Key or Salesman. These reports do not reset your customer balances. Also, keep in mind that the only way you can get valid balances for a previous period is if the monthly purge has not been run to remove paid invoices to history.