Create Saved Search for On Hand and Available Quantities per bin and Location
1.Navigate to Reports > Saved Searches > All Saved Searches > New
2. Click Item
3. Search Title: Enter Title
Example: On Hand and Available Quantity per Bin and per Location
4. Click Criteria
5. Click Standard
6. Filter:
○ Select Formula (Numeric)
i. Formula: case when {binonhand.location} = {inventorylocation} then 1 else 0 end
ii. Formula (Numeric): Select equal to
iii. Value: Enter 1
iv. Click Set
○ Select Bin on Hand fields…
i. Bin on Hand Filter: On Hand
ii. On Hand: Select not equal to
iii. Value: Enter 0
iv. Click Set
7. Click Results
8. Click Columns
9. Field:
Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed.
○ Select Name
1. Summary Type: Group
2. Click Add
○ Select Internal ID
1. Summary Type: Maximum
2. ClickAdd
○ Select Inventory Location
1. Summary Type: Select Group
2. Click Add
○ Select Bin on Hand fields…
1. Bin on Hand field: Select Bin Number
2. Summary Type: Select Group
3. Click Add
○ Select Bin on Hand fields…
1. Bin on Hand field: Select Available
2. Summary Type: Select Group
3. Click Add
○ Select Bin on Hand fields…
1. Bin on Hand field: Select On Hand
2. Summary Type: Select Group
3. Click Add
10. Show Totals:
○ Enter Checkmark
11. Click Save & Run
