"Column is not filterable" Error when trying to filter

(0) Share

Report

Posted on by Tristan Chisci

Hi,

My customer is using AX 365 for Finance and Operations.

When we try to filter on columns by clicking on them or with ctrl+G we have the following error message : "Column is not filterable" :

This happens on almost every columns in all forms (General journals, Vendor and customer list, Invoice journal ...).

We already try to switch on Chrome, Edge, Firefox and to clear user's data usage.

Thanks a lot for your ideas.

Categories:

Other

Finance and Operations

I have the same question (0)

All responses (16)

Answers (1)

udaY-ch 5,133 on at

Like (0)

Report

Hi,

Kindly refer the blog community.dynamics.com/.../246043

Uday.

Was this reply helpful? Yes No
Tristan Chisci 80 on at

Like (0)

Report

Hi Uday,

Thanks for your reply.

However I'm just trying to get this new filter :

But I got the error mentioned above.

Regards.

Tristan.

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report

Hi Chisci,

Couldn't see the error texts or message.

Best,

uday.

Was this reply helpful? Yes No
Tristan Chisci 80 on at

Like (0)

Report

Hi Uday,

Thanks for your prompt reply.

The error message is the one on my first post "Column is not filterable".

My second post is the normal behavior that I'm expecting.

Hope it helps.

Tristan.

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report

Hi Chisci,

Can we have a screenshot.

Best,

uday.

Was this reply helpful? Yes No
Tristan Chisci 80 on at

Like (0)

Report

Hello Uday,

This happens when I click on a column field :

Was this reply helpful? Yes No
Jie G on at

Like (0)

Report

Hi,

Does every column have the same behavior? Does the quick filter work? When you enter something in the quick filter, is there a drop down list?

Was this reply helpful? Yes No
Tristan Chisci 80 on at

Like (0)

Report

Hi Ada,

Not every column, 10 % of them works (name, search name appears to work).

The Quick filter works and the drop down list as well.

Quick filter also works on the field which have the "Column is not filterable" error :

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report

Hi,

Make sure you're not trying to filter the column which is a calculated integer or any sort of column which comes from display methods. Display methods cannot be filtered.

Best,

Uday

Was this reply helpful? Yes No
Tristan Chisci 80 on at

Like (0)

Report

Hi,

I'm trying to filter on Vendor account or Vendor group. This work for some users and generate the error for other.

In our sandbox we don't have this problem.

This is really odd.

Regards.

Tristan.

Was this reply helpful? Yes No