gross profit report fix
diff --git a/selling/search_criteria/gross_profit/gross_profit.sql b/selling/search_criteria/gross_profit/gross_profit.sql
index 91b7ea6..ce176c2 100644
--- a/selling/search_criteria/gross_profit/gross_profit.sql
+++ b/selling/search_criteria/gross_profit/gross_profit.sql
@@ -8,7 +8,8 @@
dn_item.parent = dn.name
AND dn.docstatus = 1
AND dn.name like '%(name)s%%'
- AND dn_item.item_code like '%(item_code)s%%'
+ AND ifnull(dn_item.item_code, '') like '%(item_code)s%%'
+ AND ifnull(dn.project_name, '') like '%(project_name)s%%'
AND dn.posting_date >= '%(posting_date)s'
AND dn.posting_date <= '%(posting_date1)s'
ORDER BY dn.name DESC
\ No newline at end of file