Skip to main content
Solved

Import Scenario - SO with Multiple Lines

  • Oct 23, 2025 6:05 PM UTC
  • 4 replies
  • 128 views
  • Translate All
Freshman I

I am trying to import a SO with multiple lines. Currently the SO is being created with the multiple lines. However, if I have more than 1 SO on the CSV file to import, the import puts all the lines on one SO instead of each SO having their own lines. There was a suggestion to use 1,2,3 to enable the import to create individual SOs with the lines for each, However, I am doing that, but all the lines are still being created on one SO. See the attached Import Scenario and CSV file. What do I need to change to fix this issue?

 

Best answer by lauraj46

Hi ​@fgill ,

Instead of mapping =’<New>’ on the Order Nbr row of the import scenario you should map the column ‘Order Nbr’ from the spreadsheet.

Hope this helps!

Laura

View original

4 replies

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

​@fgill Could you please share xml file and sample data sheet to review and assist.

Translate
Acumatica Functional Consultant & Customer Experience Supervisor
    lauraj46
    Captain II
    Forum|alt.badge.img+9
    • lauraj46
    • Captain II
    • Answer
    • Oct 23, 2025 6:09 PM UTC

    Hi ​@fgill ,

    Instead of mapping =’<New>’ on the Order Nbr row of the import scenario you should map the column ‘Order Nbr’ from the spreadsheet.

    Hope this helps!

    Laura

    Translate
    Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
      mohammadnawaz51
      Varsity I
      Forum|alt.badge.img+8

      ​@fgill Please review this https://www.augforums.com/forums/everything-else/import-sales-orders-with-multiple-items/

      Translate
      https://globalpayex.com/resources/blogs/the-complete-guide-to-ar-and-ap-automation-in-acumatica/
        Freshman I
        • fgill
        • Author
        • Freshman I
        • Oct 24, 2025 3:12 PM UTC

        ​@lauraj46 Thank you, that worked.

        Translate
          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