Allow to filter out locations/products where quantity is zero

[Ferdinand]

specially internal and outgoing moves
.
select a product
select from location - it shows all available locations
IMHO to be user friendly it should
first show
* only stock location with qty > 0 (one of my installations has >60 internal locations, most of them stock only a few or one product)
* only on request all locations (release "only locations with qty button")

currently there is no check if the qty is available on this location and the system allows quietly to create negative quantities.

(IMHO in V5 there was a check on process/validate ?)

In the same way, it is interesting:
- in locations, to only show the products that actually are in a location when we press "products"
- in products, to only show the locations where the product really is when we press "stock by location"
- etc.

[Vinay Rana (OpenERP) (vra-openerp)]

Hello Dr. Ferdinand,

I think this is really a good suggestion so we will plan to implement this issue in 6.0 or in next version.

Thanks.

[Olivier Dony (Odoo) (odo-openerp)]

BTW be careful that demo product data in v6 is (at least partially) set to "Consumable" type at the moment, not "Stockable", which will never trigger a stock level error and will quietly go to negative (that's the whole point of Consumable products for which you don't track stock level precisely or at all)

[Ferdinand (office-chricar)]

@Oliver
Thanks for pointing out - I was alread ywondering why no checks were made

Suggestion
update to "stockable" if module stock gets installed

[Ferdinand (office-chricar)]

you may find a module here
http://bazaar.launchpad.net/~c2c/c2c-rd-addons/trunk/files/head:/stock_product_zero/

[Numérigraphe (numerigraphe)]

Dear Ferdinand,
Thanks for sharing this link.
We're working on an alternative implementation: we've implemented the fnct_search() methods for the stock fields, and we're adding filter buttons to the search views. I'll make a merge proposal as soon as possible so you can test and review it.
Lionel.

[Numérigraphe (numerigraphe)]

I'm attaching a branch under development (based off v6.0): it does not yet completely fix this bug, but provides the infrastructure for it.
Philippe and I won't work on it for at least a few weeks, but then we intend to make a proper merge proposal in the trunk.
Please feel free to comment here now.
Lionel.

[René Glauser (rene-glauser)]

Hello
What is the actual state concerning this point? I am evaluation trunk-version of Openerp7 and have the same problems described above. Are there any news?
René

[Numérigraphe (numerigraphe)]

Our proposal was rejected.
No reason was given, but Olivier thinks a simpler way can be found that would not require client-side changes.
Also, our proposal only fixed the GTK client and it's being phased out.
So we're back to square one.
Lionel