commit cc4943d54d81270ef90fe35687a3f45066d5c7cc
author Deepesh Garg <deepeshgarg6@gmail.com> Sat Jun 13 21:13:52 2020 +0530
committer Deepesh Garg <deepeshgarg6@gmail.com> Sat Jun 13 21:13:52 2020 +0530
tree 97633089f663cd627f70f24711fee55bf703ae43
parent d80d442aa1f82a32a9286320270243cba73675f7

fix: Distributed cost center query updation

erpnext/accounts/report/financial_statements.py

diff --git a/erpnext/accounts/report/financial_statements.py b/erpnext/accounts/report/financial_statements.py
index bb33a00..769eb0a 100644
--- a/erpnext/accounts/report/financial_statements.py
+++ b/erpnext/accounts/report/financial_statements.py
@@ -406,6 +406,7 @@
 				FROM `tabDistributed Cost Center`
 				WHERE cost_center IN %(cost_center)s
 				AND parent NOT IN %(cost_center)s
+				AND is_cancelled = 0
 				GROUP BY parent
 			) as DCC_allocation
 			WHERE company=%(company)s