Example: Exceeding the Receipt Tolerance Limit

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

Amounts

Settings

Receipt number 446 = 700.00

Invoice tolerance limit = 10.00

If the tolerance is exceeded, partially pay invoice

Receipt tolerance limit = 10.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)

300

1,000.00

700.00

1,000.00

Credit Memo 2

100.00–

0

100.00–

In this example, assume that the bank sent incorrect information. The check amount is 700.00, but the amount needed to apply is 900.00, based on an invoice open amount of 1000.00 plus a 100.00 credit memo. Because the tolerance amount on the receipt is set to 10.00, the system views this as exceeding the tolerance limit by 200.00 and generates a chargeback.

The system:

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

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

  • Generates a chargeback for 200.00.

If the customer wants to partially pay the invoice, change the amounts as follows:

Invoice Number

Invoice Open Amt

Check Amt (CKAM)

Amt to Apply (AG field in F03B13Z1)

300

1000.00

700.00

800.00

Credit memo 2

100.00–

0

100.00–

Because the amount to apply is 700.00, which is equal to the check amount entered, no tolerance is affected. And because the amount to apply for invoice 300 is 800.00, which is 200.00 less than the open amount (1,000.00), the system partially pays the invoice with 200.00 remaining open.