Sage 100

Client reports seeing invoices with balances in AR Cash Receipt Data Entry selection window that do not appear on the Aging or Trial Balance reports. They believe the invoices have been paid but want this disconnect fixed. Anyone know which file is used in Cash Receipts selection?

You need to run ARWAR4

Cash receipts uses the AR_OpenInvoice table. Aging and trial balance AR_transactionPayment table to calculate the balance based on the report date.

Sometimes the paid field in AR_OpenInvoice needs to be changed.

Thanks all. I'm going to check a sample of invoices. @BethBowers does this utility recompute balance due in AR Open based on Transaction Payment History?

If they are seeing negative balances (overpayment) in C/R Invoice Selection, then ARWAR4 should work. If positive balances, not sure the utility will work.

The utility clears the Paid Today field in Open Invoices. I've seen it work both way - positives and negatives. The balances are not actually incorrect, it's just the Paid Today that is screwing things up. That's why the Aging looks correct.

Of course. There's something similar for AP, isn't there?