commit 103645835bdb91a0d9fa4a5ba4babab7bbad9b03
author Deepesh Garg <deepeshgarg6@gmail.com> Sun Jun 14 13:27:19 2020 +0530
committer Deepesh Garg <deepeshgarg6@gmail.com> Sun Jun 14 13:27:19 2020 +0530
tree dcfd2632ca4ed2c135e1fb452a8ab020c5caf02a
parent 76ddf4f0b524f82c77d2d7439ff3ce9c8df70db7

fix: Handle 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 4a35a66..5ec78ac 100644
--- a/erpnext/accounts/report/financial_statements.py
+++ b/erpnext/accounts/report/financial_statements.py
@@ -391,6 +391,7 @@
 			where company=%(company)s
 			{additional_conditions}
 			and posting_date <= %(to_date)s
+			and is_cancelled = 0
 			order by account, posting_date""".format(additional_conditions=additional_conditions), gl_filters, as_dict=True) #nosec
 
 		if filters and filters.get('presentation_currency'):