When importing Netsuite customer, in the mapping I am missing the Netsuite field Address : ID.
Role + user has all rights and permissions.
Am I missing something?
Why do you want to set the ID field? If you're importing a customer you're also creating the address and the ID will be generated by NetSuite.
Am I missing something?
Or I am! ;)
I noticed that this is missing too. I want to be able to update existing addresses on a customer.
Is it even possible to update the address in a Customer mapping because its a subrecord?
Using address.ID and a lookup inside the mapping didnt do the trick for me.
I fixed it by creating a saved search in Netsuite and a extra Customer update flow step in which I only add the address if its non existent yet.
Hi! I’m running into this same problem and can’t seem to find a workaround. How did you solve this problem?
I’ve used the address sublist and leverage the Label field to add and track an id for the address. You can mark the Label field as a key to find exisiting records.
Great suggestion from @davidgollom! So basically : On the Customer record, the Address sublist has a Label field, you can store a "unique" key there and use that to look up the address:
and in Celigo:

Does this help @David_Pate ?