GI for Restriction Groups -Customer Access (AR102000)-

There’s an out of the box GI called Restriction Groups by Customer that could give you the inverse of AR201000.  It’s ScreenId AR102010.

How would you like the data displayed?

Here’s a very simple one I threw together.  You’ll probably want to throw in some additional fields or adjust it for your use case.  ;)

You’ll need to make sure the user viewing it has appropriate rights to view all the restriction groups or it will be incomplete information.

Let me know if this helps.

 I see…  Let’s take a slightly different approach - The Wyatt Erp Approach…

Acumatica stores the Group information in a table called RelationGroup.  It stores what object is part of each Group Restriction information on the records themselves.  In your case, that would be the Account and Sub tables.  It stores this in the GroupMask field, which is present on each of these tables as well as any others that can be a part of a group (BAccount, InventoryItem, etc.).  All of the GroupMask fields are stored in the DB as a varbinary type (which is basically a list of 1s and 0s).  This lets them store multiple pieces of information in the same field, and they use bitwise Math to get the values out.

The simplest way to check if a record is in a restriction group:

Make a Relation.  Customer is Parent, RelationGroup is Child

Include the fields you want in Results Grid.  Add this line:

=CInt((CLong([Customer.GroupMask])%(CLong([RelationGroup.GroupMask])*2))/CLong([RelationGroup.GroupMask]))

This field will now return a 1 if the Customer is part of "YourGroupName" or a 0 if it isn't. 

I don't have them written out for the A, A Inverse, B, B Inverse types, but if you want to take this further, then check out RelationGroup.GroupType.

The results will return a GI that looks something like this:
Where you have the customer name, the group name and a 1 or 0 as a true/false as to whether or not there’s a membership there. 

In the tables, you’ll want to create an alias for each RelationGroup you have:
 

For the Relations, you’ll want to add a relationship for each group name to each alias as follows:

I’ve only included 3 here, but as you can see, they’ll add up depending on how many restriction groups you have.  In your results grid, you’ll want it to look something like this:
 

You can call out these groups by joining them to any other table that’s restricted as well, and get similar results using the same structure.  

I’ve attached a sanitized version of the GI where you’ll just need to add in your groups and add more tables/aliases as needed.  Hopefully this solves your dilemma.  ;) 

Have fun!

James

Interesting…. I didn’t have that same experience with this… Is your GI limiting results to X amount of records?  Are you using multiple group types other than GroupType ‘A’? I.E.: inverse groups?

Hi @adriangavino45 were you able to find a solution? Thank you!

Hi @Chris Hackett Not yet, I still have the same result and I have not been able to find the solution.

Regards.