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.
** Branch linked: lp:~numerigraphe/openobject-addons/trunk-stock- analysis-filter-zero -- You received this bug notification because you are a member of OpenERP Indian Team, which is subscribed to OpenERP Addons. https://bugs.launchpad.net/bugs/691534 Title: [trunk] Inventory analysis displays lines with quantity is zero Status in OpenERP Addons (modules): Confirmed 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. To manage notifications about this bug go to: https://bugs.launchpad.net/openobject-addons/+bug/691534/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
