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