NSC | How to Show Preferred Bins by Location in an Item Saved Search

Scenario

A common warehouse reporting requirement is to create an Item Saved Search that displays:

• Inventory by Bin
• Inventory by Location
• Preferred Bin per Location
• On Hand Quantity by Bin

The challenge occurs when an item has multiple preferred bins across different locations. In many cases, a formula such as:

CASE WHEN {preferredbin} = 'T' THEN {binnumber} ELSE NULL END

returns all preferred bins for the item instead of only the preferred bin tied to the selected inventory location.

This can create duplicate rows and make warehouse reporting difficult to interpret.

Solution

The issue can be resolved by adjusting the formula so the Preferred Bin is matched specifically against the Bin On Hand Location.