Skip to main content
Administrator Guide
Last Updated: 2023-06-23
FAQ: Pay Balance Reports

FAQ: Pay Balance Reports

How can I include all results for the
As Of
option on my custom pay balance reports?
You can include an
As Of
option when creating a custom pay balance report. Your
As Of
option defaults to the beginning of the day (00:00:00). Example: You enter 2020-03-31 for the
As Of
option. Workday uses the beginning of the day (00:00:00) as the default time and excludes all results for 2020-03-31.
If you select
Include Results Processed By
on the
Field
column when creating the custom report, you can select 1 of these options on the
Default Type
column:
  • Determine default value at runtime
    : you can select
    Today (End of Day)
    on the
    Default Value
    column.
  • Specify default value
    : you can select today's date and end of day time, use 23:59:59 on the
    Default Value
    column.
Workday returns no data when you use an
As Of
option before the balance period start date.
How can I get my custom reports to return results for the
Include Results Processed By
field?
When you select
Include Results Processed By
on the
Field
column, Workday uses the beginning of the day (00:00:00) as the default time and excludes all results for that day.
To include results for the entered date, use 1 of these report fields as the
Default Value
column for the
Include Results Processed By
field:
  • Equal to As of Date
    : Workday automatically uses the entered
    As Of
    date instead of the current date and time.
  • Today (End of Day)
    : Workday automatically uses the current date and end of day time (23:59:59).
How can I use balance periods that are based on the period schedule, not
As Of
date, in my custom reports?
Add the
Reference Period for Balance
prompt to your report.
Example: From the
Reference Period for Balance
prompt, select a period schedule within January 2020 such as
01/02/2020-01/08/2020 (Weekly (Mon-Sun)).
The monthly balance period calculates the month of January 2020. Workday then only returns results with a period end date between 2020-01-01 and the specified
As Of
date 2020-01-01.
How can I maximize the performance of my custom pay balance reports?
To reduce calculation time, use a data source that has
Payroll Result Lines
as its primary business object. For best performance, use an indexed data source.
Which standard reports display pay balance information?
You can run these reports to see pay balances:
  • Pay Balance Summary
    .
  • Pay Calculation Results - Outstanding Arrears Balance Composite
    .
  • Pay Calculation Results Summary
    .