1. How do I configure HCM Extracts for payroll balance reporting?
  2. Create a Balance Group and Balance Group Usage for Employee Balances Reporting

Create a Balance Group and Balance Group Usage for Employee Balances Reporting

Before you create an extract definition for extracting and reporting employee balances, you must create these payroll objects.

  1. Balance Group to include the balance definitions and dimensions you can use to retrieve balances for the employee.
  2. Balance Group Usage to represent how the balance group is used.

Create a Balance Group

Complete these steps to create a Balance Group.
  1. Navigate to the Balance Groups quick action under the My Client Groups tab. on your Home page.
  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, for example, Employee Balance ABC.
  4. Click Continue.
  5. On Balance Group Details page 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 Gross Earnings in the Name field.
  10. Select All in the Match field and click Search.
  11. In the Results section, select the row that has, for example, the following values.
    • Dimension Name: Assignment Tax Unit Run
    • Category: Total Standard Earnings
  12. Click Apply and OK.

Create a Balance Group Usage

Complete these steps to create a Balance Group Usage.
  1. Navigate to the Balance Group Usage quick action under the My Client Groups tab. on your Home page.
  2. Click Create to open the Create Balance Group Usage dialog box.
  3. Select a legislative data group and enter a name for the balance group usage, for example, Employee Balance Usage ABC.
    Note: Enter the same LDG as the balance group for which you're creating the usage.
  4. Select a Balance Group. Select the group you created in the previous task, for example Employee Balance ABC.
  5. Select Matrix in the Format Type field.
  6. Click Continue. You're returned to the Balance Group Usage Details page.
  7. In the Report Type field, select Statement of Earnings.
  8. Select the Matrix Items folder under the Balance Group Usage Overview list and add balance dimensions that you want.
    Note: Matrix Item node is enabled only for Matrix format type. Use this node to specify the display position of the balance value for a particular balance dimension. If you put several dimensions in the same position their values are summarized together in the group.
  9. Complete the fields as given here:
    • Select Balance Dimensions as the Matrix Item Type.
    • Search and select the Name as Assignment Tax Unit Run.
    • Enter 1 in the Position field.
  10. Click Save.
  11. Select the Sorting folder under the Balance Group Usage Overview list. Sorting determines the order in which the balance values in a balance group are displayed.
  12. Click Actions > Create.
  13. Complete the fields as per your requirement. Sort Items table defines the static sort order in which the balance values in a balance group are displayed and it's enabled only for sort method of Static Order. It might be sort by either Balance Type or Defined Balance.
  14. Click Save and then Submit.