Merge lp:~openerp-dev/openobject-addons/6.1-opw-574160-skh into lp:openobject-addons/6.1

[Somesh Khare]

Hello Sir,

[Fix]: In 6.1 when you open "Manual Reconciliation" Menu, Entries to reconcile did not appear.

Steps:
1. Create two invoices for two different partners and validate them
2. Now Open "Accounting/Periodical Processing/Reconciliation/Manual Reconciliation" menu"

list view has now records in it. This branch fixes this issue.

Kindly review the branch and please share your views.

Thanks,
Somesh Khare

[Naresh(OpenERP) (nch-openerp)]

review: Approve

[Naresh(OpenERP) (nch-openerp)]

Hello,

This bug was qualified as Confirmed on Trunk (means still existing and reproducible). A Merge Proposal for trunk was created to fix it. Here is the link to follow the MP on Launchpad https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-opw-574160-port-mma/+merge/132501 and be informed once it's been merged in trunk: ... If this Merge Proposal could not be merged in v6.1 at the release of v7.0, it will be closed.

Thanks,
Naresh Soni

Unmerged revisions

6898. By Somesh Khare on 2012-07-20

[FIX] account_move_line : Manual reconciliation did not display partnerts to reconcile (Case: ref 574160)

=== modified file 'account/account_move_line.py'
--- account/account_move_line.py	2012-07-04 16:33:07 +0000
+++ account/account_move_line.py	2012-07-20 06:40:57 +0000
@@ -726,7 +726,7 @@
                     AND l.state <> 'draft'
                     GROUP BY l.partner_id
                 ) AS s ON (p.id = s.partner_id)
-                WHERE debit > 0 AND credit > 0
+                WHERE debit >= 0 AND credit >= 0
                 ORDER BY p.last_reconciliation_date LIMIT 1 OFFSET %s""", (offset, )
             )
         return cr.fetchone()