commit 01e0d50ebaf387aea9c814199cdfb1d6061c1802
author Deepesh Garg <42651287+deepeshgarg007@users.noreply.github.com> Thu Jul 30 22:15:23 2020 +0530
committer GitHub <noreply@github.com> Thu Jul 30 22:15:23 2020 +0530
tree b006b00328247992912c3a96d091f0b3d34dae41
parent 00175c962199e7a8e2f5add9a5b18a0e3164ba78
parent 9837285bf1e77463e2e3e76f6e2f2d10146f9030

Merge pull request #22854 from nabinhait/gl-balance-fix

fix: Ignore cancelled gl entries to get account balance

erpnext/accounts/utils.py

diff --git a/erpnext/accounts/utils.py b/erpnext/accounts/utils.py
index 824b2f2..51ac7cf 100644
--- a/erpnext/accounts/utils.py
+++ b/erpnext/accounts/utils.py
@@ -122,7 +122,7 @@
 		cost_center = frappe.form_dict.get("cost_center")
 
 
-	cond = []
+	cond = ["is_cancelled=0"]
 	if date:
 		cond.append("posting_date <= %s" % frappe.db.escape(cstr(date)))
 	else:
@@ -206,7 +206,7 @@
 		return flt(bal)
 
 def get_count_on(account, fieldname, date):
-	cond = []
+	cond = ["is_cancelled=0"]
 	if date:
 		cond.append("posting_date <= %s" % frappe.db.escape(cstr(date)))
 	else: