Skip to main content
Administrator Guide
Last Updated: 2024-05-17
Reference: Tenant Configuration Guidelines for Custom Reporting

Reference: Tenant Configuration Guidelines for Custom Reporting

This table includes tenant configuration guidelines that Workday recommends for custom reporting.
Issues
Causes
Configuration Guidelines
You’re noticing poor performance when creating custom reports using the
Last Updated Moment
report field with these filters:
  • Greater Than
  • Greater Than or Equal to
  • Lesser Than
  • Lesser Than or Equal to
  • Equal to
You're using 1 of these report data sources and filters combinations:
  • Journal Lines for Financial Reporting
    report data source with
    Journal Lines for Company and Reporting Time Period
    data source filter.
  • Journals
    data source with
    Journal Filter
    data source filter.
When creating custom reports:
  • Replace the data source with
    Journal Lines
    report data source.
  • Replace the data source filter with
    Journal Line Filter with Last Updated in Date Range
    data source filter.
See Create Custom Reports.
You're noticing poor performance when creating custom reports.
You may be using non-indexed report fields.
Ensure you are using the available indexed report fields for the custom reports.
A custom report that you’ve created to review accounting adjustments and prepaid amortizations on invoices is not displaying these fields:
  • Amortization Schedule
  • Prepayments Amortized
You're using the
Prepaid Amortization Installment Lines
report field.
Use the
Prepaid Amortization Installment Lines on Supplier Invoice
or the
Accounting Adjustment Line
report field.
You're getting an incorrect balance when running a trial balance for more than a single reporting period.
You may be running a composite trial balance by selecting Repeating Column Group as period.
Workday doesn’t support using Repeating Column Group for period mapping over multiple fiscal years.
Instead of using the Repeating Column Group, copy the columns for the report and hard code the year on the sub report prompt to have the time period equal to the previous or prior year.
Example: You want to create trial balances for 3 years using the Time Period prompt. Create the layout of the report and copy each column on the report 2 times. For each year that you copy, change the Beginning Balance time period to
Last Year – Current Period
.