[trunk] Inventory analysis displays lines with quantity is zero

Bug #691534 reported by Quentin THEURET @Amaris on 2010-12-17
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Won't Fix
OpenERP Community Backports (Addons)
Status tracked in 7.0

Bug Description

Revno 4028

On Inventory analysis, tree view displays lines with Quantity = 0.

To reproduce this bug :

On installation with demo data, create a new 'Internal move' with one line :
Product : [RAM] DDR 256MB PC400
Quantity : 39.00
Source Location : Shelf 1
Destination Location : Shelf 2

and process it.

Then, open Inventory analysis and check 'Group By' in this order : Location / Product. Open the Shelf 1 line, then search the product [RAM] DDR 256MB PC400. The displaying line is a line with 0 in quantity row.

Is it normal or is it a displaying bug ? IMHO, it's a displaying bug, we wan't see the product which are not present in stock.

Related branches

Changed in openobject-addons:
status: New → Opinion
Changed in openobject-addons:
status: Opinion → Confirmed
Numérigraphe (numerigraphe) wrote :

Yes, this is a poor display - not quite a but but it certainly should be improved.
The problem lies in the way the values are collected: OpenERP searches for all products that have been in the location by grouping stock moves by product.
Because of this, 0 quantities cannot be filtered easily: to achieve this, we would need to be able to filter results AFTER they have been grouped. In Postgres, that would translate by a 'having' clause.
We have made a proposal to add such a feature: please go ahead and review it here: https://code.launchpad.net/~numerigraphe/openobject-server/trunk-read_group-having/+merge/104579
The server, addons and client all have to be patched.
Lionel Sausin.

Numérigraphe (numerigraphe) wrote :

Can someone please mark this as "wishlist"?

Amit Parik (amit-parik) on 2012-06-18
Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 2 (openerp-dev-addons2)
importance: Undecided → Wishlist
Changed in openobject-addons:
status: Confirmed → Won't Fix
Numérigraphe (numerigraphe) wrote :

In v7.0 it is possible to filter grouped rows, so the fix becomes simple.
I pushed a branch to add 3 filters to the inventory analysis : available products, products out of stock, the products with negative stock
The branch targets v7.0 and currently merges cleanly in the trunk.

Changed in openobject-addons:
assignee: OpenERP R&D Addons Team 2 (openerp-dev-addons2) → nobody
Changed in ocb-addons:
assignee: nobody → Lionel Sausin - Numérigraphe (lionel-sausin)
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers