Inventory Advanced Queries

If your Qty desired is less than your Qty to be available – which is your forecasted Qty on hand based on actual pending Sales Orders and Purchase Orders, then you should use Qty to order column.

Your condition should now be:

Where Qty to order is not zero