This topic contains 1 reply, has 1 voice, and was last updated by Jerry 8 months, 2 weeks ago.
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
You must be logged in to reply to this topic.