Example: Exceeding the Invoice Tolerance Limit

This example illustrates how the system applies a receipt to invoices according to the information provided in the F03B13Z1 table when the invoice tolerance limit, specified in the processing options for the Known Invoice Match With Amount algorithm, is exceeded.

Amounts

Settings

Receipt number 445 = 850.00

Invoice tolerance limit = 10.00

If the tolerance is exceeded, partially pay invoice

Receipt tolerance limit = 25.00

If receipt is underpaid, create a chargeback

In the Customer Ledger table (F03B11):

Invoice Number

Invoice Open Amt

Check Amt (CKAM)

Amt to Apply (AG field in F03B13Z1)

222

200.00

850.00

200.00

223

300.00

0

300.00

224

600.00

0

550.00

Credit Memo 1

200.00–

0

200.00–

You complete the Check Amt field only for the first invoice paid by the receipt. The system:

  • Pays invoice 222 in full, reduces the invoice open amount to zero, and changes the pay status to P.

  • Pays invoice 223 in full, reduces the invoice open amount to zero, and changes the pay status to P.

  • Leaves invoice 224 open for 50.00 because it exceeds the tolerance of the invoice. The pay status remains as A.

  • Pays the credit memo 1 in full, reduces the invoice open amount to zero, and changes the pay status to P.

The system verifies whether the invoice open amount equals the Amount to Apply to determine whether an underpayment occurred. Then, the system determines whether the total of the Amount to Apply for the whole receipt equals the receipt amount. If not, the system processes the receipt using the receipt tolerance amount.