Skip to main content
Question

Import scenario to import new lines & update the existing SO lines in one routine itself.

  • May 18, 2026
  • 5 replies
  • 42 views
H
Semi-Pro II
Forum|alt.badge.img

Hello all,

I’ve been trying to create an import scenario that will not only create a new SO with the line items but also update the existing ones if there’s a new item added in the list to the already existing SO. The data source is a GI.

 

What is it that I am missing?

Note: the line items may have the same item IDs to be imported as a new or updating the already existing one. I have been trying to map it on the basis of the Line numbers.

 

    5 replies

    Manikanta Dhulipudi
    Captain II
    Forum|alt.badge.img+16

    ​@Harry Use line nbr and verify the import scenario.

     

    Acumatica Functional Consultant & Customer Experience Supervisor
      H
      Semi-Pro II
      Forum|alt.badge.img
      • Harry
      • Author
      • Semi-Pro II
      • May 18, 2026

      ​@Harry Use line nbr and verify the import scenario.

       

      So instead of @@Inventory ID shall I be using Line number?

        Manikanta Dhulipudi
        Captain II
        Forum|alt.badge.img+16

        ​@Harry Yes since you have mentioned same inventory ID exist.

        Acumatica Functional Consultant & Customer Experience Supervisor
          H
          Semi-Pro II
          Forum|alt.badge.img
          • Harry
          • Author
          • Semi-Pro II
          • May 19, 2026

          ​@Harry Yes since you have mentioned same inventory ID exist.

          Hi ​@Manikanta Dhulipudi , I tried the following, it is duplicating the items even if there arent any new getting added in the order.

          Attaching the xml:

           

            Manikanta Dhulipudi
            Captain II
            Forum|alt.badge.img+16

            ​@Harry I prefer to Create a new Line item in the first import scenario, followed by updating the line in the second import scenario, as the below mapping may cause a few more issues.

             

            Acumatica Functional Consultant & Customer Experience Supervisor
              Terms & ConditionsAccessibility statement
              About Acumatica ERP system
              Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
              © 2008 — 2024  Acumatica, Inc. All rights reserved