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-5689-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-5689-rgo/+merge/61753

Hello,

Following error was being generated while opening Sale Manager Analysis.
"more than one row returned by a subquery used as an expression".

This fixes the issue,

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

=== modified file 'sale/report/sale_report.py'
--- sale/report/sale_report.py	2011-01-14 00:11:01 +0000
+++ sale/report/sale_report.py	2011-05-20 12:28:37 +0000
@@ -91,7 +91,7 @@
                     select l.id as id,
                         l.product_id as product_id,
                         (case when u.uom_type not in ('reference') then
-                            (select name from product_uom where uom_type='reference' and category_id=u.category_id)
+                            (select name from product_uom where uom_type='reference' and category_id=u.category_id and active LIMIT 1)
                         else
                             u.name
                         end) as uom_name,