openerp-dev-web team mailing list archive

["Kirti Savalia\(OpenERP\)" <ksa@xxxxxxxxxxx>]

Kirti Savalia(OpenERP) has proposed merging lp:~openerp-dev/openobject-addons/trunk-bug-787373-ksa into lp:openobject-addons.

Requested reviews:
  Rucha (Open ERP) (rpa-openerp)
Related bugs:
  Bug #787373 in OpenERP Addons: "production analysis: wrong quantity calculation"
  https://bugs.launchpad.net/openobject-addons/+bug/787373

For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-787373-ksa/+merge/62658

calculate quantity on produced product instead of scheduled product.
-- 
https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-787373-ksa/+merge/62658
Your team OpenERP R&D Team is subscribed to branch lp:~openerp-dev/openobject-addons/trunk-bug-787373-ksa.

=== modified file 'mrp/report/mrp_production_order.py'
--- mrp/report/mrp_production_order.py	2011-01-14 00:11:01 +0000
+++ mrp/report/mrp_production_order.py	2011-05-27 11:57:25 +0000
@@ -79,7 +79,7 @@
                      s.product_id as product_id,
                      l.product_id as product_id2,
                      l.product_uom,
-                     sum(l.product_qty * u.factor) as product_qty,
+                     sum(s.product_qty / u.factor) as product_qty,
                      s.company_id as company_id,
                      (select 1) as nbr,
                      (select sum(sm.product_qty) from stock_move as sm
@@ -106,7 +106,7 @@
                      s.priority,
                      s.state
                  from mrp_production_product_line l
-                 left join mrp_production s on (s.id=l.production_id)
+                 left join mrp_production s on (s.id=l.id)
                  left join product_uom u on (u.id=l.product_uom)
                  group by
                      to_char(s.create_date, 'YYYY'),