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?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
1
Reply
4584
Views
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?
Should I report a bug?
You can use "Reordering Rules" and set minimum levels (can be 0). Run the scheduler to create a draft purchase order.
