| commit | 4924a9f7648cb3515fdbe282a77926527a715e9b | [log] [tgz] |
|---|---|---|
| author | Nabin Hait <nabinhait@gmail.com> | Thu Jun 27 11:01:14 2013 +0530 |
| committer | Nabin Hait <nabinhait@gmail.com> | Thu Jun 27 11:01:14 2013 +0530 |
| tree | f8c401aed4c29e3c4ff2c9f318b23b47f75b029e | |
| parent | e26acffcfe593d6a4c688536d40aa83903e69fe1 [diff] |
[fix] payment reconciliation tool
diff --git a/accounts/doctype/payment_to_invoice_matching_tool/payment_to_invoice_matching_tool.js b/accounts/doctype/payment_to_invoice_matching_tool/payment_to_invoice_matching_tool.js index 8b35bc1..ac7d9d2 100644 --- a/accounts/doctype/payment_to_invoice_matching_tool/payment_to_invoice_matching_tool.js +++ b/accounts/doctype/payment_to_invoice_matching_tool/payment_to_invoice_matching_tool.js
@@ -50,6 +50,7 @@ where against_voucher_type = '%(dt)s' \ and against_voucher = gle.voucher_no \ and voucher_no != gle.voucher_no \ + and account = gle.account \ and ifnull(is_cancelled, 'No') = 'No') != \ abs(ifnull(gle.debit, 0) - ifnull(gle.credit, 0)) \ ORDER BY gle.posting_date DESC, gle.voucher_no DESC LIMIT 50",