Manual Reconciliation - Can not reconcile same customer 2 times

Bug #1217360 reported by Marc Cassuto (SFL)
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
New
Undecided
OpenERP Publisher's Warranty Team

Bug Description

The way the Manual Reconciliation action works force accountants to reconcile all entries at a time for a customer.
If one want to reconcile entries separately he can not do so :
if there is no new entries since the last reconciliation, the partner will not be shown in the view even if there is still entries to reconcile.

Here the SQL query in addons/account/account_move_line.py, in the list_partners_to_reconcile() function:
"""SELECT partner_id FROM (
                SELECT l.partner_id, p.last_reconciliation_date, SUM(l.debit) AS debit, SUM(l.credit) AS credit, MAX(l.create_date) AS max_date
                FROM account_move_line l
                RIGHT JOIN account_account a ON (a.id = l.account_id)
                RIGHT JOIN res_partner p ON (l.partner_id = p.id)
                    WHERE a.reconcile IS TRUE
                    AND l.reconcile_id IS NULL
                    AND l.state <> 'draft'
                    GROUP BY l.partner_id, p.last_reconciliation_date
                ) AS s
                WHERE debit > 0 AND credit > 0 AND (last_reconciliation_date IS NULL OR max_date > last_reconciliation_date)
                ORDER BY last_reconciliation_date"""

The last WHERE clause is the source of the issue :
 (last_reconciliation_date IS NULL OR max_date > last_reconciliation_date) is unneeded.

Marc

Tags: maintenance
Changed in openobject-addons:
assignee: nobody → OpenERP Publisher's Warranty Team (openerp-opw)
tags: added: maintenance
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.