fix: incorrect sql error if account name has '%'
diff --git a/erpnext/accounts/report/customer_ledger_summary/customer_ledger_summary.py b/erpnext/accounts/report/customer_ledger_summary/customer_ledger_summary.py
index a2c0f86..f4a0175 100644
--- a/erpnext/accounts/report/customer_ledger_summary/customer_ledger_summary.py
+++ b/erpnext/accounts/report/customer_ledger_summary/customer_ledger_summary.py
@@ -376,6 +376,10 @@
if not income_or_expense_accounts:
# prevent empty 'in' condition
income_or_expense_accounts.append("")
+ else:
+ # escape '%' in account name
+ # ignoring frappe.db.escape as it replaces single quotes with double quotes
+ income_or_expense_accounts = [x.replace("%", "%%") for x in income_or_expense_accounts]
accounts_query = (
qb.from_(gl)