Odoo Help


Due payment report

Matt Strowbridge
on 9/23/16, 8:06 AM 1,480 views


I was wondering if everyone experiences this on due payment report and if so has anyone been able to change the output? When I run a due payment report the output seems to be in a completely random order. Is there a way to sort this report by date for instance or invoice number so that it is more comprehensible to the customer? Thank you for any insight or information you can provide on this.


Matt Strowbridge
On 9/26/16, 8:46 AM

Thank you ayman mohammed adam for your response. the file by this name was in a slightly different location and does not contain the same coding. I will look into this file and see if I can arrange a sort order within it.

Thank you also Fabrice Henrion for wanting to make a comment as well, however I am aware of the customer statement report.

My version is "Version 9.0c-20160919 (Community Edition)"

What I am referring to as the "Due Payment" report is when you open Accounting>Customers then open a particular customer at the top under the "Print" drop down next to the "Actions" drop down is "Due Payments". If you would care to comment as to why this generates a report that appears to be in a completely random order and how one might sort this into a more understandable format, please feel free to do so.

Thank you both again for your comments.


Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
| 7 7 9
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo Americas

Fabrice Henrion (fhe)
On 9/25/16, 4:30 PM

Assuming v9.0e.

I'm not sure what you mean by "Due payment report" since this is not a name that exists in Odoo. If what you want to do is send a customer statement to your customer to tell him how much he owes you, go to Accounting > Sales > Customers Statement. The customer statement is ordered by Invoice Date and displays the due date and the invoice number.

ayman mohammed adam
On 9/25/16, 3:06 AM

dear Matt Strowbridge

from addons/account/report/account_print_overdue.py


def _lines_get(self, partner):
        moveline_obj = self.pool['account.move.line']
        movelines = moveline_obj.search(self.cr, self.uid, [('partner_id', '=', partner.id), ('account_id.type', 'in', ['receivable', 'payable']), ('state', '<>', 'draft'), ('reconcile_id', '=', False)])
        movelines = moveline_obj.browse(self.cr, self.uid, movelines)
        return movelines

on the search method you can add order parameter like this :
movelines = moveline_obj.search(self.cr, self.uid, [('partner_id', '=', partner.id), ('account_id.type', 'in', ['receivable', 'payable']), ('state', '<>', 'draft'), ('reconcile_id', '=', False)],order="field1, field2 desc")
order="field1, field2 desc" on this you can add your fields in order to Sort.
I hope I helped you...

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: 9/23/16, 8:06 AM
Seen: 1480 times
Last updated: 9/26/16, 8:46 AM