Amit Dodiya (OpenERP) has proposed merging 
lp:~openerp-dev/openobject-addons/6.0-opw-575851-ado into 
lp:openobject-addons/6.0.

Requested reviews:
  Olivier Dony (OpenERP) (odo-openerp)
  Naresh(OpenERP) (nch-openerp)

For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/6.0-opw-575851-ado/+merge/110757

Hello,

"[FIX]: Group by product filter in sales analysis report gives traceback when 
we have no sale order line in any sale order"

Steps:
1). Create a sale order with no sale order line and save it.
2). Goto : Sales/Reporting/Sales Analysis Report and open it.
3). Click on Clear button and try to group by with product / Reference UOM / 
Category of Product
It gives trackback.

Regards,
Amit
-- 
https://code.launchpad.net/~openerp-dev/openobject-addons/6.0-opw-575851-ado/+merge/110757
Your team OpenERP R&D Team is subscribed to branch 
lp:~openerp-dev/openobject-addons/6.0-opw-575851-ado.
=== modified file 'sale/report/sale_report.py'
--- sale/report/sale_report.py	2012-03-13 13:01:05 +0000
+++ sale/report/sale_report.py	2012-06-18 09:18:42 +0000
@@ -99,6 +99,7 @@
                             left join product_template t on (p.product_tmpl_id=t.id)
                     left join product_uom u on (u.id=l.product_uom)
                     left join product_uom u2 on (u2.id=t.uom_id)
+                where l.product_id is not null
                 group by
                     l.product_id,
                     l.product_uom_qty,

_______________________________________________
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

Reply via email to