Cash receipts entry to AR leger not matching

Every once in a while i will try to enter a payment through the path

Accounts Receivable, cash receipts entry

and the invoice I want to pay will show a zero balance. If i simultaneously pull the invoice up using the path

Accounts Receivable, customer inquiry (or AR, Invoice History inquiry) 

the correct balance will show. 

I can enter the amount being paid, which prompts an alert verifying if i want to overpay. Once i post the "overpayment" the  customer inquiry (or AR, Invoice History inquiry) will show a zero balance but the cash receipts entry will always show the invoice as overpaid. 

Anyone else having this issue or know what is causing it or how to correct it?

  • 0

    Search Sage City for ARWAR4 and you'll find other posts related to that issue.

  • 0

    ARWAR4 is the old program name.  Starting with the 2021 version, there is a utility that you run from the File - Run - *utl menu.

    Cause

    Beginning with Sage 100 2021, the ARWAR4 is no longer available.

    Resolution

    1. Click OK on the error message
    2. In the Sage 100 Launcher, click File and select Run
    3. Program, *utl
    4. Click OK
    5. Highlight, "A/R Open Invoice Payments Today Utility" and click OK
    6. Click Proceed at the message, "This utility will recalculate the Payments Today field in the Accounts Receivable Open Invoice file. Important: Before running this utility, everyone must exit Cash Receipts Entry and AP from AR Clearing Entry."