# 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:** 2
**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, 2:36am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/21 "2025-03-13T02:36:53Z")
I believe custom flow, any way I can tell? ---
**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, 3:13am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/22 "2025-03-13T03:13:58Z")
I replicated what you showed, I'm getting a weird sum, please see attached ![Screen Shot 2025-03-12 at 10.13.24 PM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/5a8f46677cb38be96d3b284bb3dae72d969e0e5a.jpeg) ![Screen Shot 2025-03-12 at 10.13.15 PM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/3190d64d21ea04427ace2cb1ed6c10acad34918a.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 13, 2025, 4:09am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/23 "2025-03-13T04:09:40Z")
You had posted under the #Integration Apps category so I assumed you are using a IA. You can tell by looking at the description on the tile. Where is this inventory going to? ![This image shows two dashboard cards indicating successful integrations, one titled "9.16.2024 HubSpot Deals - NetSuite" and the other titled "Amazon - NetSuite," with a highlight on "Integration app." (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/e/ee0a9085d55e8854742538bcb09dc9902e092106.png) You might then just need to make a search for "Inventory and Bin Numbers" and not an "Item" search. ![The image shows a NetSuite inventory and bin numbers search results screen, displaying items with inventory numbers "123" and "ABC123," their quantities on hand and available, both located in Austin. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/6cf66e102cd88cb0e55fe1e87d1ba4fd8f2e88a8.png) ![This image shows a "Saved Inventory and Bin Numbers Search" interface with options for sorting and displaying results, including columns for fields like Bin Number and Inventory Number. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/95105eaf57c77c83a9c4083c4f45e60c4c2a0a9f.png) If this is an IA, then you wouldn't be able to change the saved search record type and would need to make your own flow outside of the IA. ---
**Author:** ![Slobodan\_Sobic](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/slobodan_sobic/32/7002_2.png) [@Slobodan\_Sobic](https://connective.celigo.com/u/Slobodan_Sobic)\ **Post date:** [March 13, 2025, 11:25am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/24 "2025-03-13T11:25:11Z")
Hello @calvinlee936 , You saved search should be build from "Inventory Balance" in order to limit the specific bin for specific item. Let me know if you still need assistance on this. Regards, ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 14, 2025, 2:37am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/25 "2025-03-14T02:37:44Z")
Yes it is an IA. Let me contact celigo support to see what can be done. ---
**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 14, 2025, 2:56am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/26 "2025-03-14T02:56:23Z")
Since this primarily involves customizing your NetSuite saved search to generate the desired output within an item search, support won’t have much more to offer. The record type in the IA cannot be changed from Item to another type. While the IA is designed to cover most customer use cases, it doesn’t address every scenario. This might be a great opportunity for you to build your own flow, and there are plenty of resources to guide you through the process. Additionally, sending inventory to Shopify is relatively straightforward, so getting started shouldn’t be too difficult. If you decide to go this route, we offer office hours every Tuesday ([link](https://connective.celigo.com/t/get-real-time-help-in-office-hours/876)), and you can also seek help in the #Integrator.io channel or explore training through the [Celigo University](https://training.celigo.com/). ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 14, 2025, 3:32am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/27 "2025-03-14T03:32:02Z")
If I go this route to build my own flow, and turn off the IA flow, will that affect the number of flows I have running? ---
**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 14, 2025, 2:11pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/28 "2025-03-14T14:11:47Z")
No because you would turn off the IA flow and turn on your own flow. ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 19, 2025, 2:26am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/29 "2025-03-19T02:26:56Z")
Hey Tyler, trying to create the saved search now with inventory and bin numbers but coming up pretty short with results. Any ideas why this isnt populating any results? ![Screen Shot 2025-03-18 at 10.26.06 PM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/48976c4b9519dadffe8b58b5af0273ad8f63e752.jpeg) ![Screen Shot 2025-03-18 at 10.25.59 PM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/a/a7561f78fa065cef132ea3822db410f6a9f7d3ba.jpeg) ![Screen Shot 2025-03-18 at 10.25.54 PM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/43cb33f455e715c4cb146c1de74c667f17ff13aa.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 19, 2025, 2:41am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/30 "2025-03-19T02:41:53Z")
If you have no criteria, do you have any results at all? ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 19, 2025, 2:55am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/31 "2025-03-19T02:55:44Z")
the criteria i am using is bin number does not contain FLX, is that not the criteria you would use? I have over 300 bins in netsuite, was trying to avoid clicking in 280+ bins in the desc. field ---
**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 19, 2025, 4:17am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/32 "2025-03-19T04:17:37Z")
I was trying to understand why you get no results on the output. However, as mentioned during office hours, you'll need to make an item search if you're going to continue using the IA. Follow this suggestion ([Saved search to pull inventory from specific bins per location? - #20 by tylerlamparter](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/20)) and set up the search as you had it before: ![The image shows a software interface for creating or editing an item search query, featuring options for sorting, output type, and defining columns with functions and formulas. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/68a27db4fdc066304f51b85e2f43bec02fb45cb5.png) ![The image displays an "Item Search: Results" page from NetSuite, showing a table with item IDs, quantities, and locations, all listed under Austin, with a total quantity of 527. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/52b15ac151fe9c5b527eae41624958d40ccd9e8f.png) ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 19, 2025, 6:36pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/33 "2025-03-19T18:36:44Z")
Hey tyler, I think the problem I was running into using an item search was that the sums of the inventory in bin on hand avail was presenting some weird numbers, please ![Screenshot 2025-03-19 143537](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/c8223d28c3a11c9b62f12f0bdb65b1e94b581186.png) see attached ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 19, 2025, 6:40pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/34 "2025-03-19T18:40:48Z")
I think I'm going to go off and just create a custom flow and turn off the IA. ---
**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 19, 2025, 7:48pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/35 "2025-03-19T19:48:22Z")
In this case though, what are you using for "location id"? ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 19, 2025, 8:14pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/36 "2025-03-19T20:14:28Z")
The formula you provided, which works flawlessly! Case when (miami)=1, etc etc., may you suggest where I may start for this saved search? I think an item search will produce the same weird sum numbers right? ---
**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 19, 2025, 9:17pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/37 "2025-03-19T21:17:45Z")
Shouldn't be an issue if you are careful with what sublists you are referencing. I noticed in your prior screenshot that you had criteria for "Inventory Detail: Bin Number," but you should make the filter for "Bin On Hand: Bin Number." By using the inventory detail, you are telling NetSuite to make yet another join, which then balloons the quantities. ![This image shows a "Saved Item Search" interface for filtering inventory by bin number in a software application. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/13c399f5d45492861c369b6375705fda6bc809f6.png) ![This image is a screenshot of a report configuration interface showing options for sorting, output type, columns, and formulas used in a data report. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/9edd49dcef068244c86eaf9df2d1025106d295ff.png) ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 19, 2025, 9:29pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/38 "2025-03-19T21:29:05Z")
Tyler, that worked...!!!!! I have been breaking my head for the past 7 days with 2-3 hour sessions.... Thank you sir. I appreciate this! Now i just have to create the custom flow in celigo and turn off the IA flow right? Or do you think the formula you created with a custom column label mimicking"location\_id" would suffice? ---
**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 19, 2025, 10:00pm UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/39 "2025-03-19T22:00:27Z")
I would just use this new search in the IA. It should work fine ---
**Author:** ![calvinlee936](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calvinlee936](https://connective.celigo.com/u/calvinlee936)\ **Post date:** [March 20, 2025, 2:21am UTC](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224/40 "2025-03-20T02:21:16Z")
Testing this out with just 1 item record. Celigo can't seem to output anything from my saved search even with these results ![Screen Shot 2025-03-19 at 10.20.23 PM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/39076df49f5e0cdb5156570241618afac83cfc16.jpeg) ![Screen Shot 2025-03-19 at 10.20.14 PM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/5d0a6fd78750eea5edd01f5fff704e55d90b5cb2.jpeg) [Previous page](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224.md?page=1) [Next page](https://connective.celigo.com/t/saved-search-to-pull-inventory-from-specific-bins-per-location/3224.md?page=3)