web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Mohana's Dynamics Business Central / Nav blog / Sorting cannot be done base...

Sorting cannot be done based on following FlowFields, you must set the security filtering mode to ‘Filtered’.

Views (4689)
Mohana Yadav Profile Picture Mohana Yadav 61,204 Super User 2026 Season 1
When we went to do a Cash Receipt- went to Apply Entries. And selected to sort by Remaining Amount and got the below error.



Sorting cannot be done based on following FlowFields in the Cust. Ledger Entry table: Remaning Amount. This is because the record’s security filtering mode is set to ‘Validated’ (as specified by the SecurityFiltering property) and there are active security filters in the system. To sort based on the FlowFields, you must set the security filtering mode to ‘Filtered’.

Solution:
We need to change the properties of the record variable as indicated below



This error will appear only when you are not SUPER user and set a security filter on the one of the permission sets assigned to user.

This was originally posted here.

Comments

*This post is locked for comments