How to create account sets
Entry Type: Informational
Product: FRx
Application: FRx Desktop
Version Reported: All
Subject:
How to create account sets.
Possible Resolution:
Create an account set by assigning a name to a group of accounts. This account set name can be used in multiple row formats.
When a change to the general ledger requires the account set to change, make changes to that set in one place only. For example, if a range of accounts is frequently used to link to the general ledger, assign this range in the account set name.
After creating an account set, select that set as the general ledger link. Existing account sets can also be grouped together into other account sets. This is called nesting account sets.
Account sets can be created from the 'Link to General Ledger' column, the Edit menu, or by right-clicking the mouse and selecting 'Account Sets'.
To create an account set from the 'Link to General Ledger' column:
- Select File / Open / Row. Select a row.
- Double-click the 'Link to General Ledger' column to open the 'GL Account Links' dialog.
- Select the desired accounts, and click the 'Save As' button in the 'Account Sets' section.
- Type the name and description for the account set, and click 'OK'.
In the 'GL Account Links dialog box, the word "SET" followed by the account set name displays. For example: +SET(Expense)
To create an account set using the Edit menu or right-click:
- Select File / Open / Row. Select a row.
- Select Edit / Account Sets, or right-click and select 'Account Sets'.
- If there are no existing account sets, click the 'OK' button at the prompt, "No Account Sets currently exist. Adding new record." If there are existing account sets, click the 'New' button.
- Type a name for the account set in the 'Account Set Name' field.
Note: The account set name entered here appears in the 'Link to General Ledger' column of the 'Row Format' window. - Type a description for the account set in the 'Description' field.
Note: The description entered here appears in the 'Description' column of the 'Row Format' window. - Select desired accounts.
- Click the 'Save' and 'Close' buttons.
After the account set us created, it is available in the 'Link to General Ledger' column.
To link an account set to the general ledger:
- Open File / Open / Row. Select a row.
- Double-click the 'General Ledger' column to open the 'GL Account Links' dialog.
- Select the 'Acct Set' check box to change the account set indicator to "Yes".
- Double-click a cell in the 'From Account' (range), 'Individual Account' or 'Account Set' column.
- From the 'Select Account Set' dialog, select an account set, and click 'OK'.
The selected account set appears in the 'Link to General Ledger' column and the account set description appears in the 'Description' column.
To edit an account set from the GL Links dialog box:
- Select the account set name.
- In 'Account Sets' section, click the 'Edit' button.
- Enter the desired changes to the account set.
- Click the 'Save' and 'Close' buttons.