| commit | ec44cd763ebc3e19f792a3af4d55d9f30305973f | [log] [tgz] |
|---|---|---|
| author | Nabin Hait <nabinhait@gmail.com> | Mon Jan 21 12:29:20 2013 +0530 |
| committer | Nabin Hait <nabinhait@gmail.com> | Mon Jan 21 12:29:20 2013 +0530 |
| tree | 0fbbf8a1ffaf448af4cbfceb54f32d9d8f00c349 | |
| parent | 8f4c78c4bf5ff94b7c90f1d157847e1ce5958cb0 [diff] |
in payment matching tool only show outstanding invoices
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 3bbadcb..f719db9 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
@@ -40,7 +40,7 @@ and ifnull(gle.is_cancelled, 'No') = 'No'\ and (select sum(debit) - sum(credit) from `tabGL Entry` \ where against_voucher_type = '%(dt)s' and against_voucher = gle.voucher_no \ - and ifnull(is_cancelled, 'No') = 'No') > 0 \ + and ifnull(is_cancelled, 'No') = 'No') != 0 \ ORDER BY gle.posting_date DESC, gle.voucher_no DESC LIMIT 50 \ ", {dt:doc.voucher_type, acc:doc.account}); }