I need to add the invoice due date to the Partner Ledger Report (v11)

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

I need to add the invoice due date to the Partner Ledger Report (v11)

4 Replies

3726 Views

partner invoice duedate ledger maturity

Cameron Wolfe

Here is the code I am using for the table inside the Partner Ledger that I need the invoice due date on. The underlined section is what I was trying to use to get the due date but I am getting back an error. Can anyone help with the correct attribute?

</td>

</td>

</td>

</td>

</td>

</td>

</td>

</t>

</td>

</tr>

</tbody>

Nikhil Krishnan

Can you please check "lines(data, o)" function. or publish here.

Ray Carnes (ray)

Best Answer

Do you really have it formatted this way:

<span t-esc="line['date_maturity'}"/>

The opening and closing brackets are different.

Cameron Wolfe

Author

Ray,
Thanks for spotting that typo, but it still doesn't solve the issue. This is the error I receive:

Traceback (most recent call last):
  File "/home/odoo/src/odoo/11.0/odoo/addons/base/ir/ir_qweb/qweb.py", line 342, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_848_9985
  File "<template>", line 2, in body_call_content_9984
  File "<template>", line 6, in foreach_9983
  File "<template>", line 7, in body_call_content_9982
  File "<template>", line 50, in foreach_9968
KeyError: 'date_maturity'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/odoo/src/odoo/11.0/addons/web/controllers/main.py", line 1624, in report_download
    response = self.report_routes(reportname, converter='pdf', **dict(data))
  File "/home/odoo/src/odoo/11.0/odoo/http.py", line 515, in response_wrap
    response = f(*args, **kw)
  File "/home/odoo/src/odoo/11.0/addons/web/controllers/main.py", line 1569, in report_routes
    pdf = report.with_context(context).render_qweb_pdf(docids, data=data)[0]
  File "/home/odoo/src/odoo/11.0/odoo/addons/base/ir/ir_actions_report.py", line 628, in render_qweb_pdf
    html = self.with_context(context).render_qweb_html(res_ids, data=data)[0]
  File "/home/odoo/src/enterprise/11.0/web_studio/models/report.py", line 17, in render_qweb_html
    return super(Report, self).render_qweb_html(docids, data)
  File "/home/odoo/src/odoo/11.0/odoo/addons/base/ir/ir_actions_report.py", line 666, in render_qweb_html
    return self.render_template(self.report_name, data), 'html'
  File "/home/odoo/src/odoo/11.0/odoo/addons/base/ir/ir_actions_report.py", line 470, in render_template
    return view_obj.render_template(template, values)
  File "/home/odoo/src/odoo/11.0/odoo/addons/base/ir/ir_ui_view.py", line 1195, in render_template
    return self.browse(self.get_view_id(template)).render(values, engine)
  File "/home/odoo/src/odoo/11.0/addons/website/models/ir_ui_view.py", line 113, in render
    return super(View, self).render(values, engine=engine)
  File "/home/odoo/src/odoo/11.0/addons/web_editor/models/ir_ui_view.py", line 27, in render
    return super(IrUiView, self).render(values=values, engine=engine)
  File "/home/odoo/src/odoo/11.0/odoo/addons/base/ir/ir_ui_view.py", line 1204, in render
    return self.env[engine].render(self.id, qcontext)
  File "/home/odoo/src/odoo/11.0/odoo/addons/base/ir/ir_qweb/ir_qweb.py", line 57, in render
    return super(IrQWeb, self).render(id_or_xml_id, values=values, **context)
  File "/home/odoo/src/odoo/11.0/odoo/addons/base/ir/ir_qweb/qweb.py", line 271, in render
    self.compile(template, options)(self, body.append, values or {})
  File "/home/odoo/src/odoo/11.0/odoo/addons/base/ir/ir_qweb/qweb.py", line 349, in _compiled_fn
    raise QWebException("Error to render compiling AST", e, path, node and etree.tostring(node[0], encoding='unicode'), name)
odoo.addons.base.ir.ir_qweb.qweb.QWebException: 'date_maturity'
Traceback (most recent call last):
  File "/home/odoo/src/odoo/11.0/odoo/addons/base/ir/ir_qweb/qweb.py", line 342, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_848_9985
  File "<template>", line 2, in body_call_content_9984
  File "<template>", line 6, in foreach_9983
  File "<template>", line 7, in body_call_content_9982
  File "<template>", line 50, in foreach_9968
KeyError: 'date_maturity'

Error to render compiling AST
KeyError: 'date_maturity'
Template: 848
Path: /templates/t/t/t[4]/t/div[1]/table/tbody/tr/td[2]/span
Node: <span t-esc="line['date_maturity']"/>

Megha Patel

cameron,

Close the bracket in proper format.

<span t-esc="line['date_maturity']"/>

This question has been flagged