E1: 03B: AR/AP Netting Application (P03B455) Is Not Displaying Under the Manual Netting Grid the Credit Memos Documents (RMs) Created Based On Convert Unapplied Receipts to Credit Memos (R03B620) (Doc ID 2798003.1)

Last updated on OCTOBER 26, 2021

Applies to:

Symptoms

When using the Convert Unapplied Cash to Credit Memo process (R03B620) to create an RM credit memo document, that one does not appear under the grid of the AR/AP Manual Netting application (P03B455) to be eligible for netting. 

The RM Credit Memo documents that are created directly from Customer Ledger application (P03B2002) do appear under the AR/AP Manual Netting grid (P03B455), but not those RM credit memos created by Convert Unapplied Cash to Credit Memo process (R03B620).

      Steps to Reproduce:

1. Go to P01012 Address Book Master to create an address book record type C as Supplier Master and Customer Master:

- On P01012 set under tab Additional 1 the following: Payables Y/N/M = Y & Receivables Y/N = Y & AR/AP Netting = Y

- On P04012 set the Factor/Special Payee Number = Supplier Number

- On P03013 set the Alternate Payor number = Customer Number

2. Go to P0012 Work with AAIs and double-check on the NC AAI for the company to be used for testing.

3. Go to P03B102 and enter an unapplied receipt for the customer and company, then go to P0011 and post the RB batch.

4. Go to BV and set the Processing Options and Data Selection for the R03B620 Convert Unapplied Receipts to Credit Memos, then run it over the unapplied receipt previously entered, for the system to convert the unapplied receipt to a credit memo document, then post the transactions.

5. Go to P03B2002 Customer Ledger to create from P03B11 Standard Invoice Entry a Credit Memo for the same customer and company, then go to P0011 to post the newly created IB batch.

6. Go to P03B2002 and double check on the previously created RM transactions, and notice the Netting Status is equal to 1 for both of the credit memo documents: the one created based on R03B620 and the one created from P03B11.

7. Go to IV and double-check on the Processing Options of the P03B455 AR/AP Netting version to be used for netting to A/P, then launch it and notice while checking on the AR documents to be netted to AP that the credit memo created based on R03B620 does not show under the grid for UN-netted Documents, and does not show also under the grid of Netted Documents.

Then click on Add button from the main menu, to select the transactions to be netted and notice that after entering the Netting G/L Date, and Customer Number & Company Number & Currency Code and clicking on Find, the RM Credit Memo document created by R03B620 does not appear on the list, only the RM Credit Memo created based on P03B11 does appear in the list.

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.