"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

All responses (16)

Answers (1)

Suggested answer

Dieter 127 on at

Like (1)

Report

RE: "Column is not filterable" Error when trying to filter

Yesterday we updated all of our environments with the latest App 8.1 and PU20 for Dynamics 365.

Today we had the same issue on only 1 of our environments, we simply had to restart our environment.

The IIS AOSService may be sufficient, but I restarted the environment through Lifecycle Services (LCS).
RamaKrishna Tanneeru 1,020 on at

Like (1)

Report

RE: "Column is not filterable" Error when trying to filter

Thanks Tristan :) I will confirm you once we apply the KB and test.
Tristan Chisci 80 on at

Like (0)

Report

RE: "Column is not filterable" Error when trying to filter

Hello,

We installed the following KB :

KB 4458443: Attribute Filter show no Results for non-text fields

KB 4458754: [Binary Fix]Ability to recall Customer order by receipt for returns (creation or pickup receipt)

KB 4131935: Export fails when incremental push is enabled with CT

KB 4456779: Update index hint on Batch table is causing a SQL error

KB 4346176: Microsoft Dynamics 365 for Finance and Operations - Version 8.0.3 (Binary part)

KB 4457716: [Binary] Return location policy does not create Inventory blocks

KB 4463168: Microsoft Dynamics 365 for Finance and Operations Platform update 20 (7.0.5030)
RamaKrishna Tanneeru 1,020 on at

Like (0)

Report

RE: "Column is not filterable" Error when trying to filter

Hello Tristan Chisci,

We have the same issue in our environment. Could you please let us know the latest KB number which resolved this issue.

Thanks in advance!

Ramakrishna Tanneeru
RamaKrishna Tanneeru 1,020 on at

Like (0)

Report

RE: "Column is not filterable" Error when trying to filter

Hello Tristan Chisci,

We have the same issue in our environment. Could you please let us know the latest KB number which resolved this issue.

Thanks in advance!

Ramakrishna Tanneeru
Verified answer

Tristan Chisci 80 on at

Like (0)

Report

RE: "Column is not filterable" Error when trying to filter

Hello All,

Thanks for your replies.

We found the answer, the solution was to apply lastest KB, it seems that microsoft knew about this error and the last few KB fix the issue.

Hope this can help others.

Tristan.
Tristan Chisci 80 on at

Like (0)

Report

RE: "Column is not filterable" Error when trying to filter

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.
udaY-ch 4,643 on at

Like (0)

Report

RE: "Column is not filterable" Error when trying to filter

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
Tristan Chisci 80 on at

Like (0)

Report

RE: "Column is not filterable" Error when trying to filter

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 :
Jie G on at

Like (0)

Report

RE: "Column is not filterable" Error when trying to filter

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?