Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: All Pay Component Totals by Periods

Example: All Pay Component Totals by Periods

After completing payroll, you need to audit the pay component totals to verify that the totals match with outside deduction reports. You want a report that sums all pay component totals by a single or multiple periods.
Security:
Custom Report Creation
 domain in the System functional area.
  1. Access the
    Create Custom Report
     task.
  2. Enter these values:
    Option Description
    Report Name
    All Pay Component Totals for Period(s)
    Report Type
    Advanced
    Optimized for Performance
    Cleared
    Data Source
    Payroll Result Lines
  3. Click
    OK
    .
  4. Confirm that the
    Data Source Filter
     is
    Pay Calculation Result Lines for Pay Group and Period (As of Sub Period End Date)
    .
  5. On the
    Columns
     tab, enter these values:
    Business Object
    Field
    Column Heading Override
    Options
    Payroll Result Line
    Pay Component Code
    Code
    Payroll Result Line
    Pay Component Name
    Description
    Payroll Result Line
    Pay Component Category
    Category
    Payroll Result Line
    Result Line Amount (Indexed)
    Amount
    Sum
  6. On the
    Sort
     tab, enter these values:
    Field
    Sort Direction
    Summarize Detail Rows
    Pay Component Code
    Alphabetical - Ascending
    Pay Component Name
    Alphabetical - Ascending
    Pay Component Category
    Alphabetical - Ascending
    Selected
  7. On the
    Prompts
     tab, select the
    Display Prompt Values in Subtitle
     check box.
  8. Enter these values on the
    Prompt Defaults
     grid:
    Field
    Prompt Qualifier
    Default Type
    Required
    Do Not Prompt at Runtime
    Pay Run Groups and/or Pay Group Details
    No default value
    Selected
    Periods
    No default value
    Selected
    Organizations
    No default value
    Selected
    Payroll Off-cycle Type
    Default Prompt
    No default value
    Selected
    Worker
    Default Prompt
    No default value
    Selected
    Include Subordinate Organizations
    No default value
    Selected
  9. On the
    Output
     tab, select
    Chart and Table
     from the
    Output Type
     prompt.
  10. In the
    Chart Options
     section, enter these values:
    Option Description
    Chart Type
    Donut
    Top n Values
    50
    Categories (for label)
    Pay Component Name
    Series (for legend)
    Result Line Amount (Indexed)
  11. On the
    Share
     tab, select the
    Share with specific authorized groups and users
     option.
  12. Select
    Payroll Administrator
     and
    Payroll Partner
     from the
    Authorized Groups
     prompt.
  13. Click
    OK
    .
  14. Make sure that the Payroll Administrator and Payroll Partner user groups have security access to the
    Reports: Pay Calculation Results for Pay Group (Results)
     domain in the Core Payroll functional area.