[fix] Get Balance only if account or party mentioned
diff --git a/erpnext/accounts/utils.py b/erpnext/accounts/utils.py
index f41d19d..51c7916 100644
--- a/erpnext/accounts/utils.py
+++ b/erpnext/accounts/utils.py
@@ -100,14 +100,15 @@
if party_type and party:
cond.append("""gle.party_type = "%s" and gle.party = "%s" """ %
(party_type.replace('"', '\\"'), party.replace('"', '\\"')))
+
+ if account or (party_type and party):
+ bal = frappe.db.sql("""
+ SELECT sum(ifnull(debit, 0)) - sum(ifnull(credit, 0))
+ FROM `tabGL Entry` gle
+ WHERE %s""" % " and ".join(cond))[0][0]
- bal = frappe.db.sql("""
- SELECT sum(ifnull(debit, 0)) - sum(ifnull(credit, 0))
- FROM `tabGL Entry` gle
- WHERE %s""" % " and ".join(cond))[0][0]
-
- # if bal is None, return 0
- return flt(bal)
+ # if bal is None, return 0
+ return flt(bal)
@frappe.whitelist()
def add_ac(args=None):