Account Sets

An account set is a record that combines general ledger account and dimension values into one string. Typically, an account set is used for the following purposes:

  • Ease of entry: Account Sets help users enter the general ledger account and dimensions on a line. To use account sets for data entry, you must configure them.

  • Validation: You can validate the entered general ledger account and dimensions against a predefined set of allowed combinations that are configured through the account sets. Validation is enabled by document type on the Dimension Validation Setup page.

To view the Account Sets page

Choose Lightbulb that opens the Tell Me feature., enter account sets, and then choose the related link.

The Account Sets page opens.

Create account sets

You can configure account sets as a combination of general ledger account and all or only some dimensions. You can also configure account sets as a combination of general ledger account and a combination of dimensions.

To create an account set

  1. Choose Lightbulb that opens the Tell Me feature., enter account sets, and then choose the related link.

    The Account Sets page opens.

  2. On the action bar, choose New.

    A new row appears.

  3. In Code, specify a code to represent the account set.

  4. In Description, specify a description for the account set.

  5. To block an account set, select the Blocked checkbox.

  6. To make the account set available on purchase requisitions, payment requests, and expense claims, select the Available on Finance Requests checkbox.

  7. In Account No., specify the account number for the account set.

  8. To make the account set available on cash receipts, select the Cash Receipts checkbox.

  9. Specify values for other fields as required.

Copy Account Sets

To create account sets using a single filter for one or more of the dimensions, use the copy dimensions feature. For example, a school board opens up a new school and wants to create the same account set records for the new school using the data that is currently setup for an existing school.

Note

Note:
If you filter the Account Sets page, these filters are applied to the Copy Accounts Sets page.

To copy an Account Set

  1. Choose Lightbulb that opens the Tell Me feature., enter account sets, and then choose the related link.

    The Account Sets page opens.

  2. On the action bar, choose Copy.

    The Copy Account Sets page opens.

  3. On the Filter FastTab, specify values to filter the account sets that you want to copy.

  4. On the Copy To FastTab, specify the new dimension values for the copied dimensions.

  5. On the Account Set Delimiter FastTab, perform the following steps:

    1. In Delimiter, specify the character that is to be used to separate dimensions in an account set.
    2. In Select Segment, specify the location of the dimension that you want to copy.

  6. Choose OK.

Example

A series of account sets exist where Department=Prod, Program=Medium, and Fund=003.

You want to copy these account sets and change the Program=Large.

Feedback

To send feedback about this page, select the following link:

feedback-product-docs@sparkrock.com