Question #2: You get a call from a customer claiming that they paid and invoice and they you cashed there check. When checking this payment application history for this customer, you cannot find any reference to the payment. You want to know if you mis-applied the payment to another customer’s account.
Answer:
Go to Payment Application report under AR Reports
Under the tab called Report, for the field called Report Format: choose detail
On this tab, select range of period to encompass dates you are working with. (I.e. To / from range of Dates)
Next click on the Select Tab, and enter this expression in the three columns:
Field
Operator
Value
ar08820_wrk.adjgrefnbr
Contains
200008
Note: I recommend you save these values as a template for this report, so you can quickly run the report in the future.
You will see all payments using this specific check number string. Hopefully you can quickly determine which customer received the payment incorrectly.
Here is an example of this screen when we searched on a specific check number:
Report truncated to make it more visible in this presentation.
In this standard report, you see which documents were paid down by the payment and what dollars were paid against various invoices if payments applied across multiple documents.
Note: Don’t forget about the AR feature screen called, Application Inquiry / Reversal (08.240.00), which can quickly resolve the misapplication of funds.
