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

How to change the association from Inventory Item 721, to the new Inventory Item 14906

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Closed/Resolved by Caller
    • Affects Version/s: CFA 2020R3
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0430013

      Description

      • OLD Inventory item - 721 - Topping, Strawberry 4# (OLD) 
      • Vendor Items - 101227  TOPPING, DICED STRAWBERRY  
      • NEW inventory Item - 14906 - Topping, Strawberry
      • Move Vendor Items - 101227  TOPPING, DICED STRAWBERRY, from 721 to be associated to 14906

       
      This item is still active in the system, and needs to be ordered, so it cannot be discontinued.
       
      When trying to update via the Vendor Item Import, CFA is receiving an error message about Open Orders.
       
      Based on the fact that there is error messaging, saying that there are open orders associated to the item, is it possible to move the Vendor Item from Inventory Item 721 to 14906?
       
      Select * from tbitem with (nolock)
      where Description like '%Topping, Strawberry%'
      --721
      Select * from tbEntityItem with (nolock)
      where ItemID = 2076
      --14906
      Select * from tbEntityItem with (nolock)
      where ItemID =4111

      Select * from tbVendorItem with (nolock)
      where itemid=4111

      Select * from tbVendorItem with (nolock)
      where itemid=2076

      Select * from tbVendorEntityItem with (nolock)
      where itemid=2076

      Select * from tbVendorEntityItem with (nolock)
      where itemid=4111

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Robert.Johnson Robert Johnson (Inactive)
                Reporter:
                Robert.Johnson Robert Johnson (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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