GL Access Account/SubAccount interaction question

  • 10 April 2024
  • 5 replies

Userlevel 3

Good morning all. I’m attempting to assist a client using GL account/subaccount restriction and having issues with it. I’m going to provide a stripped down description of what I’ve tried and I appreciate if anyone could jump in with a suggestion on how to make this work.

For sake of example, let’s say we have your basic chart of accounts using 10000-19999 for assets, 20000-39999 liabilities, 40000-49999 revenues, 50000-59999 COGS expenses, and 60000-99999 for various other categories of expenses. They also have subaccounts, so for keeping it simple lets say there’s a default 0000, and then AAAA, BBBB, and CCCC. 


The client would like to restrict 0000 such that it cannot be used for accounts 40000-99999.


After reading the help file, I created two groups.

Group 1 Type A. This group had all users, every account 40000-99999, and subaccounts AAAA, BBBB, and CCCC.

Group 2 Type A inverse. All users, every account 40000-99999, and only subaccount 0000.


That seems to work fine when dealing with accounts in those ranges but I was having problems with the accounts <40000.


I created Group 3, Type A. All users, every account 10000-39999, with all four subaccounts 0000,AAAA,BBBB,CCCC.


With all of these groups enabled, I’m still finding I am getting errors with the accounts 10000-39999. Can anyone tell me what I’m doing incorrectly? 


Best answer by jhouser 14 April 2024, 23:31

View original

5 replies

Userlevel 5
Badge +1

@philr75 I ran into this recently. The method described in Help wasn’t working for me either. What did work was actually simpler: Created one group for each combination. No Inverse group, just A type. For your example, create a type A group with account 0000 and subaccounts 10000-39999. Try and let me know. 

Userlevel 3

@jhouser thank you! I will try this and advise back.

Userlevel 3

I was still having issues and have opened a case with support. I’ll add what I learn here when we figure this out. But I’ve marked your reply as best answer @jhouser. I didn’t have issues creating customer groups for a client recently and thought it was fairly straight forward using A type restrictions. It seems like it should be very similar for this exercise. I’m not sure if there’s a build specific problem, or if it has something to do with the nature of system processing records (AR flows through that default subaccount). Any group, even just one, seems to restrict that subaccount or trigger errors, even if I make the group to specifically allow AR access to the subaccount. The only time I don’t have problems is if I turn off all GL groups (all my attempts). Then everything behaves the same as it does without ever trying to enable the groups.

Userlevel 5
Badge +1

@philr75 Okay, let me know what you can find, and if I can help further. 

Userlevel 3

@jhouser I just wanted to say thanks again for your help with this. We ended up discovering that the customer configuration is at times at odds with the rules I was trying to establish. Now I’m trying to convince the customer to allow me to clean up customer and vendor records where GL sub is trying to instruct the system to assign the very subaccount they want restricted. In testing it seems as if Acumatica first checks for GL restrictions regardless of what the masking rules are going to ultimately determine. I say this because when I shut the rules off, and run a transaction it didn’t ultimately use the default subaccount that the customer wants restricted. Yet with the rule on, I was getting errors that suggested the problem goes back to those customer GL subaccounts.

I’ve been looking for a simple visual that shows customers how the subaccount masking flows through the system, but I’ve been unable to locate anything useful. I know from the training materials that each module is looking to its preference section for direction but there isn’t anything I’ve found yet that defines an overall heirarchy and especially a visual. Do you know of anything helpful that I can put in front of a customer to help define how the process flows?


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved