Atik Agewan(OpenERP) has proposed merging
lp:~openerp-dev/openobject-addons/trunk-bug-810934-aag into
lp:openobject-addons.
Requested reviews:
Rucha (Open ERP) (rpa-openerp)
Related bugs:
Bug #810934 in OpenERP Addons: "[6.0.2] Wrong Warehouse/Reporting/Inventory
Analysis when you have move lines with different UoM"
https://bugs.launchpad.net/openobject-addons/+bug/810934
For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-810934-aag/+merge/68826
Hello
Stock: In Warehouse/Reporting/Inventory Analysis when you have move lines with
different UoM it will
show qty in Default Uom
Thanks
--
https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-810934-aag/+merge/68826
Your team OpenERP R&D Team is subscribed to branch
lp:~openerp-dev/openobject-addons/trunk-bug-810934-aag.
=== modified file 'stock/report/report_stock_move.py'
--- stock/report/report_stock_move.py 2011-04-05 06:50:13 +0000
+++ stock/report/report_stock_move.py 2011-07-22 11:46:01 +0000
@@ -180,13 +180,13 @@
CASE when pt.uom_id = m.product_uom THEN
coalesce(sum(-m.product_qty)::decimal, 0.0)
ELSE
- coalesce(sum(-m.product_qty * pu.factor)::decimal, 0.0) END as product_qty
+ coalesce(sum(-m.product_qty / pu.factor)::decimal, 0.0) END as product_qty
FROM
stock_move m
LEFT JOIN stock_picking p ON (m.picking_id=p.id)
LEFT JOIN product_product pp ON (m.product_id=pp.id)
LEFT JOIN product_template pt ON (pp.product_tmpl_id=pt.id)
- LEFT JOIN product_uom pu ON (pt.uom_id=pu.id)
+ LEFT JOIN product_uom pu ON (m.product_uom=pu.id)
LEFT JOIN product_uom u ON (m.product_uom=u.id)
LEFT JOIN stock_location l ON (m.location_id=l.id)
GROUP BY
@@ -203,13 +203,13 @@
CASE when pt.uom_id = m.product_uom THEN
coalesce(sum(m.product_qty)::decimal, 0.0)
ELSE
- coalesce(sum(m.product_qty * pu.factor)::decimal, 0.0) END as product_qty
+ coalesce(sum(m.product_qty / pu.factor)::decimal, 0.0) END as product_qty
FROM
stock_move m
LEFT JOIN stock_picking p ON (m.picking_id=p.id)
LEFT JOIN product_product pp ON (m.product_id=pp.id)
LEFT JOIN product_template pt ON (pp.product_tmpl_id=pt.id)
- LEFT JOIN product_uom pu ON (pt.uom_id=pu.id)
+ LEFT JOIN product_uom pu ON (m.product_uom=pu.id)
LEFT JOIN product_uom u ON (m.product_uom=u.id)
LEFT JOIN stock_location l ON (m.location_dest_id=l.id)
GROUP BY
_______________________________________________
Mailing list: https://launchpad.net/~openerp-dev-gtk
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-dev-gtk
More help : https://help.launchpad.net/ListHelp
