Odoo Addons (MOVED TO GITHUB)

Merge lp:~openerp-dev/openobject-addons/6.0-opw-575851-ado into lp:openobject-addons/6.0

  1. 6.0-opw-575851-ado
  2. Merge into 6.0
Proposed by Amit Dodiya (OpenERP)
Status: Needs review
Proposed branch: lp:~openerp-dev/openobject-addons/6.0-opw-575851-ado
Merge into: lp:openobject-addons/6.0
Diff against target: 11 lines (+1/-0)
1 file modified
sale/report/sale_report.py (+1/-0)
To merge this branch: bzr merge lp:~openerp-dev/openobject-addons/6.0-opw-575851-ado
Reviewer Review Type Date Requested Status
Olivier Dony (Odoo) Pending
Naresh(OpenERP) Pending
Review via email: mp+110757@code.launchpad.net

Description of the change

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

To post a comment you must log in.

Unmerged revisions

5258. By Amit Dodiya<email address hidden>

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

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'sale/report/sale_report.py'
2--- sale/report/sale_report.py 2012-03-13 13:01:05 +0000
3+++ sale/report/sale_report.py 2012-06-18 09:18:42 +0000
4@@ -99,6 +99,7 @@
5 left join product_template t on (p.product_tmpl_id=t.id)
6 left join product_uom u on (u.id=l.product_uom)
7 left join product_uom u2 on (u2.id=t.uom_id)
8+ where l.product_id is not null
9 group by
10 l.product_id,
11 l.product_uom_qty,