commit 2dc90dd8ac3e392de7329deca55cdc02cc3f2ce6
author Deepesh Garg <deepeshgarg6@gmail.com> Tue Jun 22 13:03:22 2021 +0530
committer Deepesh Garg <deepeshgarg6@gmail.com> Thu Jun 24 10:37:19 2021 +0530
tree 18ec8f0bbd440641ab5ff12f9ac726b00733be65
parent 5f5bbf622af9c869c60e07968771206298c2750a

fix: Export invoices not visible in GSTR-1 report

erpnext/regional/report/gstr_1/gstr_1.py

diff --git a/erpnext/regional/report/gstr_1/gstr_1.py b/erpnext/regional/report/gstr_1/gstr_1.py
index 80e2d72..1096159 100644
--- a/erpnext/regional/report/gstr_1/gstr_1.py
+++ b/erpnext/regional/report/gstr_1/gstr_1.py
@@ -201,7 +201,7 @@
 		elif self.filters.get("type_of_business") ==  "EXPORT":
 			conditions += """ AND is_return !=1 and gst_category = 'Overseas' """
 
-		conditions += " AND billing_address_gstin NOT IN %(company_gstins)s"
+		conditions += " AND IFNULL(billing_address_gstin, '') NOT IN %(company_gstins)s"
 
 		return conditions