# How to indicate received quantity mapping when creating item receipts **URL:** \ **Category:** Integrator.io\ **Tags:** transformation, netsuite\ **Created:** [June 17, 2025, 7:45pm UTC](https://connective.celigo.com/t/how-to-indicate-received-quantity-mapping-when-creating-item-receipts/4840 "2025-06-17T19:45:32Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Ethan\_Kutch](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/ethan_kutch/32/7661_2.png) [@Ethan\_Kutch](https://connective.celigo.com/u/Ethan_Kutch)\ **Post date:** [June 17, 2025, 7:45pm UTC](https://connective.celigo.com/t/how-to-indicate-received-quantity-mapping-when-creating-item-receipts/4840/1 "2025-06-17T19:45:32Z")
Hello, I am exporting item receipt data out of a MS DB with a SQL query to transform purchase orders and create item receipts in NetSuite. I am grouping my records by PO # with Celigo and am successfully transforming the PO to create an item receipt by indicating the PO # I set to the "Created from" field. However, I am having difficulty indicating the actual quantity of received items on my receipts I am creating, as Celigo is always creating a receipt that indicates it has received all items I was hoping to receive some advice on how to indicate this within my mapping correctly. I have tried a combination of approaches including mapping my correct DB field 'Quantitynormalized' and the internalid of my NS item 'NSItemInternalID'. I believe my issues lies in the mapping for my NS item id based on info received in a Celigo Office hours call but we were unsure what syntax to use. Any help would be appreciated! Sample Export : ![The image displays a configuration screen for exporting data records, grouped by purchase order number, alongside a parsed JSON output detailing inventory and product information. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/7/7cb7b4cbf7cdd33721b4f165433f14004ac4b94d.png) Mapping : ![The image shows an interface for mapping Microsoft SQL fields to NetSuite fields with input and output JSON examples. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/24da7cf4c48ce9bb5940dde0e286337486c0e915.png) Internal NS Fields of a fully transformed Item Receipt ![The image shows a browser window displaying XML code, likely from a NetSuite accounting application, detailing transaction or order information. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/f/f10ab5446b28c20881df607eef2676c5396de4d6.png) ---
**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:** [June 18, 2025, 7:38am UTC](https://connective.celigo.com/t/how-to-indicate-received-quantity-mapping-when-creating-item-receipts/4840/2 "2025-06-18T07:38:14Z")
In the preview in your screenshot it's strange that your item id is being mapped on the receipt header level, and not in the item\>lines array. Maybe the spelling in the mapping isnt exactly what the NetSuite label is. ![The image shows a JSON output with highlighted fields related to 'celigo' settings and an internal item ID. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/4d61a6ef47d9bee62017f9624248498f7760536e.png) Can you try deleting the current mapping for itemid, adding it again using the auto-complete and try if it maps into the array then? ---
**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:** [June 18, 2025, 9:35am UTC](https://connective.celigo.com/t/how-to-indicate-received-quantity-mapping-when-creating-item-receipts/4840/3 "2025-06-18T09:35:17Z")
Try mapping the NSItem id with destination: `Items : Item (Field ID: itemkey)` It seems the you typed Internal Id in the the destination field manually, because there is **no autocomplete for `Items : Item (InternalId)`**. However that field **doesn't exist** on the item sublist of Item Receipts in NetSuite. For mapping an inventory item by its internal ID in a line-level context, the correct field to use is: `Items : Item (Field ID: itemkey)` When you manually enter a non-existent destination field like `"Items : Item (InternalId)"`, Celigo treats it as a header-level field (inside `nlobFieldIds`) instead of part of the item lines (`nlobSublistIds`). That’s why the item didn’t show up in the `lines` array. Here's the relevant schema excerpt for the `item` sublist on the Item Receipt record in NetSuite — note that `itemkey` is the correct internal ID field: ![The image shows a table listing various attributes related to 'Items', each with details about their internal ID, type, label, requirement status, and additional help information. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/d59f92545a0db518a82545b8be45a1ecf8e4b2b5.png) ---
**Author:** ![kellyizer](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kellyizer/32/4369_2.png) [@kellyizer](https://connective.celigo.com/u/kellyizer)\ **Post date:** [June 18, 2025, 4:56pm UTC](https://connective.celigo.com/t/how-to-indicate-received-quantity-mapping-when-creating-item-receipts/4840/4 "2025-06-18T16:56:46Z")
Ethan, Thank you for attending Office Hours yesterday and as discussed here is the solution we were referring to. > [@Understanding When to Use itemkey, itemname, and sitemname Fields in NetSuite Item Fulfillment Records](https://connective.celigo.com/t/understanding-when-to-use-itemkey-itemname-and-sitemname-fields-in-netsuite-item-fulfillment-records/4567/3): > > Also, we often use this field that isn't available in the dropdown: item[\*].item.internalid. This lets you map to the item's internal ID, which would be the typical way most other records you work with operate. If you put in `item[*].item.internalid` it will let you map directly to the internalId of the item you are trying to receive against and add the quantities to that item to create a partial receipt. ---
**Author:** ![kellyizer](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kellyizer/32/4369_2.png) [@kellyizer](https://connective.celigo.com/u/kellyizer)\ **Post date:** [June 18, 2025, 10:05pm UTC](https://connective.celigo.com/t/how-to-indicate-received-quantity-mapping-when-creating-item-receipts/4840/5 "2025-06-18T22:05:34Z")
Here is a video showing the working solution. [po\_receipt\_by\_internalId](https://eng7e.seismic.com/i/xB8bx8XA9qdlYCyQgI9RUt7nWKh2Ph47DQwBwDHLxzPLUSSIGNzicbqRPLUSSIGNcrIujb ___VX13J6RZBbhmyXXYOd2BcTKv4lxVcM65ucwslmLaoDRHAl28___ W8XhOguQLrZMEiZiHyd7Pa) ---
**Author:** ![Ethan\_Kutch](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/ethan_kutch/32/7661_2.png) [@Ethan\_Kutch](https://connective.celigo.com/u/Ethan_Kutch)\ **Post date:** [June 23, 2025, 5:29pm UTC](https://connective.celigo.com/t/how-to-indicate-received-quantity-mapping-when-creating-item-receipts/4840/6 "2025-06-23T17:29:38Z")
Hi all, Apologies for the delayed response I was out for the remainder of last week. I was able to add the corresponding mapping and accurately create a partially received receipt. My main issue was the way I was receiving the data initially so I had to do a quick transformation to make sure items were in a sublist for each PO. Thanks again for all your help.