-
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 #:VTASK0511642
Inventory Item Harvest Blend Spring Mix is displaying as a '3 Lb Case' unit in Item Maintenance.
This inventory item should display the '4/3 Lb Bags' as the reporting unit.
--tbItem Select * from tbItem with ( nolock ) where ItemID = 3771 --tbVendorEntityItem Select uom1.UomName as PurchaseUnit,uom2.UomName as InnerUnit,vi.* from tbVendorItem vi with ( nolock) left join tbUnitOfMeasure uom1 with (nolock) ON vi.PurchaseUnitID = uom1.UnitOfMeasureID left Join tbUnitOfMeasure uom2 with (nolock) ON vi.InnerUnitID = uom2.UnitOfMeasureID Where ItemID = 3771 and VendorID = 139 --tbEntityItem Select PurchaseUnit,uom.UomName as Inner_Unit,DiscontinueDate,vei.* from tbVendorEntityItem vei with ( nolock) left Join tbUnitOfMeasure uom with (nolock) ON vei.StockCountUnit2ID = uom.UnitOfMeasureID where ItemID = 3771 and EntityID = 3382Select uom1.UomName as ReportingUnit,uom2.UomName as StocktakeUnit1ID,uom3.UomName as StocktakeUnit2ID ,ei.* from tbEntityItem ei with ( nolock) left join tbUnitOfMeasure uom1 with (nolock) ON ei.ReportingUnitID = uom1.UnitOfMeasureID left Join tbUnitOfMeasure uom2 with (nolock) ON ei.StocktakeUnit1ID = uom2.UnitOfMeasureID left Join tbUnitOfMeasure uom3 with (nolock) ON ei.StocktakeUnit2ID = uom3.UnitOfMeasureID Where ItemID = 3771 and EntityID = 3382
- blocks
-
CFAMX-11540 Production Defects
- Open