commit b7a44fe0a3e9756eef5ac9000913b0e7d7b86db0
author Saqib Ansari <nextchamp.saqib@gmail.com> Wed Nov 03 18:17:31 2021 +0530
committer Saqib Ansari <nextchamp.saqib@gmail.com> Wed Nov 03 18:17:31 2021 +0530
tree c7b5af65a951eaf72b93936303cd879ce6190b20
parent a5902fa3f8fc06c9b3851df351fe67de3ba689d1

perf: improve financial statement loading time

erpnext/accounts/report/financial_statements.py

diff --git a/erpnext/accounts/report/financial_statements.py b/erpnext/accounts/report/financial_statements.py
index 2cb8a68..352b1c8 100644
--- a/erpnext/accounts/report/financial_statements.py
+++ b/erpnext/accounts/report/financial_statements.py
@@ -425,8 +425,7 @@
 			{additional_conditions}
 			and posting_date <= %(to_date)s
 			and is_cancelled = 0
-			{distributed_cost_center_query}
-			order by account, posting_date""".format(
+			{distributed_cost_center_query}""".format(
 				additional_conditions=additional_conditions,
 				distributed_cost_center_query=distributed_cost_center_query), gl_filters, as_dict=True) #nosec