Navigate to Lists > Search > Saved Searches > New.
Select Item as the Search Type.
Under Criteria tab, add the following filter:
Field | Description | Formula
- Use Bins | is true
- Formula (Numeric) | is 1 | Case when {inventorylocation.id}={inventorynumberbinonhand.location.id} then 1 else 0 end
- Inventory Number/Bin on Hand : On Hand | is greater than 0
Under Results tab, click the Remove All button and add the following fields:
Field | Summary Type | Custom Label
- Type | Group
- Name | Group
- Description | Group
- Inventory Location | Group
- Formula (Numeric) | Sum | ({locationtotalvalue}/{locationquantityonhand})*{inventorynumberbinonhand.quantityonhand} | Total Value
- Inventory Number/Bin on Hand : Bin Number | Group
- Inventory Number/Bin on Hand : On Hand | Sum
- Formula (Text) | Maximum | Replace(ns_concat({inventorynumberbinonhand.inventorynumber}), ‘,’,'<br>’) | Serial/Lot Numbers