In Celigo, I’m trying to add/attach a Child Customer to a Contact, but I’m getting this error when creating the Contact with the (Child) Customer NetSuite ID mapped:
Failed to save record because You have entered an Invalid Field Value 6388 for the following field: company.
I also tried creating the Contact without the Customer reference and then attaching the Contact to the Customer. This works, but on the Customer record under Relationships → Contact, the Company field is still empty and this is a problem.
This can be seen in the contact named “Second child” in the screenshot (see also red box). When I manually add the “test nuri” contact through the UI, I can assign a Company without issue.
I checked this with our Lead, and I was informed that it would be best if we open a support ticket so our Support Team can take a look at your setup in detail. I will create the ticket on your behalf, and you should get an email shortly.
It was fixed by removing the subsidiary field from the Celigo mapping.
In NetSuite, a Contact inherits its subsidiary from the linked Customer. When both company and subsidiary are sent, NetSuite rejects it with “Invalid Field Value for subsidiary”.
After Celigo retried the import without the subsidiary mapping, the contact was created successfully.
They also enabled Dynamic Mode (celigo_recordmode_dynamic: true) to handle dependent fields automatically.
Summary:
Don’t map subsidiary when creating Contacts in NetSuite—let it inherit from the company.
