** Description changed: 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 + ############################################################################## + # + # 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, + 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) + 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, + 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) + FROM + stock_move m + LEFT JOIN stock_picking p ON (m.picking_id=p.id)
-- You received this bug notification because you are a member of OpenERP Framework Experts, which is subscribed to OpenERP Addons. https://bugs.launchpad.net/bugs/810934 Title: [6.0.2] Wrong Warehouse/Reporting/Inventory Analysis when you have move lines with different UoM Status in OpenERP Addons (modules): Fix Released Bug 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) To manage notifications about this bug go to: https://bugs.launchpad.net/openobject-addons/+bug/810934/+subscriptions -- Mailing list: https://launchpad.net/~credativ Post to : [email protected] Unsubscribe : https://launchpad.net/~credativ More help : https://help.launchpad.net/ListHelp
