Show company column in order in consolidated financial statement
diff --git a/erpnext/accounts/report/consolidated_financial_statement/consolidated_financial_statement.py b/erpnext/accounts/report/consolidated_financial_statement/consolidated_financial_statement.py
index c53707a..0b1fc6d 100644
--- a/erpnext/accounts/report/consolidated_financial_statement/consolidated_financial_statement.py
+++ b/erpnext/accounts/report/consolidated_financial_statement/consolidated_financial_statement.py
@@ -265,7 +265,7 @@
company, ["lft", "rgt"])
return frappe.db.sql_list("""select name from `tabCompany`
- where lft >= {0} and rgt <= {1}""".format(lft, rgt))
+ where lft >= {0} and rgt <= {1} order by lft, rgt""".format(lft, rgt))
def get_accounts(root_type, filters):
return frappe.db.sql(""" select name, is_group, company,