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

(0) Share

Report

Posted on by joshtechsolutions

5,007

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,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 5,007 on at

Like (0)

Report
Copy link

Link copied!

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,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 99,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 5,007 on at

Like (1)

Report
Copy link

Link copied!

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