Odoo Help


error when clicking confirm bank statement

on 10/20/13, 9:21 PM 1,967 views


I'm trying to confirm my bank statement, but each time I get the error below.

Any thoughts on what might be causing this error?



OpenERP Server Error Client Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\web\http.py", line 204, in dispatch File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\web\controllers\main.py", line 1129, in call_button File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\web\controllers\main.py", line 1117, in _call_kw File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\web\session.py", line 42, in proxy File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\web\session.py", line 30, in proxy_method File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\web\session.py", line 103, in send

Server Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\web\session.py", line 89, in send File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\netsvc.py", line 292, in dispatch_rpc File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\service\web_services.py", line 626, in dispatch File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\osv\osv.py", line 188, in execute_kw File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\osv\osv.py", line 131, in wrapper File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\osv\osv.py", line 197, in execute File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\osv\osv.py", line 185, in execute_cr File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\account_voucher\account_voucher.py", line 1603, in button_confirm_bank File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\account\account_bank_statement.py", line 428, in button_confirm_bank File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\account_voucher\account_voucher.py", line 1625, in create_move_from_st_line File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\workflow\wkf_service.py", line 119, in trg_validate File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\workflow\instance.py", line 43, in validate File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\workflow\workitem.py", line 60, in process File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\workflow\workitem.py", line 175, in _split_test File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\workflow\workitem.py", line 183, in _join_test File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\workflow\workitem.py", line 40, in create File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\workflow\workitem.py", line 52, in process File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\workflow\workitem.py", line 106, in _execute File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\workflow\wkf_expr.py", line 67, in execute File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\workflow\wkf_expr.py", line 57, in _eval_expr File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\tools\safe_eval.py", line 241, in safe_eval File "", line 1, in <module> File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\osv\orm.py", line 374, in function_proxy File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\account_voucher\account_voucher.py", line 934, in proforma_voucher File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\account_voucher\account_voucher.py", line 1409, in action_move_line_create File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server\openerp\addons\account\account_move_line.py", line 1142, in create File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\osv\orm.py", line 3604, in read File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\osv\orm.py", line 3656, in _read_flat File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\sql_db.py", line 161, in wrapper File "C:\Program Files (x86)\OpenERP 7.0-20130615-231352\Server\server.\openerp\sql_db.py", line 226, in execute ProgrammingError: operator does not exist: integer = boolean LINE 1: ...d FROM "account_account" WHERE account_account.id IN (false)... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.


Serpent Consulting Services Pvt. Ltd.

--Serpent Consulting Services Pvt. Ltd.--
| 6 6 8
Gandhinagar, India
--Serpent Consulting Services Pvt. Ltd.--

Serpent Consulting Services Pvt. Ltd. Your Odoo/OpenERP Solution, just an email away!

Serpent Consulting Services Pvt. Ltd.
On 10/22/13, 7:10 AM


This is possible when you did not specify accounts for cash/bank journal.


About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 10/20/13, 9:21 PM
Seen: 1967 times
Last updated: 3/16/15, 8:10 AM