We are onboarding a new subsidiary and I am trying to import their Open Sales Orders. They have scenarios where they have the same Item multiple times on the Sales Order. When I import it just overwrites the item over and over again. So 3 items in my import file end up being 1 in NetSuite. I tried providing a unique Line Id but that isnt working. Any tips?
c
CD
01/27/2022, 4:04 PM
Should be fine if you use Line Id (not unique line id - netsuite generates that). You want to use the one with the key next to it on the mapping screen
👍 1
n
NS Admin
01/27/2022, 4:43 PM
@CD Unfortunately when I use that field I receive this error "The record has been deleted since you retrieved it."
NS Admin
01/27/2022, 4:44 PM
I created my own number 0127221000 as I assumed it needed to be unique for each line.
c
CD
01/27/2022, 4:58 PM
Just use 1, 2, 3, 4 .... etc, per order. I've been doing SO imports today, so I know it's not bugged
n
NS Admin
01/27/2022, 5:11 PM
my problem is I dont know what the next number is. Some have 3, some have 15.
NS Admin
01/27/2022, 5:13 PM
To clarify, I am updating existing Sales Orders.
c
CD
01/27/2022, 5:28 PM
Oh, you said importing, not updating. Are you updating wanting to add new lines, or updating wanting to update existing ones?
n
NS Admin
01/27/2022, 5:40 PM
sorry for the confusion. Updating and add new line. (where a line with that same item exists)