This topic contains 1 reply, has 1 voice, and was last updated by  Jerry 1 month, 1 week ago.

PO re-order for negative stock items

  • I don’t have reorder point and min/max quantity settings. How do I make a purchase order to automatically add items currently have negative stock onhand quantities?

    Use the advanced formula.

    UPDATE #AutoOrderItems SET ExpectedSales=0

    UPDATE #AutoOrderItems SET StockRequirement=-QtyOnhand-QtyOnOrder-QtyToBePosted-QtyIT
    where QtyOnhand+QtyOnOrder+QtyToBePosted+QtyIT<0

You must be logged in to reply to this topic.