[trunk] Inventory analysis displays lines with quantity is zero
Bug #691534 reported by
Quentin THEURET @Amaris
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 |
Fix Committed
|
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
lp:~numerigraphe/openobject-server/trunk-read_group-having
- OpenERP Framework Experts: Pending requested
- OpenERP Core Team: Pending requested
-
Diff: 41 lines (+14/-3)1 file modifiedopenerp/osv/orm.py (+14/-3)
lp:~numerigraphe-team/ocb-addons/7.0-filter-zero-inventory-analysis
- Raphaël Valyi - http://www.akretion.com: Needs Information
- Alexandre Fayolle - camptocamp: Needs Fixing
- Holger Brunn (Therp): Approve (code review)
-
Diff: 24 lines (+5/-2)1 file modifiedstock/report/report_stock_move_view.xml (+5/-2)
| Changed in openobject-addons: | |
| status: | New → Opinion |
| Changed in openobject-addons: | |
| status: | Opinion → Confirmed |
Revision history for this message
| Numérigraphe (numerigraphe) wrote | #1 |
Revision history for this message
| Numérigraphe (numerigraphe) wrote | #2 |
| 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 |
Revision history for this message
| Numérigraphe (numerigraphe) wrote | #3 |
| 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.
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:/
The server, addons and client all have to be patched.
Lionel Sausin.