-
Type: Customer Defect
-
Status: Need More Info (View Workflow)
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: CFA 2023R1
-
Fix Version/s: None
-
Component/s: Inventory
-
Labels:None
-
VTask #:VTASK0509910
CFA reported that store 03313 has been experiencing perpetual on hand issues with DRSNG, APPLE CIDER VINAIGRETTE (101338) for some time now.
The operator routinely has to correct his on hand quantities during the ordering process (InFORM's on hand qty is always higher than what the restaurant has) and CFA team can't make any sense of it.
If he corrects his on hand and enters a count of 1.0 cases, the next day his on hand will be >1.0 cases, with no inbound inventory transaction and inventory depletion from sales. Their UPT value for this item is 0.0057 which means their on hands should be depleting by 0.17-0.20 cases per day yet somehow their on hands are increasing each day.
I noticed that in the activity report the closing Inventory is always > from expected
It match what we have in tbItemQty
Select fOnHand_qty/180,* from tbItemQty with ( nolock )where ItemID = 2399 and EntityID = 3178
1st question where this is getting calculated?
Is it taking into consideration the physical count the operator does?
select * from tbTransactionStockCount with (Nolock) where EntityID = 3178 and ItemID = 2399 order by ApplyDate desc
For the spot counts (system) it is always > what the operator counted.
Are you able to dig into this and let us know what may be causing this?
- blocks
-
CFAMX-11540 Production Defects
- Open