Odoo Help

Welcome!

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

0

Due payment report

By
Matt Strowbridge
on 9/23/16, 8:06 AM 194 views

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

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

0

Fabrice Henrion (fhe)

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

Director Odoo USA

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.


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

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

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 9/23/16, 8:06 AM
Seen: 194 times
Last updated: 9/26/16, 8:46 AM