Shipsku Quantity Matched Not Updated Properly for Items Shipped in Multiple Cartons on the Shipment

(Doc ID 2018036.1)

Last updated on NOVEMBER 02, 2017

Applies to:

Oracle Retail Invoice Matching - Version 14.1 and later
Information in this document applies to any platform.
Checked for relevance on 02-November-2017

Symptoms

In Oracle Retail Invoice Matching (ReIM), when the Automatch batch attempts to detail match an invoice to a receipt which has the same item shipped in multiple cartons, the QTY_MATCHED value in the SHIPSKU table is not updated properly. 


Steps to Reproduce:

  1. Create two items: Item1, Item2 with a cost of 50.
  2. Create a purchase order (PO) for 100 units of each of the above items.
  3. Receive the PO in one shipment such that:
    - Item1 arrives in two different cartons. (40 units and 60 units respectively)
    - Item2 arrives in one carton.
  4. Create an invoice for this PO with Item1 matching the receipt cost and quantity; Item2 has cost discrepancy.
  5. Run Automatch batch so that it attempts detail level matching.
  6. Observe that Item1 is matched to the receipt as expected, but the QTY_MATCHED on each SHIPSKU line of Item1 is updated with the total quantity received for Item1 (100), which is not expected. It should be equal to the quantity received on each line.

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