# Saved search to pull inventory from specific bins per location? **URL:** \ **Category:** Integration Apps\ **Tags:** netsuite\ **Created:** [February 20, 2025, 8:02pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224 "2025-02-20T20:02:31Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [February 20, 2025, 8:02pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/1 "2025-02-20T20:02:31Z")
Hello all! We currently have 2 warehouses with inventory and going on to adding a 3rd location. This 3rd location will be an interesting addition since the inventory in the warehouse will be owned by HQ, and the retail store will be operating as a separate company, yet nesting inside the same netsuite(Yes lots of accounting work to be done, but it's the simplest way). Regardless, from what I know, Celigo pulls inventory from the “Purchasing/Inventory Subtab” for our 2 locations. For our 3rd location, is there anyway to specify that the inventory gets pulled from a specific bin location? ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [February 22, 2025, 5:42pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/2 "2025-02-22T17:42:43Z")
Bump, any ideas, trying to finalize our 3rd locations bins ---
**Author:** ![mattie.mayfield](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/mattie.mayfield/32/6591_2.png) [@mattie.mayfield](https://connective.celigo.com/u/mattie.mayfield)\ **Post date:** [February 25, 2025, 2:51pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/3 "2025-02-25T14:51:31Z")
Hey Calvin, great topic! I’m currently looking into your question and finding someone to give you an answer. I appreciate your patience! ---
**Author:** ![coryanderson](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@coryanderson](https://connective.celigo.com/u/coryanderson)\ **Post date:** [February 25, 2025, 3:50pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/4 "2025-02-25T15:50:37Z")
Hi Calvin. What integration is this for? Where are you sending inventory quantities to? You can probably modify the saved search to specify the bin location for the 3rd location, but it might be a little tricky. Can you post a screen shot of your saved search results tab? ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [February 25, 2025, 4:14pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/5 "2025-02-25T16:14:47Z")
Hey There Cory! Thanks for the reply! This is integrating Netsuite with Shopify. Sending inventory from Netsuite to shopify. Currently we're running a negative 10 buffer for all locations(3rd one isn't fully live yet), however I'd like to get more granular, specifying bin locations on 3rd location, and 2nd location, and just running a buffer for our Main HQ location. If that is even possible at all, im sure its a huge formula. ![Screenshot 2025-02-25 111321](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/9a9798a60a7b9d7829b7917b511ffaba7f79b24e.png) ---
**Author:** ![coryanderson](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@coryanderson](https://connective.celigo.com/u/coryanderson)\ **Post date:** [February 25, 2025, 7:00pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/6 "2025-02-25T19:00:27Z")
Calvin - I would start by seeing if you can restrict the quantities with the criteria of the search. So you would 'Use Expressions' and try to group the location with the bin that you would want the quantities to come from. ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [February 25, 2025, 10:12pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/7 "2025-02-25T22:12:50Z")
May you be more specific on setting the criteria with the "Use expression"? ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [February 26, 2025, 3:46pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/8 "2025-02-26T15:46:06Z")
Tried to use specific " bins not including" and it doesn't reflect. it still grabs the entire inventory. ---
**Author:** ![coryanderson](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@coryanderson](https://connective.celigo.com/u/coryanderson)\ **Post date:** [February 27, 2025, 5:01pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/9 "2025-02-27T17:01:04Z")
Calvin - I was thinking something like this: ![The image shows a filter expression setup screen where inventory location is set to "Denver" and the bin number to "Z1-PB-01," with options to add or edit the expression. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/1157436465899c8fece980f606014eedbf2139fd.png) ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [February 27, 2025, 5:23pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/10 "2025-02-27T17:23:51Z")
Brilliant, let me try that out. ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 3, 2025, 3:23pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/11 "2025-03-03T15:23:39Z")
Doesn't seem to drop out the inventory from that specific bin unfortuntely. ---
**Author:** ![coryanderson](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@coryanderson](https://connective.celigo.com/u/coryanderson)\ **Post date:** [March 3, 2025, 10:29pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/12 "2025-03-03T22:29:38Z")
Calvin - depending on the configuration of NetSuite, you might need to do something like this instead: ![The image shows a user interface for setting expressions or filters with conditions based on inventory location and details, including options to add, cancel, and modify entries. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/defc186347a0ef10342164334fd3b405f6ef83a0.png) I recommend restricting the search to just one item and using the bin that you know has available qty for that item. In this example the results would look this: ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/1fc9b25bb2ab84e6a44c4a71ebfff9757c7c4cca.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:** [March 6, 2025, 6:52pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/13 "2025-03-06T18:52:07Z")
@calvinlee936 where you able to get this going? What does your current search look like and what output are you getting? ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 6, 2025, 9:55pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/14 "2025-03-06T21:55:38Z")
No I wasnt able to get this going Attached is how I did my new saved search for specific bins. However I am returning multiple results per location with same inventory numbers. See attached my criteria tab, results tab, and my inventory detail tab for this one specific test item. ![Screenshot 2025-03-06 165514](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/3a7ff125b060081b70b571e99d444dbd6f0b4279.png) ![Screenshot 2025-03-06 165447](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/c732bf3ece451d14d61c66ec4555d79d22b9f8d3.png) ![Screenshot 2025-03-06 165426](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/4934aa139603d60da25d6ee87a3b9f6bbf45b895.png) ![Screenshot 2025-03-06 165413](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/7/7a8f7acf6e86648509fcf3d571113efb28c6c89a.png) ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 10, 2025, 6:13pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/15 "2025-03-10T18:13:28Z")
Bump on this, need more visibility ---
**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:** [March 10, 2025, 6:28pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/16 "2025-03-10T18:28:34Z")
You should add more inventory detail fields to the output of your saved search to figure out what needs to be filtered. Like you first want the output there to not have duplicates and then after that you would need to add summary types to the outputs so that they sum up to the same location vs having a row per bin. ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 12, 2025, 1:48pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/17 "2025-03-12T13:48:52Z")
I've gotten this far by grouping the results. But I cant seem to find a way to display the internal ID per line. If I group the Location internal ID, it creates the duplicates again. See attached. ![Screen Shot 2025-03-12 at 9.39.45 AM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/7/703cb811ddcd421878f9221520e56aa356a4978f.jpeg) ![Screen Shot 2025-03-12 at 9.39.37 AM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/a/a66868cf9b0b0e694352752f3ffaefe76332e5b2.jpeg) ![Screen Shot 2025-03-12 at 9.39.03 AM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/bfa3f0653b9187b46ccdf5bbea88ccc142af8f62.png) ![Screen Shot 2025-03-12 at 9.38.46 AM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/4be77a017cbbc928c765c087c17ff2b83963a5fe.jpeg) ---
**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:** [March 12, 2025, 9:47pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/18 "2025-03-12T21:47:51Z")
Yeah, this is where NetSuite gets tricky and has limitations. You would need to use the "Bin On Hand: Location" field, but that gives you the location name and not the location internal ID. When you use "Location," NetSuite makes two joins to the item table, one join to locations and another to bins, which is why you end up with duplicated rows. This is just a saved search limitation. If the location name is fine for you, then maybe that would suffice? ![This image displays a "Saved Item Search" page from NetSuite, showcasing a search interface with various filtering and display options. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/e/eaeb820596864ce1b5764f1cfdb9bc274e5f941e.png) ![The image shows a NetSuite interface displaying an item search results page with two inventory items listed, detailing their internal IDs, names, quantities, and locations. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/d9b3f910ac19855615a0ef61d8b5274aa639dc41.png) ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 13, 2025, 1:17am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/19 "2025-03-13T01:17:56Z")
Hmm that's curious. might work for me. I think I'll just have to remap the Celigo lookup for the locations. Is that simple to do? ---
**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:** [March 13, 2025, 1:25am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/20 "2025-03-13T01:25:37Z")
Are you in a custom flow or IA? You could output the location id by using a formula field where "case when bin location = 'Austin' then 1 when ... end". As you add new locations you would just need to update this. [Next page](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224.md?page=2)