fix: Customer Credit Balance Report query fix (#19105)
diff --git a/erpnext/selling/report/customer_credit_balance/customer_credit_balance.py b/erpnext/selling/report/customer_credit_balance/customer_credit_balance.py
index cd50568..f396705 100644
--- a/erpnext/selling/report/customer_credit_balance/customer_credit_balance.py
+++ b/erpnext/selling/report/customer_credit_balance/customer_credit_balance.py
@@ -60,7 +60,7 @@
conditions = ""
if filters.get("customer"):
- conditions += " AND c.name = " + filters.get("customer")
+ conditions += " AND c.name = '" + filters.get("customer") + "'"
return frappe.db.sql("""SELECT
c.name, c.customer_name,
@@ -69,6 +69,6 @@
FROM `tabCustomer` c, `tabCustomer Credit Limit` ccl
WHERE
c.name = ccl.parent
- AND ccl.company = %s
- {0}
- """.format(conditions), (filters.get("company")), as_dict=1) #nosec
+ AND ccl.company = '{0}'
+ {1}
+ """.format( filters.get("company"),conditions), as_dict=1) #nosec