diff options
| author | Denis Ledoux <dle@odoo.com> | 2014-12-11 11:44:52 +0100 |
|---|---|---|
| committer | Denis Ledoux <dle@odoo.com> | 2014-12-11 11:44:52 +0100 |
| commit | db98434e85be8ae0dfdb580a263704e3bac454e2 (patch) | |
| tree | 5170691720fae571c0c725b0bf2ac3a2b4827f0f /addons | |
| parent | b035cfb7e9df10dcdcfdf371946aa77057e5393c (diff) | |
[FIX] account_aged_partner_balance: accurate total
In some cases when the move was partially reconciled, the amount of the move wasn't added to the total
This is related to rev. abe5c803a0e36f18aec4cc56abc289f66329a749
Diffstat (limited to 'addons')
| -rw-r--r-- | addons/account/report/account_aged_partner_balance.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/addons/account/report/account_aged_partner_balance.py b/addons/account/report/account_aged_partner_balance.py index b7c26120b48..105720819ec 100644 --- a/addons/account/report/account_aged_partner_balance.py +++ b/addons/account/report/account_aged_partner_balance.py @@ -175,18 +175,20 @@ class aged_trial_report(report_sxw.rml_parse, common_report_header): partners_partial = self.cr.fetchall() partners_amount = dict((i[0],0) for i in partners_partial) for partner_info in partners_partial: + partial = False if partner_info[2]: # in case of partial reconciliation, we want to keep the left amount in the oldest period self.cr.execute('''SELECT MIN(COALESCE(date_maturity,date)) FROM account_move_line WHERE reconcile_partial_id = %s''', (partner_info[2],)) date = self.cr.fetchall() if date and args_list[-3] <= date[0][0] <= args_list[-2]: # partial reconcilation + partial = True self.cr.execute('''SELECT SUM(l.debit-l.credit) FROM account_move_line AS l WHERE l.reconcile_partial_id = %s''', (partner_info[2],)) unreconciled_amount = self.cr.fetchall() partners_amount[partner_info[0]] += unreconciled_amount[0][0] - else: + if not partial: partners_amount[partner_info[0]] += partner_info[1] history.append(partners_amount) |
