# NetSuite Import Mapping to update existing Contract Lines

**URL:** <https://connective.celigo.com/t/netsuite-import-mapping-to-update-existing-contract-lines/5924>\
**Category:** Integrator.io\
**Tags:** netsuite\
**Created:** [December 5, 2025, 3:06am UTC](https://connective.celigo.com/t/netsuite-import-mapping-to-update-existing-contract-lines/5924 "2025-12-05T03:06:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sujitdesai](https://avatars.discourse-cdn.com/v4/letter/s/e79b87/32.png) [@sujitdesai](https://connective.celigo.com/u/sujitdesai)\
**Post date:** [December 5, 2025, 3:06am UTC](https://connective.celigo.com/t/netsuite-import-mapping-to-update-existing-contract-lines/5924/1 "2025-12-05T03:06:18Z")

</div>

Hello!

I am trying to query line data of NetSuite Contract (native transaction type = estimate). I am querying all three line Ids using saved search

1. Line
2. Line Sequence Number
3. Line Unique Key  
In a later step I am trying to update these NetSuite Contrace lines in a NetSuite Import.  
In the import I see following Line Id fields for Contract Items
4. Line ID
5. Line Number (fieldid: linenum)
6. Line Number (fieldid: linenumber)

Which Line ID from Transaction Saved Search should be mapped to which NS Import Line ID so that it will successfully update the lines without getting following errors:

1. “Failed to save record because Please enter a value for amount.“ I am using following mapping

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

Thanks!

---

<div class="post-metadata">

**Author:** ![mengdionisio](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/mengdionisio/32/7648_2.png) [@mengdionisio](https://connective.celigo.com/u/mengdionisio)\
**Post date:** [December 9, 2025, 12:03pm UTC](https://connective.celigo.com/t/netsuite-import-mapping-to-update-existing-contract-lines/5924/2 "2025-12-09T12:03:26Z")

</div>

Hi @sujitdesai 👋  
I've endorsed this to our CEE team, and they're currently looking into this. I will let you know as soon as there's an update. Thanks!

---

<div class="post-metadata">

**Author:** ![srisathyaks73](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@srisathyaks73](https://connective.celigo.com/u/srisathyaks73)\
**Post date:** [December 9, 2025, 12:17pm UTC](https://connective.celigo.com/t/netsuite-import-mapping-to-update-existing-contract-lines/5924/3 "2025-12-09T12:17:59Z")

</div>

> [@sujitdesai](#):
>
> Which Line ID from Transaction Saved Search should be mapped to which NS Import Line ID so that it will successfully update the lines

@sujitdesai

Can you please share your flow ZIP and the sample input JSON?