PO re-order for negative stock items

  • bullyambition June 9, 2019 at 1:48 pm

    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?

    Jerry June 9, 2019 at 5:50 pm

    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.