India Compliance : GST Itemised Purchase Register

Fresh Installed ERPNext .

India Compliance v14.0.0

Can you please copy error to clipboard and paste here?

HI @snv

   Traceback (most recent call last):

File “apps/frappe/frappe/app.py”, line 69, in application
response = frappe.api.handle()
File “apps/frappe/frappe/api.py”, line 54, in handle
return frappe.handler.handle()
File “apps/frappe/frappe/handler.py”, line 45, in handle
data = execute_cmd(cmd)
File “apps/frappe/frappe/handler.py”, line 83, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “apps/frappe/frappe/init.py”, line 1585, in call
return fn(*args, **newargs)
File “apps/frappe/frappe/init.py”, line 781, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File “apps/frappe/frappe/desk/query_report.py”, line 254, in run
result = generate_report_result(report, filters, user, custom_columns, is_tree, parent_field)
File “apps/frappe/frappe/init.py”, line 781, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File “apps/frappe/frappe/desk/query_report.py”, line 88, in generate_report_result
res = get_report_result(report, filters) or []
File “apps/frappe/frappe/desk/query_report.py”, line 69, in get_report_result
res = report.execute_script_report(filters)
File “apps/frappe/frappe/core/doctype/report/report.py”, line 142, in execute_script_report
res = self.execute_module(filters)
File “apps/frappe/frappe/core/doctype/report/report.py”, line 159, in execute_module
return frappe.get_attr(method_name)(frappe._dict(filters))
File “apps/india_compliance/india_compliance/gst_india/report/gst_itemised_purchase_register/gst_itemised_purchase_register.py”, line 11, in execute
return _execute(
File “apps/erpnext/erpnext/accounts/report/item_wise_purchase_register/item_wise_purchase_register.py”, line 32, in _execute
item_list = get_items(filters, additional_query_columns)
File “apps/erpnext/erpnext/accounts/report/item_wise_purchase_register/item_wise_purchase_register.py”, line 323, in get_items
return frappe.db.sql(
File “apps/frappe/frappe/database/database.py”, line 207, in sql
self._cursor.execute(query, values)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 148, in execute
result = self._query(query)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 310, in _query
conn.query(q)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_query_result
result.read()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1156, in read
first_packet = self.connection._read_packet()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘ecommerce_gstin’ in ‘field list’”)

(anonymous) @ request.js:462
frappe.request.cleanup @ request.js:460
(anonymous) @ request.js:319
R @ jquery.js:3500
fireWith @ jquery.js:3630
Oe @ jquery.js:9798
(anonymous) @ jquery.js:10057
load (async)
send @ jquery.js:10076
ajax @ jquery.js:9690
frappe.request.call @ request.js:273
frappe.call @ request.js:105
Promise.then.r @ query_report.js:616
refresh @ query_report.js:615
(anonymous) @ utils.js:885
i.onchange @ query_report.js:542
(anonymous) @ base_control.js:240
Promise.then (async)
(anonymous) @ dom.js:269
frappe.run_serially @ dom.js:267
u @ base_control.js:231
validate_and_set_in_model @ base_control.js:254
parse_validate_and_set_in_model @ base_control.js:209
e @ data.js:168
dispatch @ jquery.js:5430
c1.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
onSelect @ date.js:71
_triggerOnChange @ datepicker.min.js:1
selectDate @ datepicker.min.js:1
set_formatted_input @ date.js:42
set_input @ data.js:243
add_field @ page.js:865
(anonymous) @ query_report.js:511
setup_filters @ query_report.js:508
(anonymous) @ query_report.js:381
Promise.then (async)
(anonymous) @ dom.js:269
frappe.run_serially @ dom.js:267
refresh_report @ query_report.js:380
(anonymous) @ query_report.js:168
Promise.then (async)
(anonymous) @ dom.js:269
frappe.run_serially @ dom.js:267
load_report @ query_report.js:163
load @ query_report.js:140
(anonymous) @ query_report.js:29
Promise.then (async)
show @ query_report.js:29
(anonymous) @ query_report.js:23
dispatch @ jquery.js:5430
c1.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
change_to @ container.js:80
(anonymous) @ pageview.js:54
with_page @ pageview.js:13
(anonymous) @ pageview.js:48
with_doctype @ model.js:168
show @ pageview.js:47
render_page @ router.js:247
render @ router.js:221
route @ router.js:131
set_route @ desk.js:178
startup @ desk.js:87
frappe.Application @ desk.js:30
frappe.start_app @ desk.js:12
(anonymous) @ desk.js:25
c1 @ jquery.js:3766
oe @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
R @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
R @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
h0 @ jquery.js:4120
utils.js:829

   Uncaught (in promise) DOMException: play() failed because the user didn't interact with the document first.

play_sound @ utils.js:829
500 @ request.js:214
(anonymous) @ request.js:350
R @ jquery.js:3500
fireWith @ jquery.js:3630
Oe @ jquery.js:9798
(anonymous) @ jquery.js:10057
load (async)
send @ jquery.js:10076
ajax @ jquery.js:9690
frappe.request.call @ request.js:273
frappe.call @ request.js:105
Promise.then.r @ query_report.js:616
refresh @ query_report.js:615
(anonymous) @ utils.js:885
i.onchange @ query_report.js:542
(anonymous) @ base_control.js:240
Promise.then (async)
(anonymous) @ dom.js:269
frappe.run_serially @ dom.js:267
u @ base_control.js:231
validate_and_set_in_model @ base_control.js:254
parse_validate_and_set_in_model @ base_control.js:209
e @ data.js:168
dispatch @ jquery.js:5430
c1.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
onSelect @ date.js:71
_triggerOnChange @ datepicker.min.js:1
selectDate @ datepicker.min.js:1
set_formatted_input @ date.js:42
set_input @ data.js:243
add_field @ page.js:865
(anonymous) @ query_report.js:511
setup_filters @ query_report.js:508
(anonymous) @ query_report.js:381
Promise.then (async)
(anonymous) @ dom.js:269
frappe.run_serially @ dom.js:267
refresh_report @ query_report.js:380
(anonymous) @ query_report.js:168
Promise.then (async)
(anonymous) @ dom.js:269
frappe.run_serially @ dom.js:267
load_report @ query_report.js:163
load @ query_report.js:140
(anonymous) @ query_report.js:29
Promise.then (async)
show @ query_report.js:29
(anonymous) @ query_report.js:23
dispatch @ jquery.js:5430
c1.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
change_to @ container.js:80
(anonymous) @ pageview.js:54
with_page @ pageview.js:13
(anonymous) @ pageview.js:48
with_doctype @ model.js:168
show @ pageview.js:47
render_page @ router.js:247
render @ router.js:221
route @ router.js:131
set_route @ desk.js:178
startup @ desk.js:87
frappe.Application @ desk.js:30
frappe.start_app @ desk.js:12
(anonymous) @ desk.js:25
c1 @ jquery.js:3766
oe @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
R @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
R @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
h0 @ jquery.js:4120
jquery.js:10109

   GET https://dev.xyzcom/api/method/frappe.desk.query_report.run?report_name=GST%20Itemised%20Purchase%20Register&filters=%7B%22from_date%22%3A%222022-09-17%22%2C%22to_date%22%3A%222022-10-17%22%2C%22company%22%3A%22XYZ%20XYZ%20Private%20Limited%22%7D&_=1665986273036 500 (INTERNAL SERVER ERROR)

send @ jquery.js:10109
ajax @ jquery.js:9690
frappe.request.call @ request.js:273
frappe.call @ request.js:105
Promise.then.r @ query_report.js:616
refresh @ query_report.js:615
l @ utils.js:869
setTimeout (async)
(anonymous) @ utils.js:888
(anonymous) @ query_report.js:385
Promise.then (async)
(anonymous) @ dom.js:269
frappe.run_serially @ dom.js:267
refresh_report @ query_report.js:380
(anonymous) @ query_report.js:168
Promise.then (async)
(anonymous) @ dom.js:269
frappe.run_serially @ dom.js:267
load_report @ query_report.js:163
load @ query_report.js:140
(anonymous) @ query_report.js:29
Promise.then (async)
show @ query_report.js:29
(anonymous) @ query_report.js:23
dispatch @ jquery.js:5430
c1.handle @ jquery.js:5234
trigger @ jquery.js:8719
(anonymous) @ jquery.js:8797
each @ jquery.js:385
each @ jquery.js:207
trigger @ jquery.js:8796
change_to @ container.js:80
(anonymous) @ pageview.js:54
with_page @ pageview.js:13
(anonymous) @ pageview.js:48
with_doctype @ model.js:168
show @ pageview.js:47
render_page @ router.js:247
render @ router.js:221
route @ router.js:131
set_route @ desk.js:178
startup @ desk.js:87
frappe.Application @ desk.js:30
frappe.start_app @ desk.js:12
(anonymous) @ desk.js:25
c1 @ jquery.js:3766
oe @ jquery.js:3834
setTimeout (async)
(anonymous) @ jquery.js:3872
R @ jquery.js:3500
fireWith @ jquery.js:3630
fire @ jquery.js:3638
R @ jquery.js:3500
fireWith @ jquery.js:3630
ready @ jquery.js:4110
h0 @ jquery.js:4120
request.js:462

   Traceback (most recent call last):

File “apps/frappe/frappe/app.py”, line 69, in application
response = frappe.api.handle()
File “apps/frappe/frappe/api.py”, line 54, in handle
return frappe.handler.handle()
File “apps/frappe/frappe/handler.py”, line 45, in handle
data = execute_cmd(cmd)
File “apps/frappe/frappe/handler.py”, line 83, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “apps/frappe/frappe/init.py”, line 1585, in call
return fn(*args, **newargs)
File “apps/frappe/frappe/init.py”, line 781, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File “apps/frappe/frappe/desk/query_report.py”, line 254, in run
result = generate_report_result(report, filters, user, custom_columns, is_tree, parent_field)
File “apps/frappe/frappe/init.py”, line 781, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File “apps/frappe/frappe/desk/query_report.py”, line 88, in generate_report_result
res = get_report_result(report, filters) or []
File “apps/frappe/frappe/desk/query_report.py”, line 69, in get_report_result
res = report.execute_script_report(filters)
File “apps/frappe/frappe/core/doctype/report/report.py”, line 142, in execute_script_report
res = self.execute_module(filters)
File “apps/frappe/frappe/core/doctype/report/report.py”, line 159, in execute_module
return frappe.get_attr(method_name)(frappe._dict(filters))
File “apps/india_compliance/india_compliance/gst_india/report/gst_itemised_purchase_register/gst_itemised_purchase_register.py”, line 11, in execute
return _execute(
File “apps/erpnext/erpnext/accounts/report/item_wise_purchase_register/item_wise_purchase_register.py”, line 32, in _execute
item_list = get_items(filters, additional_query_columns)
File “apps/erpnext/erpnext/accounts/report/item_wise_purchase_register/item_wise_purchase_register.py”, line 323, in get_items
return frappe.db.sql(
File “apps/frappe/frappe/database/database.py”, line 207, in sql
self._cursor.execute(query, values)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 148, in execute
result = self._query(query)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 310, in _query
conn.query(q)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_query_result
result.read()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1156, in read
first_packet = self.connection._read_packet()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘ecommerce_gstin’ in ‘field list’”)

1 Like

Thank you for reporting. Fixed here:

1 Like

Thank :slight_smile:

Update: Fix has been released for the version-14 branch.