commit 72715956f125c45ff3916506a0505f08d4645812
author Saqib <nextchamp.saqib@gmail.com> Wed Jul 14 15:56:20 2021 +0530
committer GitHub <noreply@github.com> Wed Jul 14 15:56:20 2021 +0530
tree 09360f2a5aaa0d069eec00b3874866a88c39d531
parent 59bf2df28e95259fd0046df24a2d33789b850f06

fix: tds computation summary shows cancelled invoices (#26486)

erpnext/accounts/report/tds_computation_summary/tds_computation_summary.py

diff --git a/erpnext/accounts/report/tds_computation_summary/tds_computation_summary.py b/erpnext/accounts/report/tds_computation_summary/tds_computation_summary.py
index e15715d..6b9df41 100644
--- a/erpnext/accounts/report/tds_computation_summary/tds_computation_summary.py
+++ b/erpnext/accounts/report/tds_computation_summary/tds_computation_summary.py
@@ -75,7 +75,8 @@
 		select voucher_no, credit
 		from `tabGL Entry`
 		where party in (%s) and credit > 0
-			and company=%s and posting_date between %s and %s
+			and company=%s and is_cancelled = 0
+			and posting_date between %s and %s
 	""", (supplier, company, from_date, to_date), as_dict=1)
 
 	supplier_credit_amount = flt(sum(d.credit for d in entries))