Wednesday 26 July 2017

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

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.

Saturday 1 July 2017