Skip to main content
Solved

Sales Order Import Scenarios

  • January 11, 2023
  • 2 replies
  • 1002 views

I am creating an Import Scenario that will import multiple sales orders and multiple line using a tab delimed csv file. 

I have gotten it to the point where it is creating the sales order and their lines. there is just one problem. it is creating the first sales order with all its line perfectly but from there on it always missed the first line in the sales order. 

 

I have created 3 sales orders with 10 Lines 

Sales order 1 or (241144) has 4 Lines 

Sales order 2 or (242111) has 2 Lines

Sales order 3 or (242130) has 4 Lines

 

Sales order 2 and 3 have one line dropped i renamed the Quantities of my line from 1 to 10 to check what the pattern was. 

I do a look up on the Customer Order number I suspect this is where the problem is but no matter where I move it to in the file the bug persists. 

 

Please see my screen shots attached. Any help as to why I'm getting this strange problem would be great.

 

 

Thanks 

Willem. 

Best answer by meganfriesen37

The easiest solution may be to temporarily turn off your reference number auto numbering and rather than hard coding in <NEW> in your import scenario, include the system order numbers as part of your import file.  

It might be that either the first line is not properly saving or that the 2nd line is overwriting the first line.

Megan

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

2 replies

meganfriesen37
Captain II
Forum|alt.badge.img+12
  • Captain II
  • 605 replies
  • Answer
  • January 13, 2023

The easiest solution may be to temporarily turn off your reference number auto numbering and rather than hard coding in <NEW> in your import scenario, include the system order numbers as part of your import file.  

It might be that either the first line is not properly saving or that the 2nd line is overwriting the first line.

Megan


Foujan
Jr Varsity II
Forum|alt.badge.img
  • Jr Varsity II
  • 20 replies
  • May 10, 2023

Hi,

Give this one a try that I created using Auto Numbering. This created multiple sales orders including all the detail lines.
 

NOTE: the file needs to have Order Nbr. column but user just need to use the same number for the lines in 1 order. Then system can differentiate between different orders and uses the auto numbering sequence instead of the number in the file.

 


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