Examples: Negative Value Receipt Applied to Credit Memo (Release 9.2 Update)

Known Invoice Match With Amount (R03B50D) Examples

This example illustrates how the system applies a negative value receipt to multiple credit memos using the Known Invoice Match With Amount algorithm. The Receipts Processing processing option in the Apply Receipts to Invoices report (R03B50) is set to 1 (process negative value receipts) or 3 (process all receipts). The receipt amount is -250.

The invoice amounts in the Customer Ledger Inquiry program (P03B2002) are:

Invoice Number

Invoice Open Amount

150

-100.00

151

-50.00

152

-100.00

When you run the R03B50 report, the system applies invoices in the Review Electronic Receipts program (P03B121) as follows:

Invoice Number

Invoice Open Amt

Check Amt (CKAM)

Amt to Apply (AG field in F03B13Z1)

150

-100.00

151

-50.00

152

-100.00

Review how the system applies a negative value receipt in various situations when using the Known Invoice Match With Amount algorithm:

  • If there is an underpayment and if the amount is within the tolerance amount, the system applies the invoice and creates a write-off.

  • If there is an underpayment and the amount is above the tolerance amount, the system applies the invoice and creates a chargeback, deduction, or partial invoice, depending on the setting of the Processing Underpayments processing option in the Known Invoice Match With Amount report (R03B50D).

  • If there is an overpayment and the amount is within the tolerance amount, the system applies the invoice and creates a write-off.

  • If there is an overpayment at the invoice level and the amount is above the tolerance amount, the system applies the invoice and the over applied amount is unaccountable, depending on the R03B50D processing option settings.

  • If there is an overpayment at the receipt level and the amount is above the tolerance amount, the system does not apply the invoice because a negative unapplied receipt is not allowed.

Known Invoice Match Without Amount (R03B50E) Examples

Review how the system applies a negative value receipt in various situations when using the Known Invoice Match Without Amount algorithm:

  • If there is an underpayment and if the amount is within the tolerance amount, the system applies the invoice and creates a write-off.

  • If there is an underpayment and the amount is above the tolerance amount, the system applies the invoice and creates a chargeback or a deduction depending on the setting R03B50D processing options.

  • If there is an overpayment and the amount is within the tolerance amount, the system applies the invoice and creates a write-off.

  • If there is an overpayment at the receipt level and the amount is above the tolerance amount, the system does not apply the invoice because a negative unapplied receipt is not allowed.

Invoice Selection Match (R03B50A) Example

This example illustrates how the system applies a negative value receipt to multiple credit memos using the Invoice Selection Match algorithm. The Receipts Processing processing option in the Apply Receipts to Invoices report (R03B50) is set to 1 (process negative value receipts) or 3 (process all receipts). The receipt amount is -300.

The invoice amounts in the Customer Ledger Inquiry program (P03B2002) are:

Invoice Number

Invoice Open Amount

124

-100

125

-100

126

-150

In this example, the system does not process the receipt because the invoice amount or running total of the invoice amounts does not match with receipt amount, and a negative unapplied receipt is not allowed.

Balance Forward Match (R03B50B) Example

This example illustrates how the system applies a negative value receipt to multiple credit memos using the Balance Forward Match algorithm. The Receipts Processing processing option in the Apply Receipts to Invoices report (R03B50) is set to 1 (process negative value receipts) or 3 (process all receipts). The receipt amount is -300.

The invoice amounts in the Customer Ledger Inquiry program (P03B2002) are:

Invoice Number

Invoice Open Amount

131

-100

132

-100

133

-150

When you run the R03B50 report, the system applies invoices in the Review Electronic Receipts program (P03B121) as follows:

Invoice Number

Invoice Open Amt

Check Amt (CKAM)

Amt to Apply (AG field in F03B13Z1)

131

-100.00

132

-100.00

133

-50.00

-100.00