Example: Applying a Receipt to an Invoice with Multiple Pay Items

When you use the Known Invoice Match With Amount algorithm to pay invoices with multiple pay items, you should specify the pay item in the F03B13Z1 table. If you do not specify the pay item, the system uses the Balance Forward Match algorithm (R03B50B) to process each pay item.

In this example, the system processes only the first pay item because the receipt amount applied of 100.00 is less than the open amount of the first pay item.

Amounts	Settings
Receipt number 447 = 100.00
Invoice tolerance limit = 10.00	If the tolerance is exceeded, partially pay invoice
Receipt tolerance limit = 25.00	If the receipt is underpaid, create a chargeback

In the Customer Ledger table (F03B11):

Invoice Number	Pay Item	Invoice Open Amt
932	001	150.00
932	002	50.00–

In Review Electronic Receipts (P03B121):

Invoice Number	Pay Item	Invoice Open Amt	Check Amt (CKAM)	Amt to Apply (AG field in F03B13Z1)
932		150.00	100.00	150.00
932		50.00–		-50.00

The system closes the first pay item for invoice 932 instead of closing the entire invoice, and creates a chargeback of 50.00 for the first pay item. The second pay item is still open.

To apply in full the same receipt to invoice 932 using Known Invoice Match With Amount (R03B50D), you must specify the pay item number in the F03B13Z1 table. In Review Electronic Receipts:

Invoice Number	Pay Item	Invoice Open Amt	Check Amt (CKAM)	Amt to Apply (AG field in F03B13Z1)
932	001	150.00	100.00	150.00
932	002	50.00–		50.00–

The system:

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

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