Skip to main content
Solved

Import Scenario Creates One Order instead of Multiple Orders

  • January 13, 2023
  • 3 replies
  • 261 views

Forum|alt.badge.img

Good day,

I could use some assistance with the review the attached Import Scenario; it worked before we upgraded to 2022R1.  The scenario creates the sale order.  However it creates only one order with all the items in it rather than create a separate order.  The file has 55 orders.  When I tested it created one big order.  I can figure out what changed after we upgraded.

Have a nice day.

@Evan G 

Best answer by RoyceLithgo

You have Order Nbr = ‘1’ - this means all lines imported belong to the same order and so the system only creates one order. Have a Look at the “Import Sales Orders” Import Scenario. You need the Order Nbr to come from the input file. If you have auto-numbering enabled, you just need to use values in the field that differentiate the orders. eg. 1,2,3,4 etc. 

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+3
  • Pro II
  • 76 replies
  • Answer
  • January 17, 2023

You have Order Nbr = ‘1’ - this means all lines imported belong to the same order and so the system only creates one order. Have a Look at the “Import Sales Orders” Import Scenario. You need the Order Nbr to come from the input file. If you have auto-numbering enabled, you just need to use values in the field that differentiate the orders. eg. 1,2,3,4 etc. 


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

Hello @EvanG 

Please find the attached Import scenario for sales order.


SamMemar
Freshman I
  • Freshman I
  • 8 replies
  • October 3, 2024

Thank you @RoyceLithgo, it worked for me.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings