We often see a similar error. When a clerk aborts an entry of cash receipts after having begun, the invoice in question ends up with the entered amount remaining in the "PaymentsToday" field in the AR_OpenInvoice table. I don't recall that I have ever looked in the cash receipts program to see what balance shows, but this sounds like it might be the same error you are seeing.

Sage has a "fix" program you might call and ask about. I don't use that, I wrote something in MS Access to fix this when it occurs.

Jim
Independent Consultant, central Virginia area.
Sage 100 2017 Premium SQL, Starship, Scanforce, MS Access, MS SQL

Thank you Jim. I'll check it out.

File - Run - ARWAR4

Thank you Kevin.

Hello Kevin, I ran the program ARWAR4 last night and I'm not sure if it just fixed the problem that was causing the erroneous credit values in Cash Receipts for an already-paid invoice - so it would only fix the problem going forward - or if I should've expected the program to validate the InvBalance value in AR_CashReceiptsHistory compared to the AR_OpenInvoices InvoiceBalance. What I'm seeing is that there is no difference when attempting to post a Cash Receipt for the records in AR_CashReceiptsHistory - the erroneous credit amounts are still reflected. But if I review the AR_OpenInvoices InvoiceBalance field that same invoice # invoice balance shows as zero. I was hoping it would validate/update the AR_CashReceiptsHistory without having to go through the back door to correct balances. What I found is the following article for when the ARWAR4 utility doesn't work. Have you had any experience with the utility not working?  This is the article I found: https://support.na.sage.com/selfservice/viewContent.do?externalId=17964&sliceId=1

Thanks again for your response.

ARWAR4 has always worked for me, and I've used it many times.  Your scenario must be different than the one that this utility addresses.

This utility simply fixed the problem with the payments today field in the Open Invoice table (AR_OpenInvoice).