I’m working on a integration to create a sales order in Netsuite. The integration is coming in two separate phases. Original contract lines and then any changes update the sales orders and write the rest of the lines. In my test I have 3 original lines and 2 lines that come in on an update. The weird part is that the line numbers are off. I have line 1,2,3 and skips line 4 and goes to 4,5. Does anyone know what the line numbers are skipping around?

Line ID is not related to the position in the sublist and can change. (also there are hidden lines) Line Sequence Number would be the 1,2,3,4,5 etc.

so if you look at the back end xml of the sales order the orderLine = 1,2,3,5,6. I’m trying to understand why they skip

order line is not the line number, its the line id

Here is a screenshot. The line and the orderLine are both doing the same thing

the order line refers to the line id of the associated order

The line sequenceNumber isn’t showing at all. The external system I’m coming from is line 1-5 so I can’t tie anything out with the lines in netsuite not incrementing. Do you have any idea why they don’t increment correctly?

line sequence number is implied in this case

Same with the 3rd but skips 4

there are multiple reasons a line id may skip

That’s what I originally thought so I deleted the sales order and re-created it from scratch, and it still came over the same way.

you can explore reasons about how line ids work

I know and with this other system I’m working with there isn’t a way to bring them over from there either

Sounds like you need an external ID on the line if you want to be able to map between the two systems