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

When ST4 is not Supplied in the VI Import, the code wipes out ST4 at the Entity Item

    Details

      Description

      Need to back out the code, and schema changes, for CFAMX-1373

      • Imports > I4 > Vendor Item > Ability to consume StockTake4

      When testing this, the following files were dropped:

      My SQL, run before/after importing every file

      select StocktakeUnit1, StocktakeUnit2, StocktakeUnit4,PurchaseUnit,BaseUnit,* from tbitem with(nolock)
      where ItemId = 16

      Select StocktakeUnit1ID, StocktakeUnit2ID, StocktakeUnit4ID, * from tbEntityItem with(nolock)
      where ItemID = 16
      and EntityID = 1041

      select PurchaseUnitID, InnerUnitID, InnerUnit4ID,* from tbVendorItem with(nolock)
      where itemID = 16
      and VendorID = 157

      select PurchaseUnit, StockCountUnit2ID, StockCountUnit4ID,* from tbVendorEntityItem with(nolock)
      where VendorId = 157
      and entityid = 1041
      and itemid = 16

      select * from tbUnitOfMeasure with(nolock)
      where UnitOfMeasureID in (495,1091,1092, 1096, 1097)

      Wizard - After running the Inventory Entity Item Import

      Wizard - After running the Vendor Item Import - Stock Take 4 removed

        Attachments

        1. VENDORITEM_20190509.csv
          0.6 kB
        2. VENDORITEM_20190509_1528.csv
          320 kB
        3. InventoryItems_20190509.csv
          0.8 kB
        4. InventoryItems_20190509_1004.csv
          302 kB
        5. InventoryEntityItems_20190509.csv
          0.1 kB
        6. AfterVI.png
          AfterVI.png
          51 kB
        7. AfterIEI.png
          AfterIEI.png
          51 kB

          Issue Links

            Activity

              People

              • Assignee:
                soma.dixon Soma Dixon (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

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

                    PagerDuty

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