# Dynamic Lookup to get Item Fulfillment Internal ID from Sales Order Number

**URL:** <https://connective.celigo.com/t/dynamic-lookup-to-get-item-fulfillment-internal-id-from-sales-order-number/726>\
**Category:** Integrator.io\
**Tags:** lookup, netsuite\
**Created:** [June 29, 2022, 11:48am UTC](https://connective.celigo.com/t/dynamic-lookup-to-get-item-fulfillment-internal-id-from-sales-order-number/726 "2022-06-29T11:48:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![anekporwal842](https://avatars.discourse-cdn.com/v4/letter/a/46a35a/32.png) [@anekporwal842](https://connective.celigo.com/u/anekporwal842)\
**Post date:** [June 29, 2022, 11:48am UTC](https://connective.celigo.com/t/dynamic-lookup-to-get-item-fulfillment-internal-id-from-sales-order-number/726/1 "2022-06-29T11:48:10Z")

</div>

Hi Everyone,  
How can get an Item Fulfillemt Internal ID using Sales Order Number in Netsuite using Lookup?   
I have also tried Created From Sales Order Field but I am getting an Error

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

 ![5301043caa20740200000001-c9886c2170974ee0ac7f59ab611e95fa.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/f/f0d6e08e071a807b4c07872b79933fd771cefd32.png)

---

<div class="post-metadata">

**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:** [July 5, 2022, 9:21pm UTC](https://connective.celigo.com/t/dynamic-lookup-to-get-item-fulfillment-internal-id-from-sales-order-number/726/2 "2022-07-05T21:21:59Z")

</div>

I would try adding a filter for mainline = 'T'. You can test this out by making a saved search in NetSuite with the same criteria and seeing what the output is.