# Can't update NetSuite record with multiple sublists

**URL:** <https://connective.celigo.com/t/cant-update-netsuite-record-with-multiple-sublists/5965>\
**Category:** Integrator.io\
**Tags:** netsuite\
**Created:** [December 27, 2025, 3:04am UTC](https://connective.celigo.com/t/cant-update-netsuite-record-with-multiple-sublists/5965 "2025-12-27T03:04:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daniel\_P](https://avatars.discourse-cdn.com/v4/letter/d/f17d59/32.png) [@Daniel\_P](https://connective.celigo.com/u/Daniel_P)\
**Post date:** [December 27, 2025, 3:04am UTC](https://connective.celigo.com/t/cant-update-netsuite-record-with-multiple-sublists/5965/1 "2025-12-27T03:04:27Z")

</div>

I have a flow that either adds or updates an existing record. On the update, when I only use the tax registration sublist, it works with the fields shown in the screenshot below. As soon as I add another sublist, I get the error:  
\*\*You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist  
\*\*

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/e/ea3f364b84a34c21c2f98010b2b8a01bf9df2775.png)

You can see in the log the r.removeLine and r.insertLine for the sublistId “taxregistration” but it is only doing r.insertLine for the subilst “contact”. No r.removeLine.

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/5f0bdb719e3c1e823daef5b929f087195d6f4a8e.png)

Any ideas how to get multiple sublist updates working? I also tried “use as a key field to find existing lines” and all kinds of other variations.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![basvanditzhuijzen](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/basvanditzhuijzen/32/4422_2.png) [@basvanditzhuijzen](https://connective.celigo.com/u/basvanditzhuijzen)\
**Post date:** [December 29, 2025, 8:44am UTC](https://connective.celigo.com/t/cant-update-netsuite-record-with-multiple-sublists/5965/2 "2025-12-29T08:44:51Z")

</div>

Hi Daniel,

If I’m not mistaken you can’t directly add to the contact sublist on the customer. This is a NetSuite/Suitescript limitation.

You would first create the customer, in a second import create the contact, then in the third import attach the contact to the customer.

---

<div class="post-metadata">

**Author:** ![friendoftuesday](https://avatars.discourse-cdn.com/v4/letter/f/c89c15/32.png) [@friendoftuesday](https://connective.celigo.com/u/friendoftuesday)\
**Post date:** [December 29, 2025, 5:19pm UTC](https://connective.celigo.com/t/cant-update-netsuite-record-with-multiple-sublists/5965/3 "2025-12-29T17:19:15Z")

</div>

Why the third import? Couldn't you just return the customer id from NetSuite in the response mapping, and map that to the customer field on the contact in the second import?

---

<div class="post-metadata">

**Author:** ![nuriensing](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/nuriensing/32/6918_2.png) [@nuriensing](https://connective.celigo.com/u/nuriensing)\
**Post date:** [December 30, 2025, 10:23am UTC](https://connective.celigo.com/t/cant-update-netsuite-record-with-multiple-sublists/5965/4 "2025-12-30T10:23:27Z")

</div>

This should work. I’ve implemented it this way before, and the contact will be reflected under the customer.

This is where I update the customer id on a contact record:

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/bb05b5df0de0cb4e310f157ec36f14795ad00319.png)

---

<div class="post-metadata">

**Author:** ![Jeremy\_Moody](https://avatars.discourse-cdn.com/v4/letter/j/977dab/32.png) [@Jeremy\_Moody](https://connective.celigo.com/u/Jeremy_Moody)\
**Post date:** [December 31, 2025, 2:25pm UTC](https://connective.celigo.com/t/cant-update-netsuite-record-with-multiple-sublists/5965/5 "2025-12-31T14:25:55Z")

</div>

@Daniel_P Everybody is correct here.

If you want to set the Primary Customer for the Contact then Ezriah’s and Nuri’s comments will work and you don’t need to attach the Contact because it will happen automatically.

But if you want to have a single Contact that is linked to multiple Customers, then you will need to attach the Contact to the other non-Primary Customers as per Bas’ comment.
