Skip to content

Issue with Security Filters and FINDLAST to get the next Entry No. #282

@StuAllen

Description

@StuAllen

Hi,

I've hit an issue with applying security filters in a permission set to restrict access to Opportunity and Opportunity Entry table data to a specific salesperson. I can create and view opportunities with the security filter being applied correct but if I create an opportunity and try and activate the first stage I get the following error:

Error message:
A security filter has been applied to table Opportunity Entry. You cannot access records that are outside of this filter.

AL call stack:
"Opportunity Entry"(Table 5093).InsertEntry line 6 - Base Application by Microsoft
Opportunity(Table 5092).StartActivateFirstStage line 15 - Base Application by Microsoft
"Opportunity Card"(Page 5124)."Activate the First Stage - OnAction"(Trigger) line 2 - Base Application by Microsoft

Looking at the InsertEntry procedure on table 5093 it uses findlast on a 2nd version of the opportunity entry table, which then fails as the filters are outside of the security filter. The same problem existed in NAV but we were able to overcome it by setting the SecurityFiltering property on the variable to ignore, but we can no longer do this in the base app.

Is it possible to change this?
Thanks

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions