Odoo Addons (MOVED TO GITHUB)

  1. Bug #810934
  2. Activity log

Activity log for bug #810934

Date Who What changed Old value New value Message
2011-07-15 08:36:16 Jordi Esteve (www.zikzakmedia.com) bug added bug
2011-07-21 11:09:46 Amit Parik openobject-addons: importance Undecided Low
2011-07-21 11:09:46 Amit Parik openobject-addons: status New Confirmed
2011-07-21 11:09:46 Amit Parik openobject-addons: assignee OpenERP R&D Addons Team 2 (openerp-dev-addons2)
2011-07-21 13:11:00 Atik Agewan(OpenERP) openobject-addons: status Confirmed In Progress
2011-07-22 11:38:29 Launchpad Janitor branch linked lp:~openerp-dev/openobject-addons/trunk-bug-810934-aag
2011-07-22 11:46:11 Atik Agewan(OpenERP) openobject-addons: status In Progress Fix Committed
2011-09-24 11:15:48 Fabien (Open ERP) openobject-addons: status Fix Committed Fix Released
2012-01-12 15:51:23 Evert Dausy description v 6.0.2. The Warehouse/Reporting/Inventory Analysis is wrong when you have move lines with different UoM of the same UoM category. I think the factor conversion in the related postgres view is not correctly computed. If the following 4 multiplications are changed by 4 divisions the inventory analysis works Ok: Index: report/report_stock_move.py =================================================================== --- report/report_stock_move.py (revisión: 146) +++ report/report_stock_move.py (copia de trabajo) @@ -1,4 +1,4 @@ -# -*- coding: utf-8 -*- +# -*- coding: utf-8 -*- ############################################################################## # # OpenERP, Open Source Management Solution @@ -176,8 +176,8 @@ m.product_id as product_id, pt.categ_id as product_categ_id, l.usage as location_type, m.company_id, m.state as state, m.prodlot_id as prodlot_id, - coalesce(sum(-m.product_qty * u.factor)::decimal, 0.0) as product_qty, - coalesce(sum(-pt.standard_price * m.product_qty * u.factor)::decimal, 0.0) as value + coalesce(sum(-m.product_qty / u.factor)::decimal, 0.0) as product_qty, + coalesce(sum(-pt.standard_price * m.product_qty / u.factor)::decimal, 0.0) as value FROM stock_move m LEFT JOIN stock_picking p ON (m.picking_id=p.id) @@ -195,8 +195,8 @@ m.product_id as product_id, pt.categ_id as product_categ_id, l.usage as location_type, m.company_id, m.state as state, m.prodlot_id as prodlot_id, - coalesce(sum(m.product_qty*u.factor)::decimal, 0.0) as product_qty, - coalesce(sum(pt.standard_price * m.product_qty * u.factor)::decimal, 0.0) as value + coalesce(sum(m.product_qty/u.factor)::decimal, 0.0) as product_qty, + coalesce(sum(pt.standard_price * m.product_qty / u.factor)::decimal, 0.0) as value FROM stock_move m LEFT JOIN stock_picking p ON (m.picking_id=p.id) v 6.0.2. The Warehouse/Reporting/Inventory Analysis is wrong when you have move lines with different UoM of the same UoM category. I think the factor conversion in the related postgres view is not correctly computed. If the following 4 multiplications are changed by 4 divisions the inventory analysis works Ok: Index: report/report_stock_move.py =================================================================== --- report/report_stock_move.py (revisión: 146) +++ report/report_stock_move.py (copia de trabajo) @@ -1,4 +1,4 @@ -# -*- coding: utf-8 -*- +# -*- coding: utf-8 -*-  ##############################################################################  #  # OpenERP, Open Source Management Solution @@ -176,8 +176,8 @@          m.product_id as product_id, pt.categ_id as product_categ_id, l.usage as location_type,          m.company_id,          m.state as state, m.prodlot_id as prodlot_id, - coalesce(sum(-m.product_qty * u.factor)::decimal, 0.0) as product_qty, - coalesce(sum(-pt.standard_price * m.product_qty * u.factor)::decimal, 0.0) as value + coalesce(sum(-m.product_qty / u.factor)::decimal, 0.0) as product_qty, + coalesce(sum(-pt.standard_price * m.product_qty / u.factor)::decimal, 0.0) as value      FROM          stock_move m              LEFT JOIN stock_picking p ON (m.picking_id=p.id) @@ -195,8 +195,8 @@          m.product_id as product_id, pt.categ_id as product_categ_id, l.usage as location_type,          m.company_id,          m.state as state, m.prodlot_id as prodlot_id, - coalesce(sum(m.product_qty*u.factor)::decimal, 0.0) as product_qty, - coalesce(sum(pt.standard_price * m.product_qty * u.factor)::decimal, 0.0) as value + coalesce(sum(m.product_qty/u.factor)::decimal, 0.0) as product_qty, + coalesce(sum(pt.standard_price * m.product_qty / u.factor)::decimal, 0.0) as value      FROM          stock_move m              LEFT JOIN stock_picking p ON (m.picking_id=p.id)