I would like to create my own generic inquiry that links the RelationGroup table to the Users table - I’m guessing that there is an intermediate table that I haven’t found yet. The goal is to have a generic inquiry that gives me all the restriction groups that the users belong to. If you have managed to do this, I would be grateful if you could share some insights!
+13Hi
I created a Generic inquiry long ago for one of my requirements.
Could you please check if this helps
Acumatica Functional Consultant & Customer Experience Supervisor
1 person likes this
Thank you so much, I did see your post, and I did test this generic inquiry, thank you for sharing it. Unfortunately this isn’t working correctly, it is showing every user as having access to every RelationGroup. It is because of the way it is linked, there is no PKID for users in the RelationGroup:
The block in red needs to show a field from the RelationGroup table, and there doesn’t seem to be anything there that is shared with the Users Table. If I find a solution, I will let you know!
+10What determines the membership to a specific group is the “GroupMask” field that to the best of my knowledge only with code you can decipher it. Code is not complicated but then you will need a screen for it to display the result as you can not use GI. the code that identifies the relation is something like “PX.SM.UserAccess.IsIncluded(Base.Users.Current.GroupMask, RelationGroup)”
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.