Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
why do i get "Invalid item reference key" error on purchase order import
We have one vendor that we order from weekly and their PO is ~200 items per week. We use a spreadsheet to determine the items/quantites and I'd like to import the Purchase order into NetSuite. I have the "item list" in the spreadsheet and can access all the fields.
I've used CSV imports extensively in past, including updating items (internal id for item is always necessary). I've tried importing the purchase order many different ways, but can't seem to get past the "invalid item reference key".
Below is a screenshot from the CSV import function:
What information is being requested? I've used the item's "name" as well as the "internal id" for the item. On a different "purchase order form" it asked for the "vendor name" and I used that.