summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDivyesh Makwana (Open ERP) <mdi@tinyerp.com>2012-03-12 15:34:29 +0530
committerDivyesh Makwana (Open ERP) <mdi@tinyerp.com>2012-03-12 15:34:29 +0530
commitd930f23ece879bca7480caee2ec6fb372c2bf48b (patch)
treee4c63cc46b20c0ae104a49f4fbe56604b2772b2b
parentabfa7ea5559caa2ecf224cc27cf5b80ea616ceee (diff)
[FIX] sale : 6.1RC1 report Sales Analysis bug
lp bug: https://launchpad.net/bugs/938866 fixed bzr revid: mdi@tinyerp.com-20120312100429-a718zljp31bs7tv3
-rw-r--r--addons/sale/report/sale_report.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/addons/sale/report/sale_report.py b/addons/sale/report/sale_report.py
index 42e090d54e5..23ce41f7d58 100644
--- a/addons/sale/report/sale_report.py
+++ b/addons/sale/report/sale_report.py
@@ -97,6 +97,7 @@ class sale_report(osv.osv):
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,