| commit | 37c2ed269ea6292be5912d70100a4cf11e973f90 | [log] [tgz] |
|---|---|---|
| author | Deepesh Garg <deepeshgarg6@gmail.com> | Wed Oct 14 21:47:43 2020 +0530 |
| committer | Deepesh Garg <deepeshgarg6@gmail.com> | Wed Oct 14 21:47:43 2020 +0530 |
| tree | c5f1ea8d489a80bf6c10c0ed700d477e3c6408e5 | |
| parent | c5e139a5421bced4b2607e68126c635848c5b8ad [diff] |
fix: Do not get cancelled vouchers in Payment Reconciliation
diff --git a/erpnext/accounts/doctype/payment_reconciliation/payment_reconciliation.py b/erpnext/accounts/doctype/payment_reconciliation/payment_reconciliation.py index 2f8b634..791b03a 100644 --- a/erpnext/accounts/doctype/payment_reconciliation/payment_reconciliation.py +++ b/erpnext/accounts/doctype/payment_reconciliation/payment_reconciliation.py
@@ -99,6 +99,7 @@ and `tabGL Entry`.against_voucher_type = %(voucher_type)s and `tab{doc}`.docstatus = 1 and `tabGL Entry`.party = %(party)s and `tabGL Entry`.party_type = %(party_type)s and `tabGL Entry`.account = %(account)s + and `tabGL Entry`.is_cancelled = 0 GROUP BY `tab{doc}`.name Having amount > 0