Error" Sorting cannot be done based on the following Flowfields in the Customer Table in Navision 2018

(0) Share

Report

Posted on by joshtechsolutions

4,979

Hi Community,

May I ask how to rectify this error?

Thank you

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi joshtechsolutions ,

This is related to customization I think.

We have to change the Property of that Record variable like below,

SecurityFilter = Filtered

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Also this error raised when the user has not a Super permission and set a security filter on one of the permission sets to that assigned user.

Was this reply helpful? Yes No
joshtechsolutions 4,979 on at

Like (0)

Report

Hi Nitin,

May I know where can I see this Customer Table: Sales (LCY)?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

Customer - Sales (LCY) field is used for internal purpose to show the total sales of that customer in the customer card Fact box, see below.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, has the user set up a Security Filter? You can try to clear it in the Permission Set.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

joshtechsolutions 4,979 on at

Like (1)

Report

It seems to be due certain user Personalization doesn't fit well with the security filter that we have set for the user. As I can't remove the Security Filter due to our internal policy, I chose to change the User Personalization role for that user and it works.

Was this reply helpful? Yes No