Wrong Calculation on Tran_data for Sending Loss in Stock Order Reconciliation
(Doc ID 2549789.1)
Last updated on APRIL 16, 2021
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
For transfer having pack items (ITEM_MASTER.PACK_IND = 'Y') with more then one component the Stock Order Reconciliation is not calculating the Tran_code 38 properly.
Instead of calculating the cost of a component, Retail Merchandising System (RMS) is looping the calculation based on the calculated component - each increment is addressing the cost of the previous component.
The issue can be reproduced at will with the following steps:
- Create transfer.
- Add a pack item that has more then one component in it.
- Approve and ship the transfer.
- Check the values of TRAN_CODE 38.
- Receive the shipment (Receipt -> Receive by ITEM -> Save and Close).
- Go to Stock Order Reconciliation.
- Indicate the Loss on behalf of the shipping location (Sending Loss).
- Check the tran_data - for tran_code 38 with the negative units (the TOTAL_COST at this point is not calculated properly).
The PACK has quantity 2 in PACK_ITEM_QTY for each component, giving the total of 10 PCS in a pack that gives the total Cost of 100 USD per pack.
When shipping the transfer in TRAN_CODES are generated in TRAN_DATA. For each ITEM in the PACK, tran_code 38 is created with TOTAL_COST based on calculation the percentile of the pack component.
In our case each ITEM in the TRAN_DATA has a TOTAL_COST of 20 USD.
After receiving the SHIPMENT with 0 quantity for enabling the SO RECONCILIATION and indicating the loss on the SHIPPING LOCATION side, the new TRAN_DATA generated will have TRAN_CODE 38 where UNITS < 0.
TRAN_DATA will be calculated as follows:
ITEM 1: UNITS -2 TOTAL_COST 20 (100*20%) - this is calculated properly
ITEM 2: UNITS -2 TOTAL_COST 4 (20*20%) - this calculation and further calculations in the loop are incorrect.
ITEM 3: UNITS -2 TOTAL_COST 0.8 (4*20%)
ITEM 4: UNITS -2 TOTAL_COST 0.16 (0.8*20%)
ITEM 5: UNITS -2 TOTAL_COST 0.032 (0.16*20%)
However each ITEM in PACK should have percentile of 20% of the total PACK cost.
ITEM 1: UNITS -2 TOTAL_COST 20 (100*20%)
ITEM 2: UNITS -2 TOTAL_COST 20 (100*20%)
ITEM 3: UNITS -2 TOTAL_COST 20 (100*20%)
ITEM 4: UNITS -2 TOTAL_COST 20 (100*20%)
ITEM 5: UNITS -2 TOTAL_COST 20 (100*20%)
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