Approved Date/Count Date Is Not Correct In Stock Count Line Item And Causing SOH Discrepancy
(Doc ID 2511507.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Retail Store Inventory Management - Version 14.1 and later
Information in this document applies to any platform.
Approved Date/Count date is not correct in stock count line item and causing stock on hand (SOH) discrepancy.
Since stock counted was created on T date, sale processing for T date happened on T+1 date, the sale transaction should reduce the SOH.
Steps to Recreate:
- Create a stock count for T date and include all items.
- While uploading the stock count, exclude some items which are having SOH in the system but there is no stock in store.
For example: Item X has stock in the system as more than zero, but zero in the store.
- Upload the file on day T+1 and observe that count date time and approved date time are populated with system date (day when upload batch ran).
Note: Make sure Auto Authorization is ON. So Stock count will be authorized after upload batch completed.
- Load the sales for day T, and observe that SOH has not reduced further due to approved date as T+1.
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