commit fac6b5962765515309e98b65c6baa08059632500
author Saif Ur Rehman <saifi0102@gmail.com> Tue Jan 01 16:33:22 2019 +0500
committer Saif Ur Rehman <saifi0102@gmail.com> Tue Jan 01 16:33:22 2019 +0500
tree f7143f07272d1d433740358708b5f159912fcb84
parent 1fa3f7d81e67d7a1af9f3ee5ffa553c7b064380e

Exclude opening invoices in Gross Profit Report

erpnext/accounts/report/gross_profit/gross_profit.py

diff --git a/erpnext/accounts/report/gross_profit/gross_profit.py b/erpnext/accounts/report/gross_profit/gross_profit.py
index 2ed664c..1bb3a88 100644
--- a/erpnext/accounts/report/gross_profit/gross_profit.py
+++ b/erpnext/accounts/report/gross_profit/gross_profit.py
@@ -316,7 +316,7 @@
 					on `tabSales Invoice Item`.parent = `tabSales Invoice`.name
 				{sales_team_table}
 			where
-				`tabSales Invoice`.docstatus=1 {conditions} {match_cond}
+				`tabSales Invoice`.docstatus=1 and `tabSales Invoice`.is_opening='No' {conditions} {match_cond}
 			order by
 				`tabSales Invoice`.posting_date desc, `tabSales Invoice`.posting_time desc"""
 			.format(conditions=conditions, sales_person_cols=sales_person_cols,