Skip to main content
Administrator Guide
Last Updated: 2026-03-13
Steps: Set Up Settlement Run Advanced Filters

Steps: Set Up Settlement Run Advanced Filters

To set up advanced customer refund filters, opt in to the Customer Refunds Optimization feature. See Steps: Create Customer Refund Payments in Settlement Runs.
You can create an advanced filter based on a custom report to use for selecting open supplier invoices or miscellaneous payment requests in settlement runs. Advanced filters enable you to use report fields and other reporting functionalities to filter payable documents with more granularity.
  1. Copy standard reports for advanced settlement run filtering. See Reference: Standard Reports for Settlement Run Advanced Filters.
    The report data source enables you to configure the report definition as a settlement run report filter.
  2. Edit your custom reports to configure filter conditions with delivered and calculated fields. The filter uses these conditions to return the open items that you want to select for settlement.
    Example: You create a condition to evaluate the discount due dates for your supplier invoices against a date range. When you schedule a daily settlement run, this filter condition selects only the invoices with a discount due date that's 2 to 3 days from the payment date.
  3. Access the
    Create Settlement Run Report Filter
    task.
    Create a settlement run filter using 1 of the available reports for your selected payment source.
    Security: These domains in the Banking and Settlement functional area:
    • Process: Settlement
    • Set Up: Settlement
  4. (Optional) Run your custom report to preview the open items that Workday will select in the settlement run.
You can select your new report filter on the
Auto Select Filters
prompt when you:
  • Create a settlement run manually using the
    Create Settlement Run
    task.
    The filter provides a starting point for the open payments to include in the run. You can add and remove payments as necessary.
  • Schedule a settlement run using the
    Schedule Settlement Run
    task.
    The filter defines the open payments to include in the settlement run. To capture different payments, edit this filter.