Field sales_order is not selectable. Can't see multiple Lists (Sales Invoice, Material Request, Delivery Note, ...)

ERPNext
1

Hello,

After updating to the last version I got the following message “Field sales_order is not selectable” or “Field against_sales_order is not selectable” and I can’t see the Lists Sales Invoice, Material Request and Delivery Note. However I can see all the documents with a report.

Also when login with the Administrator user I don’t have any issue.

Thanks

2

You will have to remove those doctypes with filters from __UserSettings,
go to bench mysql and type,
DELETE from `__UserSettings` where doctype in ('Sales Invoice', 'Material Request', 'Delivery Note') and user = 'set_your_user_here';

3

Thanks for the fast response @shreya115.

This has solved the problem for Material Request and Delivery Note, but still having the issue with Sales Invoice.

4

Can you execute this query and post the screenshot here?
SELECT doctype from `__UserSettings` where user = 'set_your_user_here';

5

±-----------------+
| doctype |
±-----------------+
| Address |
| Communication |
| Custom Field |
| Customer |
| Delivery Note |
| DocType |
| Error Log |
| Fiscal Year |
| GL Entry |
| Global Defaults |
| Issue |
| Item |
| Journal Entry |
| Kanban Board |
| Material Request |
| Payment Entry |
| Payment Request |
| Production Order |
| Project |
| Purchase Invoice |
| Purchase Receipt |
| Quotation |
| Sales Invoice |
| Sales Order |
| Stock Entry |
| ToDo |
| User |
±-----------------+

6

After performing DELETE from __UserSettings where doctype in (‘Sales Invoice’, ‘Material Request’, ‘Delivery Note’) and user = ‘set_your_user_here’;

This is the result:

±-----------------+
| doctype |
±-----------------+
| Address |
| Communication |
| Custom Field |
| Customer |
| DocType |
| Error Log |
| Fiscal Year |
| GL Entry |
| Global Defaults |
| Issue |
| Item |
| Journal Entry |
| Kanban Board |
| Payment Entry |
| Payment Request |
| Production Order |
| Project |
| Purchase Invoice |
| Purchase Receipt |
| Quotation |
| Sales Order |
| Stock Entry |
| ToDo |
| User |
±-----------------+

But still same issue

7

What’s the error now, when you try to open Sales Invoice list?

8

Still same problem.

9

Give this a try,
DELETE from `__UserSettings` where doctype = 'Sales Order' and user = 'set_your_user_here';

10

Thanks @shreya115 but is not improving.

Is there any other table where filters are recorded?

11

Update: After removing the row this is what appears back after few minutes:

| set_your_user_here | Sales Invoice | {“Kanban”: {“order_by”: “tabSales Invoice.modified desc”, “filters”: []}, “fields”: [“tabSales Invoice.name”, “tabSales Invoice.posting_date”, “tabSales Invoice.base_net_total”, “tabSales Invoice.base_total_taxes_and_charges”, “tabSales Invoice.base_grand_total”, “tabSales Invoice.customer”, “tabSales Invoice.tax_id”, “tabSales Invoice.due_date”], “List”: {“order_by”: “tabSales Invoice.creation desc”, “filters”: [[“Sales Invoice Item”, "sales_order", “=”, “SO-2017-00146”]]}, “last_view”: “Report”, “Report”: {“fields”: [[“name”, “Sales Invoice”], [“docstatus”, “Sales Invoice”], [“title”, “Sales Invoice”], [“customer”, “Sales Invoice”], [“company”, “Sales Invoice”], [“mode_of_payment”, “Sales Invoice”], [“grand_total”, “Sales Invoice”], [“status”, “Sales Invoice”], [“currency”, “Sales Invoice”], [“customer_name”, “Sales Invoice”], [“base_grand_total”, “Sales Invoice”], [“outstanding_amount”, “Sales Invoice”], [“due_date”, “Sales Invoice”], [“is_return”, “Sales Invoice”]], “add_totals_row”: 0, “order_by”: “tabSales Invoice.modified desc”, “filters”: []}, “updated_on”: “Sat Jan 20 2018 19:45:28 GMT+0100”}