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 회신

1739 화면

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 4월 26	1836
Bundle POs per vendor 해결 완료 purchase_order	2 4월 26	1550
Purchase orders not directly added to Quantity on hand in Inventory 해결 완료 purchase_order	2 3월 26	1531
Odoo 17 one2many lines issue 17	3 6월 25	4666
Change resume view 해결 완료 17	4 7월 25	2768

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!