[trunk] Inventory analysis displays lines with quantity is zero

Bug #691534 reported by Quentin THEURET @Amaris on 2010-12-17
16
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Won't Fix
Wishlist
Unassigned
OpenERP Community Backports (Addons)
Status tracked in 7.0
7.0
Wishlist
Numérigraphe

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"?
Lionel.

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.
Lionel.

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