-
Type: Customer Defect
-
Status: Done (View Workflow)
-
Priority: Major
-
Resolution: Closed/Resolved by Caller
-
Affects Version/s: CFA 2022R2
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
VTask #:VTASK0488101
Description
Missing Depletion from Sales for UPT items
Environment : PROD
Store : multiple Stores, example 01656
Expected : For Depletion from Sales to display for UPT items
Select tsc.ApplyDate, BusinessDay, * from tbTransactionStockCount tsc With ( nolock)
Join tbTransactionStockCountLocation tscl with ( nolock) on (tscl.TransactionStockCountLocationID = tsc.TransactionStockCountLocationID)
Where tsc.EntityID = 910
AND tsc.ItemID = 2027
AND tsc.ApplyDate >= '2021-03-01'
--AND tscl.AutoGenerated = 1
Order by StockCountDate
— Store 01656 Adjustment amount and Adjust Qty columns do not have data
Select tsc.ApplyDate, BusinessDay, * from tbTransactionStockCount tsc With ( nolock)
Join tbTransactionStockCountLocation tscl with ( nolock) on (tscl.TransactionStockCountLocationID = tsc.TransactionStockCountLocationID)
Where tsc.EntityID = 911
AND tsc.ItemID = 2027
AND tsc.ApplyDate >= '2022-03-01'
--AND tscl.AutoGenerated = 1
Order by StockCountDate
— Store 01657 Adjustment amount and Adjust Qty columns have data
At store 01657 we can see that item Ketchup Dip has depletion from sales in item activity but at store 01656 there are no depletion from sales
- is blocked by
-
CFAMX-11540 Production Defects
- Open