Create Report to Show Items on the Bins

Written by
Pamela Caringal
Published on
August 31, 2023 at 9:26:38 AM PDT August 31, 2023 at 9:26:38 AM PDTst, August 31, 2023 at 9:26:38 AM PDT

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

  1. Navigate to Lists > Search > SavedSearches > 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