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

Vendor Item Import doesn't set Purchase Unit to Largest UOM

    Details

    • Type: Testing Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: CFA 2020R4
    • Fix Version/s: CFA 2021R2
    • Component/s: Imports
    • Labels:
      None
    • SCRUM Team:
      Watchmen
    • Source Code ID(s):
    • Sprint:
      System Health 2021R1 Sprint 6

      Description

      Vendor Item Import doesn't set Purchase Unit to Largest UOM
      CFA Testing
      Store 00440 has 2 active vendor items assigned to Soda, Barq's Root Beer item (itemid = 2099, itemcode = 1621)
      002095 SODA, BARQ'S RT BEER BIB - Purchase UOM: 5 Gal. Case
      079722 SODA, BARQS RT BR 2.5 BIB - Purchase UOM: 2.5 Gallons

      select DiscontinueDate, * from tbvendorentityitem with (nolock)
      where itemid = 2099 and entityid = 269

      Inventory entity item Purchase UOM is 2.5 Gallons instead of 5 Gal. Case

      select StocktakeUnit1ID,* from tbentityitem where EntityID = 269 and itemid = 2099 – 176
      select * from tbUnitOfMeasure where UnitOfMeasureID in (176, 184)

      My understanding is that even if Vendor item import sets inventory entity item StocktakeUnit1ID UOM using the last vendor item in the file, there is still a process that runs after the import that should update it to the Largest UOM if there are more than 1 active vendor items assigned.

        Attachments

        1. screenshot-1.png
          screenshot-1.png
          39 kB
        2. screenshot-2.png
          screenshot-2.png
          58 kB
        3. screenshot-3.png
          screenshot-3.png
          81 kB
        4. VENDORITEM_Itemid_2099.CSV
          2 kB

          Issue Links

            Activity

              People

              • Assignee:
                will.englefield Will Englefield (Inactive)
                Reporter:
                stacy.privalova Stacy Privalova
              • Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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