commit ddccec4f5d1b066fbf7b4bb74fa99bf21f9cf4b8
author Deepesh Garg <42651287+deepeshgarg007@users.noreply.github.com> Wed Oct 14 22:09:08 2020 +0530
committer GitHub <noreply@github.com> Wed Oct 14 22:09:08 2020 +0530
tree 261abc191bb8d93b739d4c0e2223aaefbb806389
parent f8ce64c0ca0e9768c0e36b17c1314a9efcc5ad6f
parent 37c2ed269ea6292be5912d70100a4cf11e973f90

Merge pull request #23643 from deepeshgarg007/payment_reco_cancel

fix: Do not get cancelled vouchers in Payment Reconciliation

erpnext/accounts/doctype/payment_reconciliation/payment_reconciliation.py

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