[7.0]filter problem on the quantity product

[Guy BREVART]

version : 7

with the view list of product if we try to filter all product by quantity, the result does not match the expected result.
(for exemple i filter the product with quantity = 0, the view display all products)

[Guy BREVART (gbt-z)]

up!

[Briehan Lombaard (briehan-lombaard)]

Hi there,

I got it working by changing the field definitions for quantity available and quantity on hand in the product module. The values were not being stored in the database. Adding the stored=True parameter to the fields fixed the issue. The same would have to be done for the stock module to fix the issue in there as well.

[Andrianto Kurniawan (andrix21)]

@Briehan Lombaard
It was an BAD IDEA to store value of qty_available in product_product. Cause in openerp, table product_product used in multi-location and multi-company structure. So qty_available could not be stored, it depends on location value and company value in filter context.

[Briehan Lombaard (briehan-lombaard)]

Thanks Andrianto,

I thought there might be an issue with storing the value.