TOTAL_RETAIL In Transfer Detail Screen, TRAN_DATA AND SHIPSKU are Not In Sync

(Doc ID 2350120.1)

Last updated on JANUARY 25, 2018

Applies to:

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

Symptoms

TOTAL_RETAIL In Transfer Detail Screen, TRAN_DATA AND SHIPSKU are Not In Sync

Steps To Recreate:

1. Create a Component Item in Retail Merchandising System(RMS).
2. Create a Simple pack and assign 5 quantity of the Component
3. Create a Store to Store Transfer in Store Inventory Management System(SIM).
4. Perform Shipment, Dispatch and Receive in SIM.
5. Observe the Transfer Attributes in RMS.

Observation :

1. In Transfer Detail Screen in RMS UI, Unit_Retail of the From_Location is showing the Retail of the Pack Item. SHIPSKU .UNIT_RETAIL is displaying the retail of the Pack Item. But while booking to TRAN_DATA, (both in Sending-32 and Receiving Location-30) Total_Retail is booked based of VAT Inclusive Retail of the Component * Quantity within Pack instead of the Pack Retail. Hence, Discrepancy between (UI, Shipsku) and Posting in TRAN_DATA. both the data should be in Sync.



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