Here is the scenario I ran into:
A client wanted to lock down certain chart of accounts that were used with subledgers such as Accounts Payable, Accounts Receivable, Inventory, etc.
The Solution
In Acumatica version 2020R1, a cool new feature allows you to define certain accounts in the chart of accounts to be used as control accounts. A control account is a general ledger account that aggregates the balances of entities in a subledger.
The following control accounts can be set up:
In the chart of accounts screen (GL202500), you set the control Account Module against an account. With this setup, users cannot post transactions directly to a control account. If you try to select a control account in a box or column where the system expects a non-control account to be selected an error occurs.
In the same screen (GL202500), you can allow direct posting to the control account by selecting the Allow Manual Entry check box in the settings of the account. With this check box selected for the control account, if you select the control account in a box where a non-control account should be selected, the system displays a warning instead of an error.
A control account cannot be selected as a cash account. The Cash Account check box is unavailable for accounts for which a subledger is selected in the Control Account Module column.
Similarly, you cannot select a cash account as a control account. That is, if the Cash Account check box is selected for an account, the Control Account Module column is unavailable.
A non-control account can be selected in a lookup box in which the system expects a control account to be selected. In this case, the system displays a warning that this account is not configured as a control account.
Should you have any questions or help with this feature please contact us.
Shah.