Hemendra Paregi(Open ERP) has proposed merging
lp:~openerp-dev/openobject-addons/6.1-opw-575782-hpa into
lp:openobject-addons/6.1.
Requested reviews:
Naresh(OpenERP) (nch-openerp)
For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/6.1-opw-575782-hpa/+merge/109820
Hello
If I create a Sale Order with no sale order lines and try to open the
view at Sales/Reporting/Sales Analysis I get an error.
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...report.id FROM "sale_report" WHERE sale_report.id IN (false,...
^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
This fix would solve the issue.
Thanks
--
https://code.launchpad.net/~openerp-dev/openobject-addons/6.1-opw-575782-hpa/+merge/109820
Your team OpenERP R&D Team is subscribed to branch
lp:~openerp-dev/openobject-addons/6.1-opw-575782-hpa.
=== 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-06-12 11:59:22 +0000
@@ -97,6 +97,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.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
