We are onboarding a new subsidiary and I am trying...
# administration
n
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
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
@CD Unfortunately when I use that field I receive this error "The record has been deleted since you retrieved it."
I created my own number 0127221000 as I assumed it needed to be unique for each line.
c
Just use 1, 2, 3, 4 .... etc, per order. I've been doing SO imports today, so I know it's not bugged
n
my problem is I dont know what the next number is. Some have 3, some have 15.
To clarify, I am updating existing Sales Orders.
c
Oh, you said importing, not updating. Are you updating wanting to add new lines, or updating wanting to update existing ones?
n
sorry for the confusion. Updating and add new line. (where a line with that same item exists)