Create Balance Groups and Usages

This example demonstrates how to create a balance group and balance group usage for a user-defined report of voluntary deductions.

Before You Begin

If you're creating a user-defined report, create a lookup code for the report in the PAY_BALANCE_REPORT_TYPE lookup.

  1. In the Setup and Maintenance work area, go to the Manage Common Lookups task.

  2. Search for and select the PAY_BALANCE_REPORT_TYPE lookup type.

  3. Add the lookup code, meaning, and description for the user-defined report in the Lookup Codes section.

How to Create a Balance Group

To create a balance group:
  1. On the Home page, click the Balance Groups quick action under the My Client Groups tab.

  2. Click Create to open the Create Balance Group dialog box.

  3. Select a legislative data group and enter a name for the balance group.

  4. Click Continue.

    The Balance Group Details page displays.

  5. Select Employee as the balance group level.

  6. Click Save.

  7. Select the Balance Definitions folder under the Balance Group Overview list.

  8. Click Select and Add.

  9. In the Select and Add: Balance Definitions dialog box, enter these values.

    Field

    Value

    Dimension Name

    Relationship Run

    Category

    Voluntary Deductions

  10. Click Search.

  11. In the Results section, select the balance definitions that you want to add and then click OK.

    Tip:

    You can select multiple balance definitions in the Select and Add window. Hold down the Shift key to select a group of consecutive balance definitions. To select individual balance definitions hold down the Control key and select the balance definitions that you want to add to the balance group. Click Apply and keep the dialog window open to add the query to search the selected balance definitions . Click OK to add the selected balance definitions and close the dialog window.

  12. Click Submit.

  13. Click Done.

How to Create a Balance Group Usage

To create a balance group usage:
  1. On the Home page, click the Balance Groups quick action under the My Client Groups tab.

  2. Click Create .

  3. In the Create Balance Group Usage dialog box, complete the fields as shown in this table.

    Field

    Value

    Legislative data group

    Enter the same LDG as the balance group for which you're creating the usage.

    Name

    Employee voluntary deduction run balances

    Balance Group

    The group you created in the previous task

    Format Type

    Table

  4. Click Continue.

    You're returned to the Balance Group Usage Details page.

  5. Select the report type (this was the report type that you added as a lookup code to the PAY_BALANCE_REPORT_TYPE lookup).

  6. Click Save.

  7. Select the Sorting folder under Balance Group Usage Overview list.

  8. From the Actions drop down list on the right, select Create.

  9. Enter these details.

    Field

    Value

    Name

    Any

    Sort Method

    Name

    Sort By

    Balance Type

    Order

    Ascending

  10. Click Save.

  11. Click Done.