My Oracle Support Banner

E1: 03B: Known Invoice Match With Amount (R03B50D) Incorrectly 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 JULY 06, 2021

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Programs involved:

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.

This is even though 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 open on it), the Known Invoice Match With Amount (R03B50D) algorithm does not process the credit memo at all. 

If the situation is reversed, so it’s the invoice that has 240.00 open on it and the credit memo that has -200.00 open on it, the two are spread against each other.

 

STEPS TO REPRODUCE

  1. BV: set up 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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