commit 9500aa8c942d5ceaafa1205360173752b48dfe8a
author Deepesh Garg <deepeshgarg6@gmail.com> Mon Jun 06 08:57:55 2022 +0530
committer GitHub <noreply@github.com> Mon Jun 06 08:57:55 2022 +0530
tree 195e7c891c7895b2ad0ba85c54bc89818100357e
parent 12edddbfd4f0f6fa483b6d166bd8cc149d589998
parent f0ac394d6e5d284a476eba62a6fcd6aaa01dd00d

Merge pull request #31218 from deepeshgarg007/distinct_gstin

fix(India): GSTIN filter 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 0bdbe56..6cbc12c 100644
--- a/erpnext/regional/report/gstr_1/gstr_1.py
+++ b/erpnext/regional/report/gstr_1/gstr_1.py
@@ -1155,8 +1155,11 @@
 		.inner_join(links)
 		.on(address.name == links.parent)
 		.select(address.gstin)
+		.distinct()
 		.where(links.link_doctype == "Company")
 		.where(links.link_name == company)
+		.where(address.gstin.isnotnull())
+		.where(address.gstin != "")
 		.run(as_dict=1)
 	)