commit d80d442aa1f82a32a9286320270243cba73675f7
author Deepesh Garg <deepeshgarg6@gmail.com> Sat Jun 13 21:12:19 2020 +0530
committer Deepesh Garg <deepeshgarg6@gmail.com> Sat Jun 13 21:12:19 2020 +0530
tree 47836245d8daf5f73e676d85fc31b38c6397932f
parent d5b97d69965efbfbabde144728852f20d9c6d58c

fix: Do not select cancelled entries in financial statements

erpnext/accounts/report/financial_statements.py

diff --git a/erpnext/accounts/report/financial_statements.py b/erpnext/accounts/report/financial_statements.py
index 0339e49..bb33a00 100644
--- a/erpnext/accounts/report/financial_statements.py
+++ b/erpnext/accounts/report/financial_statements.py
@@ -418,6 +418,7 @@
 			where company=%(company)s
 			{additional_conditions}
 			and posting_date <= %(to_date)s
+			and is_cancelled = 0
 			{distributed_cost_center_query}
 			order by account, posting_date""".format(
 				additional_conditions=additional_conditions,