E1: 03B: Known Invoice Match With Amount (R03B50D) Does Not Match Part of a Credit Memo’s Amount to an Invoice Via A Zero Amount Receipt (Doc ID 2789944.1)

Last updated on DECEMBER 27, 2022

Applies to:

Symptoms

When processing a zero amount receipt via the Auto Receipts functionality, the system incorrectly does not match the selected credit memo to the selected invoice and creates an unapplied cash receipt (RU) record instead. This happens only when only part of the credit memo’s amount is used to match to the invoice.

The processing options of the Known Invoice Match With Amount (R03B50D) algorithm on the Apply Invoices tab are set to partially apply the receipt and to over-apply the receipt.

For example, the credit memo’s open amount is -240.00 and the invoice’s open amount is 200.00. When using only -200.00 of the credit memo’s open amount (which should leave -24.00 opent), the Known Invoice Match With Amount (R03B50D) algorithm does not process the credit memo.

If the situation is reversed, where the invoice has 240.00 open and the credit memo that has -200.00 open, the two are spread against each other.

STEPS TO REPRODUCE

1. In Batch Versions, BV, set up a R03B50D version
2. P03B50: assign R03B50D version to an Execution List
3. P03013: assign the Execution List to a customer’s Customer Master record
4. P03B2002/P03B11: create an invoice and a credit memo for this customer with the following values:
   1. Invoice:
      1. Invoice & GL & due dates: 2-Jun-2021
      2. Gross and open amounts: 200.00
   2. Credit memo:
      1. Invoice & GL & due dates: 2-Jun-2021
      2. Gross and open amounts: 224.00-
   3. R09801: post the invoice and credit memo
   4. P03B121: create an electronic receipt for a zero amount and match the credit memo to the invoice; use 200.00 +/-
   5. Run R03B551 which should launch R03B50 from its processing options
   6. Review results in:
      1. P03B102
      2. P03B2002

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.