Error on custom reports

when i creat custom reports using report builder and save it by save as it works,but on next time when i open the documents it brings dt errors like if i creat a custom report on purchase receipt when i open it next it brings error how can i solve it or how can i delete those custom reports?i have tried to delete using administrator previlage but not working?thanks for your replays in advance.

@Sachine_P1 can you share your JS console?

Traceback (most recent call last):
File “/home/egteuser/frappe-bench/apps/frappe/frappe/”, line 55, in application
response = frappe.handler.handle()
File “/home/egteuser/frappe-bench/apps/frappe/frappe/”, line 19, in handle
File “/home/egteuser/frappe-bench/apps/frappe/frappe/”, line 36, in execute_cmd
ret =, **frappe.form_dict)
File “/home/egteuser/frappe-bench/apps/frappe/frappe/”, line 882, in call
return fn(*args, **newargs)
File “/home/egteuser/frappe-bench/apps/frappe/frappe/desk/”, line 16, in get
data = compress(execute(**args))
File “/home/egteuser/frappe-bench/apps/frappe/frappe/desk/”, line 21, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File “/home/egteuser/frappe-bench/apps/frappe/frappe/model/”, line 79, in execute
result = self.build_and_run()
File “/home/egteuser/frappe-bench/apps/frappe/frappe/model/”, 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/egteuser/frappe-bench/apps/frappe/frappe/”, line 148, in sql
File “/home/egteuser/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/egteuser/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, “Unknown column ‘tabPurchase Receipt.price_list_rate’ in ‘order clause’”)

this error comes after after i creat a custom report onpurchase receipt,even i remove the price list column from the reports its still coming,also i creat a custom report on journal entry the system has stopped showing GENERAL LEDGER AND every single ledger relted reports…it just didnt bring nothing it will blure only.thanks

Regarding the error message, please check the value of “Sort by” from the Menu options. You cannot select price_list_rate there.