Create an Item Saved Search to Show All Bin Numbers per Item

Scenario

The user needs an Item Saved Search that shows all Bin numbers of Items.

Solution

1. Navigate to Lists > Search > Saved Searches > New
2. Click Item
3. Search Title: Enter Title
4. Click Criteria
5. Click Standard
6. Filter:
   Note: For every required filter use the drop-down menu to select it.
   • Select Use Bins
     • Use Bins: Select Yes
     • Click Set
   • Select Formula (Numeric)
     • Formula: Enter case when {‌inventorylocation.id} = {‌binonhand.location.id} then 1 else 0 end
     • Formula (Numeric): Select Equal to
     • Value: Enter 1
     • Click Set
   • Select Bin On Hand Fields...
     • Bin On Hand Field: Select Bin On Hand
     • Bin On Hand: Select On Hand
     • On Hand: Select not empty
     • Click Set
7. Click Results
8. Click Columns
9. Fields:
   Note: Always click Add once Field selected and adjusted as needed.
   • Select Bin On Hand Fields...
     • Bin On Hand Field: Select Bin Number
     • Summary Type: Select Group
   • Select Formula (Text)
     • Formula: Enter replace(ns_concat({‌name}),',','<br>')
     • Summary Type: Select Maximum
   • Select Name
   • Select Bin On Hand Fields...
     • Bin On Hand Field: Select Bin On Hand
10. Click Available Filters tab
11. Filter:
    • Select Inventory Location
    • Show in Filters Region checkbox: Enter checkmark
12. Click Save & Run

Note: Take note that this Item Saved Search is applicable to accounts where Multi-Location Inventory and Advance Bin/Numbered Inventory Management features are enabled.