My Oracle Support Banner

ReIM Is Causing Shipment Items To Match Twice When Invoice Is Matched Partially At Detail & Summary (Doc ID 2525239.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

ReIM is causing shipment items to match twice when invoice is matched partially at detail & summary

ReIM does not update the shipment tables or the history tables correctly when an invoice is matched partially at the detail level and the remaining at the summary level. This results in an over payment situation.

1. Create an Order with Item1, Item2, Item3, Item4 and item5
2. Ship and receive (say Shipment-1) for Item1, Item2 and Item3
3. Create an invoice with Item details as Item1, Item2 and Item5. Invoice should satisfy below conditions
a. Invoice total cost at summary level should be more than the shipment cost
b. Total Quantity on the shipment should match the total quantity on invoice
c. Item1 and Item2 costs in invoice and Shipment should be different
d. Item2 cost should be set such that total variance is less than$25. This is so that thew invoice will be eligible for matching within tolerance
e. Item3 and Item5 cost and quantity should be the same on both shipment and invoice
4. Run the auto match -After running the Auto-Match, the invoice status changes to ‘Unresolved match’
5. Start the manual matching process
a. Search with the supplier in ‘Invoice Summary Match Find’ screen
b. Order should show in ‘Groups – Auto’ section in ‘Summary Match List’ screen
c. Click on Order hyperlink
d. Goto ‘Summary Match List’ screen which shows that the invoice and receipts variance is out of tolerance
e. Click on Details button
f. Detail Matching screen appears with list of items ‘In Discrepancy Items’ and ‘In Balance Items’
g. Select Item1 from ‘In Discrepancy Items’ and click the down arrow
h. Click on ‘Cost Resolution’ button
i. On the ‘Cost Selection’ screen, click Invoice radio button and click Next
j. Enter the Reason code ‘Receipt Cost Adjustment’, amount and click apply and then click OK
k. This should update the shipsku with the corrected cost and the line item in shipsku should have got matched
l. On ‘Detail Match’ screen after the action from 5.j
m. At this point it should have Item2, Item3 and Item5 also appear in the ‘In Discrepancy Items’ section
n. Click Ok button, it will take you to the “Summary Match List” screen
o. While still on the "Summary Match List" screen, check the IM_DOC_HEAD table to see the status of the invoice is ‘Unresolved match’
p. Now, within the Tolerance section on the "Summary Match List" screen, it should show both Cost and Quantity as Yes.
q. Click the ‘Online Match’ button
r. System will now throw an error message saying “Receipt has been updated by another process, please close the screen and try again”
s. Note the numbers of Cost and Quantity in the Summary section at the bottom of the screen
t. Click cancel, and stay on the page do not logoff

6. Database validations
a. As per ReIM UI the invoice and shipment are still available for matching
b. But Invoice status is changed to ‘MTCH’ in IM_DOC_HEAD
c. Qty_Matched on SHIPSKU is not updated for the items that are left for Summary Match
d. Invc_Match_Status is not updated with status M for any of the items
e. History tables and other matching related tables are missing the records for those invoices and items attempted to match at summary level.

7. UI validations
a. As per action from 5.s within the ReIM UI, you should be on ‘Summary Match List’ screen
b. Click on the active Order
c. Invoice and receipt are still showing even though they are matched
d. Note the numbers of Cost and Quantity in below Summary section at the bottom of the screen, These values are different than what was shown as per 5.r
e. This time however, the screen says the Cost and Quantity are not within Tolerance
f. Click on the Details button and then click Cancel on Detail Match screen
g. Note the numbers of Cost and Quantity in the Summary section at the bottom of the screen, These values are different again than what was shown as per 5.r and 7.e
h. Click Cancel, till you reach ‘Invoice Summary Match Find’ screen
i. Search with the same supplier again
j. This time, the invoice is not shown in Summary Match List. However, the shipment is listed under ‘Receipts – Unmatched’ section for the items which were supposed to match at summary level as per action 5.p


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
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.