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

All Posts People Badges

Tags (View all)

odoo accounting v14 pos v15

About this forum

Help

Reordering rules orders too much?

purchase_order reordering-rules 17

1 Reply

1681 Views

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.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
how to set the whole form view to readonly based on state of the form purchase_order	3 Apr 26	1743
Bundle POs per vendor Solved purchase_order	2 Apr 26	1419
Purchase orders not directly added to Quantity on hand in Inventory Solved purchase_order	2 Mar 26	1444
Odoo 17 one2many lines issue 17	3 Jun 25	4597
Change resume view Solved 17	4 Jul 25	2735

This question has been flagged

Enjoying the discussion? Don't just read, join in!