openerp-wms-expert team mailing list archive

[Numérigraphe <691534@xxxxxxxxxxxxxxxxxx>]

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
WMS Expert, which is subscribed to the bug report.
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