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
- Contabilità
- Magazzino
- PoS
- Progetti
- MRP
La domanda è stata contrassegnata
3
Risposte
7480
Visualizzazioni
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
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
1
giu 24
|
2358 | ||
|
1
giu 20
|
6584 | ||
|
9
nov 16
|
15587 | ||
|
0
set 15
|
5099 | ||
|
0
lug 15
|
3879 |
