Anaƫl Closson (openerp) has proposed merging 
lp:~openerp-dev/openobject-addons/6.1-opw-577225-acl into 
lp:openobject-addons/6.1.

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

For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/6.1-opw-577225-acl/+merge/116857

Bug: 
Create a sale order without order line.
Go to Sales/Reporting/Sales analysis
Check either Product, Reference UoM and/or Category of product
You get an exception.

The bug disappears if you add an order line to the sale order.

The patch avoids the exception in such case.
-- 
https://code.launchpad.net/~openerp-dev/openobject-addons/6.1-opw-577225-acl/+merge/116857
Your team OpenERP R&D Team is subscribed to branch 
lp:~openerp-dev/openobject-addons/6.1-opw-577225-acl.
=== modified file 'sale/report/sale_report.py'
--- sale/report/sale_report.py	2011-12-19 16:54:40 +0000
+++ sale/report/sale_report.py	2012-07-26 13:11:07 +0000
@@ -92,7 +92,7 @@
                     s.project_id as analytic_account_id
                 from
                     sale_order s
-                    left join sale_order_line l on (s.id=l.order_id)
+                    inner join sale_order_line l on (s.id=l.order_id)
                         left join product_product p on (l.product_id=p.id)
                             left join product_template t on (p.product_tmpl_id=t.id)
                     left join product_uom u on (u.id=l.product_uom)

_______________________________________________
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