A customer wants to know how an overpayment on a check issued to us was applied, but customer cannot provide check number, date of check or amount of check.
Is there a way to find a customer’s check that had a unapplied amount for some period of time?
If the overpayment amount was not applied, then you should see it on the AR Aging Report as a Doc Type Payment, with the open balance available.
To find an unapplied payment in a prior period of time, edit the “Aged As Of Date” when you run the report.
In addition, if you filter the AR Payments and Applications screen (AR3020PL) by Type: payment, and balance is greater than zero, it will show any payments with unapplied balances.
The balance was applied at some point, so it is not reflected in current AR Aging
The balance was applied at some point, so it is not reflected in current AR Aging
I just updated my answer above to allow for that 
Sorry for not reading clearly the first time around.
Hello
To find a customer overpayment that is not open today but was open for at least one month, please try printing the AR Aged Period Sensitive Report, going backward one month at a time, until you see an open payment for the customer.
You may click on the open period directly in the report to open it, and then view the Applications tab of the payment to see where the balance was applied.
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.