Hi, We have try to figure out why Reordering rules generate RFQ's for the product has just ordered (but not received yet) and amount is more than max amount in rules? For example following product. There is Delivery Lead time 75 days Image [1] Reordering rules have min 15, max 45 and trigger is auto Image [2] And in Forecasts shows that on hand is 7pcs and 30pcs has ordered, total 37pcs. So why it make RFQ with 60pcs and not 30pcs? Image [3] Does it take into count already ordered but not ye

Все посты Люди Значки

Теги (Смотреть все)

odoo accounting v14 pos v15

Об этом форуме

Помощь

Reordering rules orders too much?

purchase_order reordering-rules 17

1 Ответить

1727 Представления

Timo Nisula

Hi,

We have try to figure out why Reordering rules generate RFQ's for the product has just ordered (but not received yet) and amount is more than max amount in rules?

For example following product. There is Delivery Lead time 75 days

Reordering rules have min 15, max 45 and trigger is auto

And in Forecasts shows that on hand is 7pcs and 30pcs has ordered, total 37pcs. So why it make RFQ with 60pcs and not 30pcs?

Does it take into count already ordered but not yet received items?

Rishu, Niyu Labs

Yes, Odoo should normally consider incoming quantities, but the key is *when* those incoming quantities are expected compared with the demand / visibility window.

In your example:

- On hand: 7

- Incoming PO: 30

- Min: 15

- Max: 45

- Delivery lead time: 75 days

The first thing I would check is the forecast view date line, not only the total incoming quantity. If the 30 pcs are expected later than the replenishment need date, Odoo may still see a shortage inside the replenishment window and create another RFQ.

Check these points:

1. Open the product forecast report and look at the timeline.

Do not only check the final total. Check the dates of:

- outgoing demand

- incoming PO

- generated RFQ / replenishment proposal

2. Check the reordering rule’s visibility days.

If Odoo is looking far enough ahead to see demand but the incoming PO arrives too late, it may propose more stock.

3. Check vendor lead time.

With a 75-day lead time, Odoo may be planning earlier than expected because it is trying to cover future demand before the next receipt date.

4. Check if the RFQ quantity is being rounded by:

- vendor minimum quantity

- packaging

- multiple quantity

- UoM conversion

5. Confirm whether there are sales/manufacturing needs beyond what is visible in the screenshot.

Reordering rules calculate from forecasted quantity, not only current on-hand stock.

The practical test: in the forecast report, compare the shortage date with the expected receipt date of the 30 pcs. If the receipt comes after the shortage date, Odoo is not “ignoring” the PO — it is treating it as too late.

We work on Odoo replenishment/forecasting at Niyu Labs, and this is exactly the kind of case where the timeline matters more than the final quantity number. If you share the forecast report timeline, the answer should be clear pretty quickly.

Не оставайтесь в стороне – присоединяйтесь к обсуждению!

Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!

Регистрация

Похожие посты	Ответы	Просмотры
how to set the whole form view to readonly based on state of the form purchase_order	3 апр. 26	1778
Bundle POs per vendor Решено purchase_order	2 апр. 26	1495
Purchase orders not directly added to Quantity on hand in Inventory Решено purchase_order	2 мар. 26	1494
Odoo 17 one2many lines issue 17	3 июн. 25	4642
Change resume view Решено 17	4 июл. 25	2755

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!