commit cfae52a40a145fe204639d1b2abf84012f88e542
author Deepesh Garg <deepeshgarg6@gmail.com> Tue Jul 18 12:26:19 2023 +0530
committer GitHub <noreply@github.com> Tue Jul 18 12:26:19 2023 +0530
tree ef05c0550fd5bf92079236307ec297b072e6e86a
parent 9fb1533b8f94efbc8d72d60d0e6b52241b3d1f38

fix: Opening balance in TB report (#36171)

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 5176c31..39917f9 100644
--- a/erpnext/accounts/report/trial_balance/trial_balance.py
+++ b/erpnext/accounts/report/trial_balance/trial_balance.py
@@ -221,7 +221,10 @@
 		)
 	else:
 		if start_date:
-			opening_balance = opening_balance.where(closing_balance.posting_date >= start_date)
+			opening_balance = opening_balance.where(
+				(closing_balance.posting_date >= start_date)
+				& (closing_balance.posting_date < filters.from_date)
+			)
 			opening_balance = opening_balance.where(closing_balance.is_opening == "No")
 		else:
 			opening_balance = opening_balance.where(