Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Converting Purchase to invoice + DataError: invalid input syntax for type date: "False"

By
Gratien HOUNDAKO
on 7/31/15, 8:42 AM 310 views

I'm Using OPEN ERP 7, on ubuntu server 14.04

when i try to convert a purchase order into invoice,I have DataError Invalid input syntax for type date

any ideas to resolve the probleme

Thanks


Server Traceback (most recent call last):

File "/opt/openerp/server/openerp/addons/web/session.py", line 89, in send

return openerp.netsvc.dispatch_rpc(service_name, method, args)

File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc

result = ExportService.getService(service_name).dispatch(method, params)

File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch

res = fn(db, uid, *params)

File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw

return self.execute(db, uid, obj, method, *args, **kw or {})

File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper

return f(self, dbname, *args, **kwargs)

File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute

res = self.execute_cr(cr, uid, obj, method, *args, **kw)

File "/opt/openerp/server/openerp/addons/audittrail/audittrail.py", line 514, in execute_cr

return fct_src(cr, uid, model, method, *args, **kw)

File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr

return getattr(object, method)(cr, uid, *args, **kw)

File "/opt/openerp/server/openerp/osv/orm.py", line 3620, in read

result = self._read_flat(cr, user, select, fields, context, load)

File "/opt/openerp/server/openerp/osv/orm.py", line 3741, in _read_flat

res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)

File "/opt/openerp/server/openerp/osv/fields.py", line 1141, in get

result = self._fnct(obj, cr, uid, ids, name, self._arg, context)

File "/opt/openerp/server/openerp/addons/invoice_print_report_balance_payment/account_invoice.py", line 59, in _to_pay_get

context=context

File "/opt/openerp/server/openerp/addons/invoice_print_report_balance_payment/partner.py", line 44, in get_balance_at_date

cr.execute(sql)

File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper

return f(self, *args, **kwargs)

File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute

res = self._obj.execute(query, params)

DataError: invalid input syntax for type date: "False"

LINE 7: AND m.date <= 'False'

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/31/15, 8:42 AM
Seen: 310 times
Last updated: 7/31/15, 8:42 AM