Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Reference: Settlement Run Custom Filters

Reference: Settlement Run Custom Filters

You can use the
Create Settlement Run Custom Filter
 task to create custom filters for settlement runs. You can edit these filters using the
Edit Settlement Run Custom Filter
 task.

Fields

Option
Description
From Current Date In (Days)
Includes everything between the current date and the number of days in the future that you enter in the field.
Up to Current Date In (Days)
Includes everything between the current date and the number of days in the past that you enter in the field.
Invoices Due In (Days)
When you enter a positive number in this field, Workday includes all invoices that are:
  • Past due up to the settlement run date.
  • Past due up to the number of days in the future from the settlement run date. Example: If the settlement run date is 12/30/21 and
    Invoices Due In (Days)
     is
    3
    , then the custom filter includes all invoices that are due up to 01/02/22.
When you enter a negative number in this field, Workday includes all supplier invoices that are due up to the number of days in the past from the settlement run date. Example: If the settlement run date is 12/30/21 and
Invoices Due In (Days)
 is
-3
, then the custom filter includes all invoices that are due up to 12/27/21.
Expense Report Approval Dates Before Current Date In (Days)
Includes expense reports with approval dates that are a specific number of days in the past and older.

Common Scenarios

Scenario
Steps
Pay all outstanding expense reports each week.
  1. Select
    Expense Report
     on the
    Payment Source
     prompt.
  2. On the
    Expense Report Attributes
     section, select the
    All Open Expense Reports
     check box.
Pay outstanding expense credit card transactions on behalf of other companies.
  1. Select
    Expense Credit Card Transaction
     on the
    Payment Source
     prompt.
  2. On the
    Expense Credit Card Transaction Attributes
     section, select companies to include in the filter on the
    On Behalf of Company for the Payment
     prompt.
Pay your tier 1 suppliers before your tier 2 suppliers.
Create separate custom filters for your tier 1 and tier 2 suppliers.
  1. Select
    Supplier Invoice
     on the
    Payment Source
     prompt.
  2. On the
    Supplier Invoice Attributes
     section, select attributes on these prompts:
    • Supplier
    • Supplier Category
    • Supplier Group
Automatically run the settlement process nightly to pay supplier invoices due in the next 3 days. Include all expense reports and credit card transactions.
  1. Select these payment sources on the
    Payment Source
     prompt:
    • Supplier Invoice
    • Expense Credit Card Transaction
    • Expense Report
  2. On the
    Supplier Invoice Attributes
     section, enter 3 on the
    Invoices Due in (Days)
     field.
  3. On the
    Expense Credit Card Transaction Attributes
     section, select the
    All Available Expense Credit Card Transactions
     check box.
  4. On the
    Expense Report Attributes
     section, select the
    All Open Expense Reports
     check box.
Pay quarterly bonuses to salaried employees and control who you include in the settlement run.
Use this method if you've been experiencing time-outs when settling a high volume of off-cycle payments.
  1. Select
    Pay Group Exception
     on the
    Payment Source
     prompt.
  2. On the
    Pay Group Exception Attributes
     section, select
    Quarterly U.S. Bonus Pay Run Group
     on the
    Pay Run Group Selection
     prompt.
Pay supplier invoices based on their reference types.
  1. Select
    Supplier Invoice
     on the
    Payment Source
     prompt.
  2. On the
    Supplier Invoice Attributes
     section, select reference types on the
    Reference Type
     prompt.