Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-24658

Inventory Item is displaying incorrect unit of measure in Item Maintenance

    Details

    • 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

      Description

      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
      

        Attachments

        1. image-2023-03-13-14-27-45-900.png
          126 kB
          Wesam El-Gendy
        2. VENDORENTITYITEM_DAILY_20230323_0700.csv
          2.89 MB
          Wesam El-Gendy
        3. VENDORITEM_20230323_0700.csv
          13 kB
          Wesam El-Gendy

          Issue Links

            Activity

              People

              • Assignee:
                wesam.el-gendy Wesam El-Gendy
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.