openerp-dev-web team mailing list archive

["Ravi Gohil \(Open ERP\)" <rgo@xxxxxxxxxxx>]

Ravi Gohil (Open ERP) has proposed merging lp:~openerp-dev/openobject-addons/6.0-opw-5943-rgo into lp:openobject-addons/6.0.

Requested reviews:
  Anup(OpenERP) (ach-openerp)

For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/6.0-opw-5943-rgo/+merge/62608

Hello,

In purchase_report view, there was an error of "more than one row returned by a subquery used as an expression".

This issue is now fixed.

Thanks.
-- 
https://code.launchpad.net/~openerp-dev/openobject-addons/6.0-opw-5943-rgo/+merge/62608
Your team OpenERP R&D Team is subscribed to branch lp:~openerp-dev/openobject-addons/6.0-opw-5943-rgo.

=== modified file 'purchase/report/purchase_report.py'
--- purchase/report/purchase_report.py	2011-01-14 00:11:01 +0000
+++ purchase/report/purchase_report.py	2011-05-27 06:41:19 +0000
@@ -93,7 +93,7 @@
                     l.product_id,
                     t.categ_id as category_id,
                     (case when u.uom_type not in ('reference') then
-                            (select id from product_uom where uom_type='reference' and category_id = 1)
+                            (select id from product_uom where uom_type='reference' and category_id = u.category_id and active LIMIT 1)
                     else
                         u.id
                     end) as product_uom,