commit 9c67629e281696bf673fc4582ebf59a50b4b05ea
author Deepesh Garg <42651287+deepeshgarg007@users.noreply.github.com> Thu Oct 29 19:51:57 2020 +0530
committer GitHub <noreply@github.com> Thu Oct 29 19:51:57 2020 +0530
tree e0793cd920f0a5b8c15cca60e6e55e58dd03040e
parent 8f6bd851d37a7a456dd1f02a5377e91f9b5b20d5

fix: Ignore cancelled entries instock balance report (#23757)

Co-authored-by: Nabin Hait <nabinhait@gmail.com>

erpnext/stock/report/stock_balance/stock_balance.py

diff --git a/erpnext/stock/report/stock_balance/stock_balance.py b/erpnext/stock/report/stock_balance/stock_balance.py
index 042087a..1339d9b 100644
--- a/erpnext/stock/report/stock_balance/stock_balance.py
+++ b/erpnext/stock/report/stock_balance/stock_balance.py
@@ -168,6 +168,7 @@
 		from
 			`tabStock Ledger Entry` sle force index (posting_sort_index)
 		where sle.docstatus < 2 %s %s
+		and is_cancelled = 0
 		order by sle.posting_date, sle.posting_time, sle.creation, sle.actual_qty""" % #nosec
 		(item_conditions_sql, conditions), as_dict=1)