Skip to Content
This question has been flagged
3 Replies
5505 Views
Avatar
Matt Strowbridge

Hello,

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

Avatar
Discard
Avatar
Matt Strowbridge
Author Best Answer

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.

Avatar
Discard
Avatar
Fabrice Henrion (fhe)
Best Answer

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.


Avatar
Discard
Avatar
ayman mohammed adam
Best Answer

dear Matt Strowbridge

from addons/account/report/account_print_overdue.py

on 

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

Avatar
Discard