About the India Compliance category

For questions / announcements / issues related to the India Compliance app.

This includes topics about:

  • GST features like e-Waybills, e-Invoices and Returns.
  • Other taxation and accounting features specific to India.
1 Like

Dear Team ,
I have updated the latest version of the India Compliance app (version 15.19.0) but still some issues we are facing while generating the e way bills manually .

Getting this issue

### App Versions

{
“erpnext”: “15.64.1”,
“facebook_leads”: “0.0.1”,
“frappe”: “15.69.3”,
“helpdesk”: “1.4.0”,
“hg_leads”: “0.0.1”,
“homegenie_custom_app”: “0.0.1”,
“hrms”: “15.41.0”,
“india_compliance”: “15.19.0”,
“insights”: “2.2.9”,
“itgenie”: “0.0.1”,
“lms”: “2.26.0”,
“payments”: “0.0.1”,
“smartflo”: “0.0.1”,
“ts_homegenie”: “0.0.1”
}

### Route

Form/Sales Invoice/HG2025-26/752

### Traceback

Traceback (most recent call last):
File “apps/frappe/frappe/app.py”, line 115, in application
response = frappe.api.handle(request)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File “apps/frappe/frappe/api/init.py”, line 49, in handle
data = endpoint(**arguments)
^^^^^^^^^^^^^^^^^^^^^
File “apps/frappe/frappe/api/v1.py”, line 36, in handle_rpc_call
return frappe.handler.handle()
^^^^^^^^^^^^^^^^^^^^^^^
File “apps/frappe/frappe/handler.py”, line 51, in handle
data = execute_cmd(cmd)
^^^^^^^^^^^^^^^^
File “apps/frappe/frappe/handler.py”, line 84, in execute_cmd
return frappe.call(method, **frappe.form_dict)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “apps/frappe/frappe/init.py”, line 1742, in call
return fn(*args, **newargs)
^^^^^^^^^^^^^^^^^^^^
File “apps/frappe/frappe/utils/typing_validations.py”, line 31, in wrapper
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File “apps/india_compliance/india_compliance/gst_india/utils/e_waybill.py”, line 143, in generate_e_waybill
update_transaction(doc, frappe.parse_json(values))
File “apps/india_compliance/india_compliance/gst_india/utils/e_waybill.py”, line 1008, in update_transaction
doc.db_set(data)
File “apps/frappe/frappe/model/document.py”, line 1271, in db_set
frappe.db.set_value(
File “apps/frappe/frappe/database/database.py”, line 990, in set_value
query.run(debug=debug)
File “apps/frappe/frappe/query_builder/utils.py”, line 87, in execute_query
result = frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “apps/frappe/frappe/database/database.py”, line 230, in sql
self._cursor.execute(query, values)
File “env/lib/python3.11/site-packages/pymysql/cursors.py”, line 153, in execute
result = self._query(query)
^^^^^^^^^^^^^^^^^^
File “env/lib/python3.11/site-packages/pymysql/cursors.py”, line 322, in _query
conn.query(q)
File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 563, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 825, in _read_query_result
result.read()
File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 1199, in read
first_packet = self.connection._read_packet()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 775, in _read_packet
packet.raise_for_error()
File “env/lib/python3.11/site-packages/pymysql/protocol.py”, line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.11/site-packages/pymysql/err.py”, line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.IntegrityError: (1048, “Column ‘distance’ cannot be null”)

### Request Data

{
“type”: “POST”,
“args”: {
“doctype”: “Sales Invoice”,
“docname”: “HG2025-26/752”,
“values”: “{"supply_type":"Outward","document_type":"Tax Invoice","sub_supply_type":"Supply","vehicle_no":"TN02AT9192","lr_date":"2025-06-19","mode_of_transport":"Road","gst_vehicle_type":"Regular"}”,
“force”: true
},
“headers”: {},
“error_handlers”: {},
“url”: “/api/method/india_compliance.gst_india.utils.e_waybill.generate_e_waybill”,
“request_id”: null
}

### Response Data

{
“exception”: “pymysql.err.IntegrityError: (1048, "Column ‘distance’ cannot be null")”,
“exc_type”: “IntegrityError”,
“_exc_source”: “india_compliance (app)”
}

Also i tried with the distance in the form but getting this issue

API Request Failed 4038 : The distance between the pincodes given is too high, 4009 : E Way Bill can be generated provided at least HSN of one item belongs to goods.

Did anyone facing this issue and know how to resolve the issue kindly collobarate and guide me through

@snv @erpnextuser483475

1 Like