Odoo Help


Advanced product search for Forecasted quantity doesn't really filter. Or am I doing it wrong?

Shahar Or
on 4/16/13, 1:50 PM 2,201 views

I try to have a list of all products which have a forecasted quantity less than 0. Here's a screen shot: snag.gy/bVprz.jpg Any ideas?


Sudhir Arya (ERP Harbor Consulting Services)

--Sudhir Arya (ERP Harbor Consulting Services)--
| 6 8 8
Ahmedabad, India
--Sudhir Arya (ERP Harbor Consulting Services)--

• Co-Founder & Co-Owner at ERP Harbor Consulting Services

• ERP Consultant / ERP Customization / TechnoFunctional Expert

• Sound knowledge in Python, Odoo (Open ERP), XML, PostgreSQL

• Domain knowledge of Sale Management, Purchase Management, Warehouse Management, Manufacturing, Multi Company Configuration & Management, HR Management, Medical Management, Construction Management, Education Management, Point of Sale, Third Party Integrations

• Positive attitude and quick Learner

• Good analytical skill, quick bug and issue tracing and find the solution

• Good knowledge and experience in payment gateway integration with Odoo

• Ready to accept new challenges

• Active Memeber On Stackoverflow 




Sudhir Arya
ERP Harbor Consulting Services
Sudhir Arya (ERP Harbor Consulting Services)
On 4/17/13, 2:56 AM

It is because Forecasted Quantity field is a function field and not stored in database.

If you are using ubuntu then look at your terminal you will see Error in background like this:

openerp.osv.expression: The field 'Forecasted Quantity' (virtual_available) can not be searched: non-stored function field without fnct_search

Thanks, Sudhir. So, how can I have a list of products which I need to order because I'm out of stock, please?

Shahar Or
on 4/18/13, 7:58 AM

Should I report a bug?

Shahar Or
on 4/18/13, 3:36 PM

You can use "Reordering Rules" and set minimum levels (can be 0). Run the scheduler to create a draft purchase order.

on 8/8/13, 1:07 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 4/16/13, 1:50 PM
Seen: 2201 times
Last updated: 3/16/15, 8:10 AM