I am struggling to find resource online for the import of related items against an inventory item that already exists. The best article I have found does the usual trick of avoiding the important pieces of information to complete the task (https://5898423.app.netsuite.com/app/help/helpcenter.nl?fid=section_n375476.html), in fact most Netsuite documentation could be compared to a conversation with a Lawyer or Accountant, "Well you could do this or you could do that, but there is no guarantee of success"
- I already have the Item Inventory in Netsuite.
- I have a file with the [Internal ID] Column.
- I have added a 2nd column for the [Related ID] and in it I have added the [Internal ID] of the record I wish it be related to;
Disclosure; I have done all this through guess work, because of course the format of the required upload file is missing from the documentation.
- I have selected Item Inventory on the upload and Update continuing to the following screens taken from the loose documentation (https://5898423.app.netsuite.com/app/help/helpcenter.nl?fid=section_n375476.html). In the Item Presentation portion of the screen I have placed my [Related ID] in the Item (Req) and selected Item from the pull down on Type (req).
- The Import Fails. Invalid item reference key "xyz".
Could anyone assist with the full and correct procedure?
Thank you
Stuart