commit 7f11373b58431d0ab65bb742f6cdeebdade655b2
author Deepesh Garg <deepeshgarg6@gmail.com> Fri Mar 17 16:59:23 2023 +0530
committer Deepesh Garg <deepeshgarg6@gmail.com> Fri Mar 17 16:59:23 2023 +0530
tree 32da17e5f673a29c4f91a048c30a1b6abb213685
parent d11a64ddcb50188334d60a5c1650e5601d364abb

fix: Account sub query

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 82bb576..acbf7a8 100644
--- a/erpnext/accounts/report/trial_balance/trial_balance.py
+++ b/erpnext/accounts/report/trial_balance/trial_balance.py
@@ -190,7 +190,7 @@
 			(closing_balance.company == filters.company)
 			& (
 				closing_balance.account.isin(
-					frappe.qb.from_("account").select("name").where(account.report_type == report_type)
+					frappe.qb.from_(account).select("name").where(account.report_type == report_type)
 				)
 			)
 		)