# Mapping Items for Netsuite Item Receipt

**URL:** <https://connective.celigo.com/t/mapping-items-for-netsuite-item-receipt/1153>\
**Category:** Integrator.io\
**Tags:** import, flow-builder, netsuite\
**Created:** [April 27, 2021, 8:55pm UTC](https://connective.celigo.com/t/mapping-items-for-netsuite-item-receipt/1153 "2021-04-27T20:55:14Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![hristinabendeva](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@hristinabendeva](https://connective.celigo.com/u/hristinabendeva)\
**Post date:** [April 27, 2021, 8:55pm UTC](https://connective.celigo.com/t/mapping-items-for-netsuite-item-receipt/1153/1 "2021-04-27T20:55:14Z")

</div>

Hello,  
  
I need to make an update for Item Receipt in NetSuite where it updates the quantity of one of the line items and doesn't change the others but when I run the flow it updates all of the lines and closes the Purchase Order. Here are picture of how my import is setup, how I map the data and the data from NetSuite about the Purchase Order:

 ![5301043caa20740200000001-2ded24e8afb54f25a7a971212093eeaf.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/6f126d77b43214ebafa2abf9861b1c27f4a5f993.png)

 

 ![5301043caa20740200000001-2235e338975947a0ae20bed0062f8262.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/5eafe909b095784285950f5330374e6678bb5134.png)

 

 

 ![5301043caa20740200000001-f546007ca0474f26bb3fc468871ab53e.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0a6aa768c8edbab56f458609cf8ddc6ac2e2b01a.png)

---

<div class="post-metadata">

**Author:** ![coryanderson215](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@coryanderson215](https://connective.celigo.com/u/coryanderson215)\
**Post date:** [April 27, 2021, 9:13pm UTC](https://connective.celigo.com/t/mapping-items-for-netsuite-item-receipt/1153/2 "2021-04-27T21:13:11Z")

</div>

If you want to update a line on a record in NetSuite, you can use mapping like this:

 ![5301043caa20740200000001-eb3fbc63034d4c728050433574e7c144.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/e/eceb24907a76800b663bc27e5d86facced4c5080.png)

So you'll need to source the Line ID from a saved search coming out of NetSuite first. I hope that helps.

---

<div class="post-metadata">

**Author:** ![hristinabendeva](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@hristinabendeva](https://connective.celigo.com/u/hristinabendeva)\
**Post date:** [April 27, 2021, 9:31pm UTC](https://connective.celigo.com/t/mapping-items-for-netsuite-item-receipt/1153/3 "2021-04-27T21:31:35Z")

</div>

Hi Cory,

I tried mapping the Line ID instead of the Items : Item (Field ID: itemkey) field but it still updated all of the lines.

Thanks

---

<div class="post-metadata">

**Author:** ![greghockley](https://avatars.discourse-cdn.com/v4/letter/g/ea5d25/32.png) [@greghockley](https://connective.celigo.com/u/greghockley)\
**Post date:** [March 11, 2022, 5:19pm UTC](https://connective.celigo.com/t/mapping-items-for-netsuite-item-receipt/1153/4 "2022-03-11T17:19:59Z")

</div>

Hi Guys

I'm having a similar issue:

If I select a field that is the same on every row of the file in "Group records by fields" in the Data Loader then only the first row gets processed (i.e. if there are ten rows each representing an item that needs to be received only the first item will get received)

 ![5301043caa20740200000001-e02844b66d9b43f899dee6875744a131.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/e/ecce1a2472f575ddcb191d25eedf414ffeb669d6.png)

If I don't perform this grouping then the whole PO gets received

 ![5301043caa20740200000001-7d0ac3629a684b11a95d9965dedcc99f.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0d472867c1356c10d31e01716546c36856e595e5.png)

What I want is for only the items that are in the CSV file that I'm uploading to get received.

Here are my mappings at the import step:

 ![5301043caa20740200000001-1863d453ea244ec9ba0540b52ccdd941.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/914e931e49a553a2a3ab043dfa9a9ef9dced22bd.png)

Any help greatly appreciated!

---

<div class="post-metadata">

**Author:** ![scotthenderson](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/scotthenderson/32/6780_2.png) [@scotthenderson](https://connective.celigo.com/u/scotthenderson)\
**Post date:** [March 11, 2022, 7:42pm UTC](https://connective.celigo.com/t/mapping-items-for-netsuite-item-receipt/1153/5 "2022-03-11T19:42:20Z")

</div>

This is a really common use case, and there is def a way to do it; but it is difficult to say why it is not working for your flow and/or CSV file. You might want to get some quick help from support.

The only idea I have from the pics above is to try setting "Items: Replace All Lines" to true.

You might also find something useful in [this](https://connective.celigo.com/t/creating-a-return-authorization-with-only-a-subset-of-the-items-on-an-order/1182) post.

Good luck!

---

<div class="post-metadata">

**Author:** ![greghockley](https://avatars.discourse-cdn.com/v4/letter/g/ea5d25/32.png) [@greghockley](https://connective.celigo.com/u/greghockley)\
**Post date:** [March 14, 2022, 12:51pm UTC](https://connective.celigo.com/t/mapping-items-for-netsuite-item-receipt/1153/6 "2022-03-14T12:51:18Z")

</div>

Thanks Scott. That worked like a charm!

For anyone else reading this, you also need to group the import by a field that is the same on every row (I used internal ID) to get it to import correctly.
