# Mapping Inventory Detail when creating Item fulfillment **URL:** \ **Category:** Integrator.io\ **Tags:** filter, lookup, netsuite\ **Created:** [April 19, 2023, 9:02pm UTC](https://connective.celigo.com/t/mapping-inventory-detail-when-creating-item-fulfillment/477 "2023-04-19T21:02:28Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![weifengyang](https://avatars.discourse-cdn.com/v4/letter/w/848f3c/32.png) [@weifengyang](https://connective.celigo.com/u/weifengyang)\ **Post date:** [April 19, 2023, 9:02pm UTC](https://connective.celigo.com/t/mapping-inventory-detail-when-creating-item-fulfillment/477/1 "2023-04-19T21:02:28Z")
Hi all, I need to be able to automatically populate the serial lot number. My current set up is to do an Item look up for serial lot, but I am getting more than one result, because I have multiple serial lot per item. Is there a way for me to grab one with the most available? Is also a way for me to add a filter "greater than or equal to" to Inventory Location : Available? ![5301043caa20740200000001-97cfabeeed7342349866019c6585b7a5.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/52326865d0b6c88eb46a8858079e582aeb84ad6a.png) ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [April 20, 2023, 8:06pm UTC](https://connective.celigo.com/t/mapping-inventory-detail-when-creating-item-fulfillment/477/2 "2023-04-20T20:06:05Z")
Looks like a duplicate thread going over here in case anyone else runs into this. [https://netsuiteprofessionals.slack.com/archives/CFG7DNCM9/p1682015369032499](https://netsuiteprofessionals.slack.com/archives/CFG7DNCM9/p1682015369032499) ---
**Author:** ![ezelle](https://avatars.discourse-cdn.com/v4/letter/e/e79b87/32.png) [@ezelle](https://connective.celigo.com/u/ezelle)\ **Post date:** [September 3, 2023, 4:33pm UTC](https://connective.celigo.com/t/mapping-inventory-detail-when-creating-item-fulfillment/477/3 "2023-09-03T16:33:58Z")
Hi @tylerlamparter, is it possible to read through the above case? I could not access the link because I'm not part of the NetsuiteProfessionals workspace. ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [September 6, 2023, 2:12pm UTC](https://connective.celigo.com/t/mapping-inventory-detail-when-creating-item-fulfillment/477/4 "2023-09-06T14:12:39Z")
@ezelle I forgot that the NetSuite Professionals Slack workspace is non paid and therefore doesn't keep chat history past 90 days. Next time I'll make sure to copy the information over here. @weifengyang if you remember how you resolved this, maybe you can post the answer here? ---
**Author:** ![ianluck](https://avatars.discourse-cdn.com/v4/letter/i/bb73d2/32.png) [@ianluck](https://connective.celigo.com/u/ianluck)\ **Post date:** [May 23, 2024, 3:15pm UTC](https://connective.celigo.com/t/mapping-inventory-detail-when-creating-item-fulfillment/477/5 "2024-05-23T15:15:42Z")
Hello I ran into the same issue here - is there an answer here to this question? @tylerlamparter ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [May 24, 2024, 8:35pm UTC](https://connective.celigo.com/t/mapping-inventory-detail-when-creating-item-fulfillment/477/6 "2024-05-24T20:35:07Z")
@ianluck @ezelle you can find the archive on the NetSuite professionals website: [https://archive.netsuiteprofessionals.com/t/10390091/hi-has-anyone-done-a-custom-flow-on-celigo-to-create-item-fu](https://archive.netsuiteprofessionals.com/t/10390091/hi-has-anyone-done-a-custom-flow-on-celigo-to-create-item-fu)