If:
Qty on hand = 14
min qty = 20
max qty = 50
Quantity multiple = 8
Lead Time = 1
How is the calculus formulated? - How many units will be ordered?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
3
Replies
3900
Views
Hello,
This is how I calculate reordering rules with multiple quantity
Possible Scenarios:
Case-1: My On hand Quantity is 14, Minimum Quantity: 20, Maximum Quantity : 50, Multiple Quantity: 8
Maximum quantity should be ordered = Max qty – On hand qty = 50 – 14 = 36
8 *1 = 8 ( Now the max qty that should order is 36 and it does not meet maximum qty.)
8 *2 = 16 ( it does not meet maximum qty)
8 *3 = 24 ( it does not meet maximum qty)
8 *4 = 32 ( it does not meet maximum qty)
8 *5 = 40 ( it does meet maximum qty) ✓
Ans: 40 units will be ordered
Case-2: My On hand Quantity is 53, Minimum Quantity : 50, Maximum Quantity : 80, Multiple Quantity: 12, Sales order qty = 55
Maximum quantity should be ordered = Max qty + sales order qty – On hand qty = 80 + 55 – 53 = 82
12 *1 = 12 ( Now the max qty that should order is 82 and it does not meet maximum qty.)
12 *2 = 24 ( it does not meet maximum qty)
12 *3 = 36 ( it does not meet maximum qty)
12 *4 = 48 ( it does not meet maximum qty)
12 *5 = 60 ( it does not meet maximum qty)
12 *6 = 72 ( it does not meet maximum qty)
12 *7 = 84 ( it does meet maximum qty) ✓
Ans: 84 units will be ordered
hello stivens,
reordering rule would be triggered because of minimum quantity is 20 and on hand quantity is 14 so it's triggered rule in order to multiply of 8 quantity . Whenever order generated , it will of 8 quantity at time of one order and got products in 1 day as per lead time is 1 day. order of product should be raise until stock will become 50 quantity as maxi qun is 50 .
hope you will understand ...
Thank you...
Hello falguni,
thank you for your answer. But I ran two different scenarios with two identical products I created to simulate the reordering rule:
1st scenario: the qty created on the purchase order was 40
2nd scenario: the qty created on the purchase order was 56
I´m trying to figure it out how Odoo did change those quantities although are the same data.
hey Stevens,...
I thought you have added two different quantity multiple...
Hello Falguni,
No I didn´t , that´s why I am asking for the formula because I want to understand what is take into account.
Hi,
https://www.odoo.com/documentation/user/13.0/inventory/management/replenishment_strategies/min_stock_rule_vs_mto.html
https://webkul.com/blog/reordering-rules-in-odoo/
Aswini iWesabe
