NetSuite Upserts

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2018 12:48 PM
I’ve built a pipeline that create NetSuite customers from a source system and includes a company code as an external id. Now I’m trying to insert invoices that link to those customers. I tried populating the account external id and the entity external id but I’m receiving the message ‘FIELD_PARAM_REQD: Please enter a value for entity’. Any ideas how I can upsert the invoice with only the external id for the customer?
I have thought about using the search to get the internal id to see if that would work.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2018 07:26 AM
This error occurred because there was no NetSuite customer for the external key being referenced in the upsert.
The customer must exist before the invoice can be created.
