Odoo Help


[OpenERP 7] New "Payment date" column in the "Customer invoices" view

on 6/9/15, 5:21 AM 539 views


I would like to add a new "Payment date" column in the "Customer invoices" report. I am using OpenERP 7.

Could you please let me know how I could do that?

Many thanks and best regards!

Tom Pickering
On 7/28/15, 6:53 AM

Hi Peio,

This should get you part-way there; credativ have recently produced a module called account_invoice_date_paid which records the date and time at which invoices become paid in a new field called 'Date Paid', and displays this next to the 'Due Date' in the invoice form view. At present, it does not include a column in the PDF report, but it provides the groundwork for this and the field can be included in a CSV export. The module can be obtained from here: https://github.com/credativUK/credativ-addons/tree/addons-7.0

Most PDF reports in OpenERP version 7 are written in an XML-derived language called RML. Unfortunately, there is no easy / non-technical way to customise these reports, but the ideal way to do this would be to create a new small module which depends on account_invoice_date_paid and replaces the invoice report RML file with a new one, which would be a copy of the original with the new column incorporated (the field can be referenced using "[[ (o.date_paid) ]]"). Please refer to the OpenERP documentation for further details; we apologise that we cannot provide a more comprehensive answer here, however we hope that this puts you on the right track.

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 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

1 follower(s)


Asked: 6/9/15, 5:21 AM
Seen: 539 times
Last updated: 7/28/15, 6:57 AM