Monday, March 18, 2019

Search to show list of items with lot number on hand not equal to lot number available

1. Create an item search in Lists > Search > Saved Searches > New > Items

2. Set the following in the Criteria Tab:

On Hand = is greater than 0

Formula Numeric = is 1 ________ Formula = case when {inventorynumber.quantityavailable}!={inventorynumber.quantityonhand} then 1 else 0 end

3.  Set the following in the Results tab:



Inventory Number: Warehouse

Inventory Number: Number

Inventory Number: On Hand

Inventory Number: Available



No comments:

Post a Comment