From a3f6de42c456578c00cecf2eb1b4832786a6e5c8 Mon Sep 17 00:00:00 2001 From: Diptanil Saha Date: Tue, 8 Jul 2025 23:41:39 +0530 Subject: [PATCH] fix: resolve sql error on dimension-wise accounts balance report (#48477) --- .../dimension_wise_accounts_balance_report.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py b/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py index db984e821a5..084ea9b80ea 100644 --- a/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py +++ b/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py @@ -179,7 +179,7 @@ def accumulate_values_into_parents(accounts, accounts_by_name, dimension_list): def get_condition(dimension): conditions = [] - conditions.append(f"{frappe.scrub(dimension)} in %(dimensions)s") + conditions.append(f"{frappe.scrub(dimension)} in (%(dimensions)s)") return " and {}".format(" and ".join(conditions)) if conditions else "" -- GitLab