fix(Journal Entry): Opening Entry not fetching accounts (#19148)
diff --git a/erpnext/accounts/doctype/journal_entry/journal_entry.py b/erpnext/accounts/doctype/journal_entry/journal_entry.py
index eb75d0d..e25942c 100644
--- a/erpnext/accounts/doctype/journal_entry/journal_entry.py
+++ b/erpnext/accounts/doctype/journal_entry/journal_entry.py
@@ -827,10 +827,10 @@
accounts = frappe.db.sql_list("""select
name from tabAccount
where
- is_group=0 and report_type='Balance Sheet' and company=%s and
- name not in(select distinct account from tabWarehouse where
+ is_group=0 and report_type='Balance Sheet' and company={0} and
+ name not in (select distinct account from tabWarehouse where
account is not null and account != '')
- order by name asc""", frappe.db.escape(company))
+ order by name asc""".format(frappe.db.escape(company)))
return [{"account": a, "balance": get_balance_on(a)} for a in accounts]