Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
3 Odpowiedzi
6262 Widoki
Awatar
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

Awatar
Odrzuć
Awatar
Matt Strowbridge
Autor Najlepsza odpowiedź

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.

Awatar
Odrzuć
Awatar
Fabrice Henrion (fhe)
Najlepsza odpowiedź

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.


Awatar
Odrzuć
Awatar
ayman mohammed adam
Najlepsza odpowiedź

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

Awatar
Odrzuć