Skip to main content
Answer

Import Scenario - SO with Multiple Lines

  • October 23, 2025
  • 4 replies
  • 49 views
F
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

4 replies

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

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

Acumatica Functional Consultant & Customer Experience Supervisor
Chris Hackett
lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • Answer
  • October 23, 2025

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

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*.
Chris Hackett
mohammadnawaz51
mohammadnawaz51
Jr Varsity I
Forum|alt.badge.img+4

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

https://www.acumatica.com/acumatica-marketplace/global-payex-ap-accounts-payable-automation-solution/
Chris Hackett
F
Freshman I
  • fgill
  • Author
  • Freshman I
  • October 24, 2025

​@lauraj46 Thank you, that worked.

lauraj46
Chris Hackett
Terms & ConditionsCookie settingsAccessibility 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