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

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

    Details

    • Source Code ID(s):
    • Sprint:
      CFAMX 2019R3 Sprint 3

      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
          Will Englefield
        2. InventoryItems_20190509.csv
          0.8 kB
          Will Englefield
        3. InventoryEntityItems_20190509.csv
          0.1 kB
          Will Englefield
        4. AfterVI.png
          51 kB
          Will Englefield
        5. AfterIEI.png
          51 kB
          Will Englefield

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

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

                    PagerDuty

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