NSC | Saved Search to show mismatch between Location and Bin Quantity

Scenario

User needs a Saved Search that shows the discrepancies or mismatches between On Hand Qty and what is showing as Bin On Hand Qty.

Solution

This can be accomplished with an Item Saved Search with the following details:

• Criteria > Standard

Formula: CASE WHEN {inventorylocation} = {binonhand.location} THEN 1 ELSE 0 END

• Criteria > Summary

Formula: MAX(NVL({locationquantityonhand},0))-SUM(NVL({binonhand.quantityonhand},0))

• Results tab

Optional Formulas:

To show the mismatch quantity:

Formula (Numeric): max(nvl({locationquantityonhand},0))-sum(nvl({binonhand.quantityonhand},0))

To show the bins and how many on hand quantity in each:

Formula (Text): REPLACE(NS_CONCAT({binonhand.binnumber} || ' (' || {binonhand.quantityonhand} || ')'), ',','<br>')