Different Logic For Available Qty Calculation In Transfer And RTV Screens
Last updated on APRIL 07, 2017
Applies to:Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.
Different logic for available qty calculation in Transfer and Return To Vendor (RTV) screens, when the NON_SELLABLE_QTY is a negative value.
Steps To Follow:
1. Create a new item.
2. Update ITEM_LOC_SOH, such that stock_on_hand is say 10 and NON_SELLABLE_QTY for the item (at the location to be used for transfer and RTV) is negative, say -20.
3. Insert record into INV_STATUS_QTY for the item with INV_STATUS = 4 (Non Sellable) and qty = -20.
4. Try to create a new transfer (TSFHEAD.INVENTORY_TYPE = 'A').
5. Note that the qty available for transfer is 10 units.
6. Now try to create a new RTV (RTV_DETAIL.INV_STATUS = null).
7. Note that the incorrect qty available for RTV, which is 10-(-20) = 30.
Expectation is that the same behavior should be followed between Transfer and RTV.
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