Invoice Resolved with Receiver Cost Adjustment Remains in Matched Status (Doc ID 1406033.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Invoice Matching - Version 13.1.4.1 and later
Information in this document applies to any platform.

Symptoms

Invoices remain in Matched status when cost resolution is performed with Receiver Cost Adjustment (RCA). 

In the situation where multiple invoices are received for every shipment against a single Purchase Order (PO) and the supplier keeps sending invoices either at a lower or higher unit cost which are then resolved with RCA reason code, then the first cost resolution posts successfully. Any consecutive cost resolution does not post, which results in Invoices appearing in 'MTCH' status and the relevant line in IM_INVOICE_DETAIL table has the value Y in the ADJUSTMENT_PENDING column.

Steps to recreate:

1. Create a Purchase Order (PO) with quantity 10 and unit cost of 1200.
2. Receive the PO in two shipments: first receipt with quantity of 6 and second receipt with quantity of 4.
3. Create an invoice for the first receipt with quantity 6 and unit cost 1000.
4. Run 'reimautomatch' batch.
5. Create an RCA for the invoice created in Step 3 as the default invoice.
6. Run 'reimrollup' and 'reimposting' batch.
7. Create the second invoice and detail with quantity 4 and unit cost 800.
8. Run 'reimautomatch' batch.
9. Create the second RCA for the second invoice created in step 7 with the invoice cost 800.
10. Run  'reimrollup' and 'reimposting' batch.
Note:
Actual: The second RCA stays in a U status and hence the second invoice does not get posted.
Expected: The second RCA should get rolled up and the second invoice should get posted.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms