commit 62daa43a4cc222cb5726be5090bd5312ee9b3caf
author Deepesh Garg <42651287+deepeshgarg007@users.noreply.github.com> Mon Jul 29 15:38:39 2019 +0530
committer GitHub <noreply@github.com> Mon Jul 29 15:38:39 2019 +0530
tree 35ac8898c88757d1ecb13f1045eafb3568dacbc0
parent a55e4e2c03e057a346c1acd27f4ccf9555e00554
parent 4c652396d010e60a4bbe1ac0f533e50de6ae2c5b

Merge pull request #18513 from deepeshgarg007/trail_balance_fix

fix: Opening balance not getting calculated in trail balance report

erpnext/accounts/report/trial_balance/trial_balance.py

diff --git a/erpnext/accounts/report/trial_balance/trial_balance.py b/erpnext/accounts/report/trial_balance/trial_balance.py
index b6ddaa8..10e977a 100644
--- a/erpnext/accounts/report/trial_balance/trial_balance.py
+++ b/erpnext/accounts/report/trial_balance/trial_balance.py
@@ -123,11 +123,12 @@
 
 	if accounting_dimensions:
 		for dimension in accounting_dimensions:
-			additional_conditions += """ and {0} in (%({0})s) """.format(dimension)
+			if filters.get(dimension):
+				additional_conditions += """ and {0} in (%({0})s) """.format(dimension)
 
-			query_filters.update({
-				dimension: filters.get(dimension)
-			})
+				query_filters.update({
+					dimension: filters.get(dimension)
+				})
 
 	gle = frappe.db.sql("""
 		select