Good day NetSuite Support Community,
I am doing a test update of my items to our newly created subsidiary (Subsidiary B). All of our items are currently setup as assigned to Subsidiary A only. We wanted to update all items to be assigned to Subsidiary B as well, which means all items must have both Sub A and B.
Below are the details of what how I did it.
- My CSV file only contains 2 columns. External ID of the item and subsidiary column which only contains Subsidiary B.
- On my data handling option, I chose "UPDATE" with the assumption that it will update all items to be tagged to Sub B as well.
After uploading, I had an error that "You cannot remove subsidiary: A because this record is used on a transaction for subsidiary: A". So, I tried adding Sub A to my template, so on my new CSV file I have both A and B on the subsidiary column, just separated with a | delimiter. This successfully updated the item record.
Does this mean I'd have to consider previous data before trying to update any kind of record? Will there be a way to just have the new data on my CSV file and update the record based on what has been considered in my CSV file?
Thank you! ? Would really appreciate all your help.