CVS for Stockout (low inventory) or Filter for different Categories
Having a way to export a full stockout report or a way to filter out categories as I maintain several different accessories through many different vendors.
lpoolegadgetgave
shared this idea
-
Mike Chandler
commented
add restocking formula to the stockout. example editable fields category, sales period, stock amount is days.
This would run a report and adjust the min max order quantity to actual sales.
example, over 30 days if you sold 15 items the calu would read .5 per day
then you would set the stock amount in days to 10 days (estimating you need to make sure you have 10 days on hand)
then you run the purchase order and the formula would replenish the inventory to the amount needed.
it is very hard to manage aging items manually as items stop selling overtime and this system will automate the ordering process.