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