fix: Get only specified company accounts in financial statements (#20486)
diff --git a/erpnext/accounts/report/financial_statements.py b/erpnext/accounts/report/financial_statements.py
index 30c012e..96f78f9 100644
--- a/erpnext/accounts/report/financial_statements.py
+++ b/erpnext/accounts/report/financial_statements.py
@@ -348,7 +348,8 @@
additional_conditions = get_additional_conditions(from_date, ignore_closing_entries, filters)
accounts = frappe.db.sql_list("""select name from `tabAccount`
- where lft >= %s and rgt <= %s""", (root_lft, root_rgt))
+ where lft >= %s and rgt <= %s and company = %s""", (root_lft, root_rgt, company))
+
additional_conditions += " and account in ({})"\
.format(", ".join([frappe.db.escape(d) for d in accounts]))