Item-Level Adjustments and Reference Values

If Payment Predictor creates new on-account, underpayment, overpayment, prepayment, or deduction items when it applies a partial payment, it assigns the reference information that is provided with the payment to the new items. The process uses the reference qualifier code in the Payment ID Item table (PS_PAYMENT_ID_ITEM) to determine what reference field to populate for the new item. If a payment has multiple references, the process retains all the reference values unless multiple references exist for the same reference qualifier code.

This table provides an example of how the process assigns reference values if multiple references exist:

Reference Qualifier Code	Reference Value	Action
I (item)	Item100	Does not assign reference value to new item.
I (item)	Item200	Does not assign reference value to new item.
O (order)	Order100	Assigns reference value to new item.
P (purchase order number)	PO100	Assigns reference value to new item.

The process populates these fields with reference values:

• Document

• Item ID

• Bill of Lading

• Letter of Credit

• Order Number

• PO Ref (purchase order reference)

• SubCustomer1

• SubCustomer2

If the reference value has the I (item) reference qualifier code and the value is the same as the item ID for the new item, the process places the reference value in the Document field.

This functionality enables you to match new credits and debits with the items that Payment Predictor creates using the Automatic Maintenance process (AR_AUTOMNT). To match the items, you should build automatic maintenance methods that match items by the appropriate reference fields and item amounts. This functionality is very useful if you use the Cash Drawer Receipts feature to enter payments and deposits for counter sales.