E1: 03B: Apply Receipts to Invoices (R03B50) Does Not Select Negative Unapplied Cash Receipts (RUs) If Processing Option No. 3 on the Default Tab, Override G/L Date, is Set To 1 (One). (Doc ID 2847993.1)

Last updated on DECEMBER 01, 2022

Applies to:

Symptoms

When a negative unapplied cash receipt (negative RU), created originally via the Auto Receipts functionality, is reprocessed by Apply Receipts to Invoices (R03B50), because it was not matched successfully to a credit memo (RM) the first time, it is again not matched to the RM. This is even though the RU was posted via the General Ledger Post (R09801) before reprocessing it via R03B50. This is only happening if processing option no. 3 on the Defaults tab of R03B50 is set to a 1 (one) to override the G/L Date. 

If this processing option is set to blank to not override the receipt G/L date, then the negative RU is matched to the RM the first time around.

The following is the Help text of R03B50 processing option no 3 on the Defaults tab:

Override G/L Date

Use this processing option to specify whether the system uses a G/L date to process automatic receipts that is different from the G/L date on the Receipts Header record (F03B13). You might want to override the G/L date if the receipt is in a fiscal period that is prior to the invoices that it pays. Valid values are:

Blank:                  Do not override the receipt G/L date.

1:                           Override the receipt G/L date.

Note: The system overrides the G/L date only when the receipt batch is posted. For drafts, the acceptance batch must be posted.

STEPS TO REPRODUCE

1. Batch Versions: set up versions of R03B551, R03B50, and R03B50D:
   1. R03B50:
      1. Defaults tab:
         1. Set PO#3 = 1
      2. Process tab:
         1. Set PO #4 = 3
   2. R03B551:
      1. Versions tab:
         1. Set it to automatically run the R03B50 version from Step 1a
   3. R03B50D
2. P03B50: set up an Execution List with just the R03B50D version on it
3. P03013: assign this Execution List to a customer
4. P03B2002/P03B11: create a credit memo for this customer for -120.88
5. P03B121: create a partial e-receipt for this credit memo for -60.44.
6. Run R03B551, which calls R03B50 which calls R03B50D
7. Verify results via:
   1. P03B121: note that the Upload Status is H
   2. P03B102: note that there is an RU: the e-receipt was not applied to the credit memo
   3. P03B2002: note that there is an RU: the e-receipt was not applied to the credit memo
8. R09801: post the RU
9. Run R03B50 on its own, which should kick off R03B50D:
   1. Note that on Work with Submitted Jobs R03B50D was not kicked off.
   2. The R03B50 PDF shows a “No Data Selected” message on the second page. 

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.