Mình vào Kế toán/Cấu hình/Tài khoản/In sổ cái.
Nếu không chọn năm tài chính (mục đích để in tất cả các bút toán của các năm) thì thấy báo lỗi, nếu chọn năm thì in được bình thường. Đây có phải lỗi không ạ.
Odoo
Odoo Server Error
Traceback (most recent call last):
File "/home/nmytz6hzufgbjkekmcvk7pxt7olcifj1/addons/report/controllers/main.py", line 125, in report_download
response = self.report_routes(reportname, converter='pdf', **dict(data))
File "/opt/openerp/80/openerp/http.py", line 396, in response_wrap
response = f(*args, **kw)
File "/home/nmytz6hzufgbjkekmcvk7pxt7olcifj1/addons/report/controllers/main.py", line 65, in report_routes
pdf = report_obj.get_pdf(cr, uid, docids, reportname, data=options_data, context=context)
File "/opt/openerp/80/openerp/api.py", line 241, in wrapper
return old_api(self, *args, **kwargs)
File "/home/nmytz6hzufgbjkekmcvk7pxt7olcifj1/addons/report/models/report.py", line 190, in get_pdf
html = self.get_html(cr, uid, ids, report_name, data=data, context=context)
File "/opt/openerp/80/openerp/api.py", line 241, in wrapper
return old_api(self, *args, **kwargs)
File "/home/nmytz6hzufgbjkekmcvk7pxt7olcifj1/addons/report/models/report.py", line 165, in get_html
return particularreport_obj.render_html(cr, uid, ids, data=data, context=context)
File "/opt/openerp/80/openerp/api.py", line 241, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/openerp/80/openerp/api.py", line 363, in old_api
result = method(recs, *args, **kwargs)
File "/home/nmytz6hzufgbjkekmcvk7pxt7olcifj1/tvtmaaddons/to_vn_legal_financial_reports/report/general_ledger.py", line 41, in render_html
return report_obj.render('to_vn_legal_financial_reports.report_generalledger', docargs)
File "/opt/openerp/80/openerp/api.py", line 239, in wrapper
return new_api(self, *args, **kwargs)
File "/opt/openerp/80/openerp/api.py", line 546, in new_api
result = method(self._model, cr, uid, self.ids, *args, **kwargs)
File "/home/nmytz6hzufgbjkekmcvk7pxt7olcifj1/addons/website_report/report.py", line 47, in render
return super(Report, self).render(cr, uid, ids, template, values=values, context=context)
File "/opt/openerp/80/openerp/api.py", line 241, in wrapper
return old_api(self, *args, **kwargs)
File "/home/nmytz6hzufgbjkekmcvk7pxt7olcifj1/addons/report/models/report.py", line 151, in render
return view_obj.render(cr, uid, template, values, context=context)
File "/opt/openerp/80/openerp/api.py", line 241, in wrapper
return old_api(self, *args, **kwargs)
File "/home/nmytz6hzufgbjkekmcvk7pxt7olcifj1/addons/website/models/ir_ui_view.py", line 172, in render
return super(view, self).render(cr, uid, id_or_xml_id, values=values, engine=engine, context=context)
File "/opt/openerp/80/openerp/api.py", line 241, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/openerp/80/openerp/addons/base/ir/ir_ui_view.py", line 1029, in render
return self.pool[engine].render(cr, uid, id_or_xml_id, qcontext, loader=loader, context=context)
File "/opt/openerp/80/openerp/api.py", line 241, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 259, in render
return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
g_inner.append(self.render_node(current_node, qwebcontext))
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node
result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 434, in render_tag_call
d[0] = self.render_element(element, template_attributes, generated_attributes, d)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
g_inner.append(self.render_node(current_node, qwebcontext))
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node
result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 420, in render_tag_foreach
ru.append(self.render_element(element, template_attributes, generated_attributes, copy_qwebcontext))
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
g_inner.append(self.render_node(current_node, qwebcontext))
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
g_inner.append(self.render_node(current_node, qwebcontext))
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
g_inner.append(self.render_node(current_node, qwebcontext))
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
g_inner.append(self.render_node(current_node, qwebcontext))
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
g_inner.append(self.render_node(current_node, qwebcontext))
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node
result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 428, in render_tag_if
if self.eval_bool(template_attributes["if"], qwebcontext):
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 234, in eval_bool
return int(bool(self.eval(expr, qwebcontext)))
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 203, in eval
raise_qweb_exception(message="Could not evaluate expression %r" % expr, expression=expr, template=template)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 200, in eval
return qwebcontext.safe_eval(expr)
File "/opt/openerp/80/openerp/addons/base/ir/ir_qweb.py", line 86, in safe_eval
return eval(expr, None, locals_dict, nocopy=True, locals_builtins=True)
File "/opt/openerp/80/openerp/tools/safe_eval.py", line 314, in safe_eval
return eval(c, globals_dict, locals_dict)
File "", line 1, in
File "/opt/openerp/80/openerp/api.py", line 239, in wrapper
return new_api(self, *args, **kwargs)
File "/home/nmytz6hzufgbjkekmcvk7pxt7olcifj1/tvtmaaddons/to_vn_legal_financial_reports/models/account.py", line 1703, in get_report_opening_balance
value += self._report_opening_balance(item, data)
File "/opt/openerp/80/openerp/api.py", line 239, in wrapper
return new_api(self, *args, **kwargs)
File "/home/nmytz6hzufgbjkekmcvk7pxt7olcifj1/tvtmaaddons/to_vn_legal_financial_reports/models/account.py", line 1654, in _report_opening_balance
self._cr.execute(sql, (account.id, tuple(move_state), fiscalyear_clause))
File "/opt/openerp/80/openerp/sql_db.py", line 158, in wrapper
return f(self, *args, **kwargs)
File "/opt/openerp/80/openerp/sql_db.py", line 234, in execute
res = self._obj.execute(query, params)
QWebException: "invalid input syntax for integer: "account.fiscalyear(1,),account.fiscalyear(2,)"
LINE 9: AND (p.fiscalyear_id IN ('account.fiscal…
^
" while evaluating
'o.get_report_opening_balance(data) == 0'
