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.
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.
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.
dear Matt Strowbridge
def _lines_get(self, partner):
|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.|
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
|Asked: 9/23/16, 8:06 AM|
|Seen: 188 times|
|Last updated: 9/26/16, 8:46 AM|