Restrict sub-account access by account or account class

Hi ​@jweber 

Standard Acumatica can restrict access to GL Accounts and Subaccount Segment Values through Restriction Groups. However, it cannot dynamically restrict which Subaccounts can be selected based on the Account or Account Class during transaction entry. If you need to enforce specific Account–Subaccount combinations (for example, Balance Sheet accounts must use only 000-000), a customization or validation logic is required.

If customization is not an option, a Generic Inquiry can be used to identify invalid Account–Subaccount combinations for review before period-end closing. Such as:
+ Balance Sheet Account AND Subaccount <> 000-000
+ P&L Account AND Subaccount = 000-000
Accounting can then review and correct these transactions before closing the accounting period.

Best Regards,

NNT

Hello,

I disagree with some of what previous poster stated posted above. 

It’s true we cannot restrict on Account Group. 

Subaccount visibility can be tied to GL Accounts using Restriction groups.  Here is a snip from Help.Acumatica.com:

I recommend using Balance Sheet as restriction group name, with a list of Balance Sheet accounts tied to 000-000. If 000-000 can be used with some income/expense, in certain situations but not in all situations, then you may still find mistakes in this area, because you can’t restrict when all subaccounts could be used with an account.

Did you already use the Default Subaccount checkbox on the Chart of Accounts with 000-000 entered as Default Subaccount in GL Preferences, to default balance sheet subaccounts to 000-000 on all data entry screens?  Default subaccount configuration is an easy way to reduce errors - though some users may elect to change it (retrain them).

Good luck!

Laura