Hello,
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!
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello,
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!
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.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up