Replenishment Calculation problems

The Max Qty is not calculated and needs to be set manually.  For example, when using Min/Max as a replenishment method the max is usually set to accommodate shelf space or tank aize.  For Fixed Reorder Qty the max might be reflective of an EOQ.

I do not understand your reply.  See screen shot below that shows that it is calculating the Max Qty.  What good is the software if it is not automatically going to take into account the Amount of sales you have over a period of time and automatically calculate what you need to set as your order points.    

​@kbuelow did you resolve this?  I’m curious about the same thing.  In your example above, based on the calculations that Acumatica uses, I would expect a re-order point calculation that goes roughly something like this (leaving safety stock out of the mix for simplicity):

11 items per week (average between 10 and 12) / 7 days in a week = 1.57 a day x 5.22 days of lead time

= 8.2 items per order.

But this does mean you are re-ordering every 5 days, and this aligns with a Just In Time philosophy, which means you are holding almost no stock.  JIT requires very predictable demand and perfectly reliable suppliers, rare for most businesses.

You can overcome this with safety stock but still, the results of the calculations as they stand would need to be modified one by one, so it’s not just a matter of calculating and implementing.  For each item you have to modify the values, and as you say, a parameter with number of days of stock to hold (meaning how often you want to re-order), would be useful.

Please let me know if/how you overcame this.