AR Cash Receipts - Sage Premier 2017 Ver 5.40.2.0

A very odd error that I believe is a bug - the customer received payment towards an invoice several months prior and properly shows a zero balance for that invoice. Now a new payment is received from that customer. If you look at Customer Inquiry, everything looks correct. But when selecting invoices to pay in the Cash Receipts Entry program, the payment amount previous received, often several months ago, is showing in the list as an outstanding credit balance. For example, invoice 12345 for $1,000 was paid in full in Sept. 2017. Now a new AR cash receipt is being posted. When the list of outstanding invoices screen opens, invoice 12345 shows an Inv Amount of $.00 but an Inv Balance of ($1,000.00). After some checking, it appears the problem occurs in the AR_CashReceiptsHistory table. I'm just wondering if anyone else has encountered this problem and if they have a solution.

Parents Reply Children
  • 0 in reply to Kevin M

    Thank you Kevin.

  • 0 in reply to DenyseM

    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.

  • 0 in reply to DenyseM

    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).