Announcements
Hello,
I need to set up "permission set" so that each user (employee/purchaser) can (read/write) only its own Purchase Invoice records and not from other collogues. Based on "Purchaser code" and/or "assigne to" fields on Purchase documents (purchase invoice, posted purchase invoice, purchase order and purchase quote)
In permission, when doing filtering per entry, how can I set to be @=current user (or what is the syntax?)
I have lot of users, and trying to avoid having for each user its own permission set due to filtering per hardcoded value.
Thank you,
Kind regards
Yes, as per your needs.
ah, ok, so without AL code and custom extension it is not possible to enter some syntax in filter column?
You can customize the page extension if the Security filter not works for you.
See the below reference,
trigger OnOpenPage() begin FilterGroup(2); SetRange("Assigned User Id", UserId); FilterGroup(0); End
Please advise how can I use Field Filter for current user using USERID ? Thank you
Tx, but i do not plan to create for each user its own permission set. Pleas advise how can I use Field Filter for current user? Thank you
You can use security filter base on purchaser code on permissions. If you want to do it by code, you would have to use function USERID.
1. You need to create copy of permission sets which is given to those employee/Purchaser.
2. Then add this security filter in respective table
3.Above is the example where I have given the Purchaser Code must be vaishnavi only that time it would give Read, Write, Modify permission otherwise no. And then assign this permission set to that user.
4. Please note if your employee or Purchase has super permission or any other permission sets which has full access on these table then you must remove that since it will override your new permission sets.
If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156