Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
StuAllen opened this issue Nov 14, 2024 · 0 comments
Open

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

StuAllen opened this issue Nov 14, 2024 · 0 comments

Comments

@StuAllen
Copy link

StuAllen commented Nov 14, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant