-
Type: Customer Defect
-
Status: In Functional Review (View Workflow)
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: CFA 2022R5
-
Fix Version/s: None
-
Component/s: Inventory
-
Labels:None
-
VTask #:VTASK0505196
-Chocolate Peppermint Flake (15849) is converting 0 to 4.47 in the inventory extension report
-Restaurant started this inventory count before the UOM was fixed for this item
Old inner unit of measure 10 Lb Bag , New inner UOM 2.2 # Bag
-They originally counted 1.5 cases, and the extension report and Item Activity both showed they counted 5.95 cases
-We tried to correct the count to lower the value, to try to get Item Activity and Inventory Extension to reflect 1.5 cases
-Lowering the counted value all the way down to 0 results in Item Activity and Inventory Extension reflecting 4.47 cases counted
*Please assist with conversion and help us understand how 0 is converting to 4.47
*We would like the Item Activity and Inventory Extension to reflect that they counted 1.5 cases on the Monthly count
Select * from tbTransactionStockCountLocation with ( nolock ) where EntityID = 210 order by 3 desc --6895840
Select * from tbTransactionStockCountLocationDetail with ( nolock ) where ItemID = 5114 and TransactionStockCountLocationID = 6895840
Select * from tbTransactionStockCount with ( nolock ) where ItemID = 5114 and TransactionStockCountLocationID = 6895840
select * from tbEntityITem with ( nolock ) where ItemID = 5114 and EntityID = 210
- blocks
-
CFAMX-11540 Production Defects
- Open