Sales Order Report builder giving error - Unknown Column

Hi,

In the Sales Order Report Builder, when I am trying to add the Item Code from Sales Order Item, I am getting this error. Even though, the report goes through when I add the column. Once I log off and re-login, the report is giving errors.

Traceback (most recent call last):
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py”, line 55, in application
response = frappe.handler.handle()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py”, line 19, in handle
execute_cmd(cmd)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py”, line 36, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py”, line 879, in call
return fn(*args, **newargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 16, in get
data = compress(execute(**args))
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 21, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 79, in execute
result = self.build_and_run()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 103, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/database.py”, line 148, in sql
self._cursor.execute(query)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, “Unknown column ‘tabSales Order Item.name as ‘Sales Order Item:name’’ in ‘field list’”)

Can you please help me to resolve this error?

Thanks
Uma

Hi,

Can anybody please help me with this?

Thanks
Uma

Hello,

In the report, check Pick Column option. If you see any blank field there, remove it. Ensure that field select for Item Name is correct and valid.