ASN Shipments with Multiple Lines for an Item Can Have Different Costs and Cause Issues While Matching (Doc ID 2260621.1)

Last updated on MAY 08, 2017

Applies to:

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

Symptoms

If an item appears multiple times on an advance shipping notice (ASN) shipment, and has different cost on the received and un-received lines, matching in ReIM does not work properly.


Steps:
1- Create a 1 line order.
2- Receive an ASN for the order with multiple lines for the item.
3- Go to SIM and begin receiving the ASN, do not confirm.
4- Receive all and click done.
5- In Retail Merchandising System (RMS), edit the unit cost on the order.
6- Click on Options > Worksheet.
7- Click on Items.
9- Change Unit Cost of order.
10- Click Yes.
11- Click OK.
12- Approve the order again.
13- In SIM, reopen the shipment and confirm.
14- Click confirm.
15- Verify multiple costs in the SHIPSKU table.
16- In Retail Invoice Matching (ReIM), create an invoice for the original cost.
17- Search in summary match.
18- Open the autogroup.
19- Click details.

Issue 1:
Receipt quantity not available
20- Run automatch.
21- Search for the order again.
22- Click Details.


Issue 2:
Now it shows in balance, although the receipt quantity shows 0 and the cost is different
23- Click OK and the invoice is matched and the receipt remains unmatched.
24- Create a new invoice with the new cost.
25- Search in summary match.


Issue 3:
If costs match, no units are available on the summary screen.

Changes

 

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