Prevent Reordering of Discontinued Products

  • 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.

    Thanks Benny.  I think this will work.  Appreciate it.

You must be logged in to reply to this topic.