Error in export of report in Excel format

ERPNext
1

Hi,
I got the following error while trying to export the Trial Balance report in excel format

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 56, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 19, in handle
execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 42, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 907, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 149, in export_query
row_list.append(row[columns[idx][“fieldname”]])
KeyError: u’opening_debit’

2

Replicating in exporting in Excel. Thanks for reporting it. @ManasSolanki please check on priority. Btw, I didn’t receive error message but

502 bad gateway error

3

Hi @shameem,
Fixed. Will be merged soon.

4

Same issue here

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 55, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 21, in handle
data = execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 52, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 907, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 155, in export_query
xlsx_file = make_xlsx(result, “Query Report”)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/xlsxutils.py”, line 29, in make_xlsx
obj = obj.handle(item)
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/html2text/init.py”, line 134, in handle
self.feed(data)
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/html2text/init.py”, line 130, in feed
data = data.replace(“”, “”)
TypeError: an integer is required

Trying to export a report to Excel

5

I’m having this Issue, any update on how this can be fixed?