Create Report to Show Items on the Bins

The user needs an Item Saved Search that shows all Items on the Bin.

1. Navigate to Lists > Search > Saved Searches > New
2. Click Item
3. Search Title: Enter Title
4. Click Criteria
5. Click Standard
6. Add:
   1. Use Bins is True
   2. Bin On Hand Fields... > On Hand is greater than 0
   3. Formula (Text) is 1 | case when {inventorylocation.id} = {binonhand.location.id} then 1 else 0 end
7. Click Results
8. Add:
   1. Bin On Hand Fields... > Bin Number | Summary Type: Group
   2. Name
   3. Bin On Hand Fields... > On Hand
   4. Inventory Location
   5. Formula (Text) | Summary Type: Maximum | replace(ns_concat({name} || '|' || {binonhand.quantityonhand} || '|' || {inventorylocation}),',','<br>') | Summary Label: Items on the Bin
9. Click on Save & Run