Solved

GL Access Account/SubAccount interaction question

  • 10 April 2024
  • 4 replies
  • 30 views

Userlevel 3
Badge

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? 

icon

Best answer by jhouser 14 April 2024, 23:31

View original

4 replies

Userlevel 4
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
Badge

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

Userlevel 3
Badge

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 4
Badge +1

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

Reply


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