Kirti Savalia(OpenERP) has proposed merging
lp:~openerp-dev/openobject-addons/trunk-bug-787373-ksa into
lp:openobject-addons.
Requested reviews:
Kirti Savalia(OpenERP) (ksa-openerp)
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-06-13 07:06:57 +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
@@ -105,8 +105,8 @@
s.origin,
s.priority,
s.state
- from mrp_production_product_line l
- left join mrp_production s on (s.id=l.production_id)
+ from mrp_production s
+ left join mrp_production_product_line l on (s.id=l.id)
left join product_uom u on (u.id=l.product_uom)
group by
to_char(s.create_date, 'YYYY'),
_______________________________________________
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
