Merge branch 'asbasawaraj-erpnext_issue_13818' into develop
diff --git a/erpnext/selling/report/customers_without_any_sales_transactions/__init__.py b/erpnext/selling/report/customers_without_any_sales_transactions/__init__.py
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/erpnext/selling/report/customers_without_any_sales_transactions/__init__.py
diff --git a/erpnext/selling/report/customers_without_any_sales_transactions/customers_without_any_sales_transactions.json b/erpnext/selling/report/customers_without_any_sales_transactions/customers_without_any_sales_transactions.json
new file mode 100644
index 0000000..1c2baca
--- /dev/null
+++ b/erpnext/selling/report/customers_without_any_sales_transactions/customers_without_any_sales_transactions.json
@@ -0,0 +1,30 @@
+{
+ "add_total_row": 0,
+ "apply_user_permissions": 0,
+ "creation": "2018-05-17 15:25:06.015111",
+ "disabled": 0,
+ "docstatus": 0,
+ "doctype": "Report",
+ "idx": 0,
+ "is_standard": "Yes",
+ "modified": "2018-05-21 11:02:17.565039",
+ "modified_by": "Administrator",
+ "module": "Selling",
+ "name": "Customers Without Any Sales Transactions",
+ "owner": "Administrator",
+ "query": "SELECT\n\t`tabCustomer`.name as \"Customer Id:Link/Customer:120\",\n\t`tabCustomer`.customer_name as \"Customer Name::120\",\n\t`tabCustomer`.territory as \"Territory:Link/Territory:120\",\n\t`tabCustomer`.customer_group as \"Customer Group:Link/Customer Group:120\"\nFROM\n\t`tabCustomer`\nWHERE\n\tnot exists(select name from `tabSales Invoice` where `tabCustomer`.name = `tabSales Invoice`.customer and `tabSales Invoice`.docstatus=1 limit 1)\n\tand not exists(select name from `tabSales Order` where `tabCustomer`.name = `tabSales Order`.customer and `tabSales Order`.docstatus=1 limit 1)",
+ "ref_doctype": "Sales Invoice",
+ "report_name": "Customers Without Any Sales Transactions",
+ "report_type": "Query Report",
+ "roles": [
+ {
+ "role": "Sales User"
+ },
+ {
+ "role": "Sales Manager"
+ },
+ {
+ "role": "System Manager"
+ }
+ ]
+}
\ No newline at end of file