You can set re-order-point to zero for the discontinued products. Then add a SQL command at bottom of advanced stock requirement formula:
DELETE #AutoOrderItems where QtyReorderPoint=0
We can help to set up a more advanced formula based on your expected sales, this normally involves some custom works.
