Discrepancies On SHRINKAGE_RETAIL Calculation Field in Stock Ledger MONTH_DATA Table
Last updated on MAY 01, 2017
Applies to:Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.
Discrepancies on SHRINKAGE_RETAIL calculation field in Stock ledger while following below steps:
1. Create price change in RPM.
2. Check tran_data for tran_code 11 entry, verify that VAT is not included in the values of TOTAL_RETAIL, OLD_UNIT_RETAIL , NEW_UNIT_RETAIL.
3. Run pos upload (posupld) for a sale before the cost change.
4. Posupld process will create new type of movements (13, 14) in TRAN_DATA table in order to reverse the respective RPM movements where it happens subsequently, including VAT for item location.
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