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

2021.R2 CLONE/Patchback - Vendor Item Import is updating entity item Stocktake1ID before the VendorEntityItem relation is made

    Details

    • Type: Testing Defect
    • Status: Done (View Workflow)
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: CFA 2021R2
    • Fix Version/s: CFA 2021R2
    • Component/s: None
    • Labels:

      Description

      Scenario 

      Import Inventory Item 608220 Lid, Yellow Round w/Purchase Unit = 144 Ct Case

      Import Vendor Item import associated with this Inventory Item with PUOM = 100 Ct Case 

      At this point

      --Entity Item record has Stocktake1ID = 42 or 144Ct Case, Stocktake2ID = Null, ReportingUnit =42 or 144Ct Case  AND In Use = 0

      --Vendor Item record has a PurchaseUnitId = 18 and a InnerUnitId = 18 Or 100 Ct Case

      Search 'Lid, Green Round' and Assign Vendor Item to 00440 with a Start Date of today

      --a TbVendorEntityItem record is created with a PUOM = 100 Ct Case

      --Entity Item. InUse = 0 still

      RUN EnableEntityItemsfrom ActiveVendorItems on Server Manager under Service Method Processing

      Entity Item record is updated to InUse = 1, no change to Stocktake1ID , Stocktake2ID  or ReportingUnit

      Load VendorItem Import #2 - This import contains a second Vendor Item along with the first Vendor Item. It however has a PUOM of 240 Ct Case or a tbUOM = 76 and a StockTakeIner of 240 ct Case or tbUOM76

      Run Vendor Import on Server manger

      DEFECT - The Vendor Item should load to the system with no impact to the entity item record until the tbVEI record is created by the rule. In this case we see the entity Item record is partially updated :  StockTake1ID = 18 (INCORRECT) or 100 Ct Case, Stocktake2ID = 76 (INCORRECT) or ReportUnitID=76 (INCORRECT)

      Of Course this propagates downstream to Counting as 

       

       

       

        Attachments

        1. image-2021-02-18-15-12-41-152.png
          7 kB
          Soma Dixon
        2. image-2021-02-18-15-14-06-064.png
          9 kB
          Soma Dixon
        3. image-2021-02-18-15-22-46-211.png
          9 kB
          Soma Dixon
        4. image-2021-02-19-08-46-38-400.png
          9 kB
          Soma Dixon
        5. image-2021-02-19-08-47-16-259.png
          10 kB
          Soma Dixon
        6. image-2021-02-27-08-31-53-818.png
          7 kB
          Charles Wheeler
        7. InventoryItems_20210219a.csv
          0.9 kB
          Soma Dixon
        8. screenshot-1.png
          16 kB
          Soma Dixon
        9. VENDORITEM_20210219_01batch5.csv
          0.5 kB
          Soma Dixon
        10. VENDORITEM_20210219_02batch5.csv
          0.6 kB
          Soma Dixon

          Issue Links

            Activity

              People

              • Assignee:
                charles.wheeler Charles Wheeler
                Reporter:
                charles.wheeler Charles Wheeler
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1h
                  1h
                  Remaining:
                  0h
                  Logged:
                  Time Not Required
                  Not Specified

                    PagerDuty

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