What is the best way to associate (restrict) Subaccounts with GL Accounts and/or to restrict some Subaccounts from being used in certain circumstances

Hello ​@Bob Stewart ,

Restriction Groups (Link) may be used to connect valid Account-Subaccount combinations.

Laura

Hey ​@Bob Stewart 

Not sure if you’ve received an answer to this yet but Acumatica does not natively enforce strict GL Account ↔ Subaccount pairing rules, but you can control usage through configuration and (if needed) validation logic.

For Balance Sheet vs. P&L usage, the typical approach is to use Account Classes. Place Balance Sheet accounts in a dedicated class and default the 000-000 subaccount there. Income statement accounts (COGS, revenue, operating expenses) can default to other subaccounts such as the 000-00# overhead structure. This guides correct usage even though users can still override it.

For Project transactions, use Account Groups in Project Accounting. Only accounts tied to an account group can be used on project transactions, so you can restrict projects to “direct” accounts (COGS/revenue) that pair with the #00-000 subaccounts (100-000, 200-000, etc.). Balance Sheet or overhead accounts would simply not be assigned to project account groups.

If you need hard enforcement—for example preventing 000-000 from being used with non-Balance Sheet accounts or restricting #00-000 subaccounts to projects only—that generally requires a custom validation or workflow rule that checks the account/subaccount combination during entry.

Thank you!

​@Bob Stewart no problem!