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

Vendor Item Import erroneously updates entity item's StocktakeUnit1ID and ReportingUnitID

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2020R4.1
    • Fix Version/s: CFA 2021R2
    • Component/s: Imports
    • Labels:
      None
    • Root cause - Reason:
      Bad data

      Description

      Vendor Item Import erroneously updates entity item's StocktakeUnit1ID and ReportingUnitID

      In Production, after I4 runs:

      • store 04437 - Elkin FSU
      • Item 'CUP, 32 OZ CFA' StocktakeUnit1ID and ReportingUnitID get set to '25/20 Ct Sleeve Case' UOM instead of '25/16 Ct Sleeve Case' UOM

      select* from tbvendoritem with (nolock)
      where vendorcode='032671'
      --256 QCD 25/16 Ct Sleeve Case

      select StocktakeUnit1ID, StocktakeUnit2ID, ReportingUnitID, * from tbentityitem with (nolock)
      where itemid=225 and EntityID=4976
      --217 25/20 Ct Sleeve Case

      select* from tbvendorentityitem with (nolock)
      where entityid=4976 and ItemID=225 and vendorcode='032671'
      --25/16 Ct Sleeve Case

      Note: this store only has one vendor item assigned for this inventory item. Based on this fact (that there is only one vendor item assigned) and the UOM in the Import file is 25/16 Ct Sleeve Case, it is expected that the ReportingUnitID and StockTakeUnit1ID of the entity item be set to 25/16 Ct Sleeve Case, but it is in fact being set to 25/20 Ct Sleeve Case (217).

      Note 2: When using the MMS Maintain Order page, and clicking on Save, the UOM gets set correctly to 25/16 Ct Sleeve Case UOM.

        Attachments

        1. VENDORITEM_Itemid_2099.CSV
          2 kB
        2. VENDORITEM_Itemid_2099.CSV
          2 kB
        3. VENDORITEM_Itemid_12_11_2020.CSV
          2 kB
        4. VENDORITEM_20201201_1450.csv
          515 kB
        5. screenshot-5.png
          screenshot-5.png
          71 kB
        6. screenshot-4.png
          screenshot-4.png
          134 kB
        7. screenshot-3.png
          screenshot-3.png
          77 kB
        8. screenshot-2.png
          screenshot-2.png
          41 kB
        9. screenshot-1.png
          screenshot-1.png
          34 kB
        10. InventoryItems_20201201_1448.csv
          361 kB

          Activity

            People

            • Assignee:
              stacy.privalova Stacy Privalova
              Reporter:
              stacy.privalova Stacy Privalova
            • Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:

                PagerDuty

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