Setup Considerations: Settlement Run Filters
You can use this topic to help make decisions when planning your configuration and use of settlement run filters. It explains:
- Why to set them up.
- How they fit into the rest of Workday.
- Downstream impacts and cross-product interactions.
- Security requirements and business process configurations.
- Questions and limitations to consider before implementation.
Refer to detailed task instructions for full configuration details.
What It Is
Workday settlement run filters automatically add unpaid open items and pending payments that meet specified criteria to a settlement run.
Business Benefits
With Workday settlement run filters, you can:
- Reduce errors and manual effort.
- Identify specific unpaid open items and pending payments quickly and easily.
Use Cases
Workday provides predefined system filters for common settlement run scenarios, such as
All Available Ad Hoc Payments
and Due in Next 7 Days
. If predefined filters don't fit your use case, you can set up custom filters. Example: You create a custom filter that identifies all ad hoc payments with check as the payment type.
If you need more granular selection criteria, you can set up advanced filters based on custom reports that return payable documents to settle. Advanced filters enable you to use delivered and calculated report fields as additional search criteria for filtering on specific items. Example: You build a custom report for filtering on supplier invoices with a nonstandard payment term. You use a report field condition to define the term as a variable number of days depending on the length of each month.
Questions to Consider
Questions | Considerations |
|---|---|
What payment sources do you need filters for? | Workday delivers system filters for all payment sources.
You can create custom filters for any payment source. You can add 1 or more payment sources to a single custom filter. You can set up advanced filters for these payment sources:
|
What happens when you select multiple filters in a single settlement run? | Workday retrieves data for each selected filter. The selected filters don't interact with one another.
Example: You select 2 filters in a single settlement run, All Available Ad Hoc Payments and Due in Next 7 Days . As a result, Workday returns all available ad hoc payments as well as everything due in the next 7 days. |
Recommendations
When you have recurring open items or pending payments to settle, Workday recommends automating this process by adding settlement run filters to scheduled settlement runs.
Requirements
No impact.
Limitations
- You can't delete custom filters.
- You can only use advanced customer refund filtering options when you opt in to the Customer Refunds Optimization feature. See Steps: Create Customer Refund Payments in Settlement Runs.
Tenant Setup
No impact.
Security
Domain | Considerations |
|---|---|
Process: Intercompany Payment/Settlement in the Financial Accounting functional area. | Provides access to perform settlement for intercompany payments and view related reporting. |
Process: Miscellaneous Payment Request Settlement in the Banking and Settlement functional area. | Provides access to miscellaneous payment request reporting. |
Process: Payroll Settlement in the Core Payroll functional area. | Provides access to settle payroll payments, create checks, and print advices. |
Process: Settlement in the Banking and Settlement functional area. | Provides access to:
|
Process: Supplier Invoice Payment/Settlement in the Banking and Settlement functional area. | Provides access to supplier invoice reporting. |
Set Up: Settlement in the Banking and Settlement functional area. | Provides access to create and edit custom and advanced filters. |
Business Processes
No impact.
Reporting
Workday delivers standard reports that you can copy to build custom reports for advanced settlement run filtering. See Reference: Standard Reports for Settlement Run Advanced Filters.
You can also use these report data sources (RDS) and filters to build custom reports for advanced settlement run filtering:
Report Data Source | Report Data Source Filter | Considerations |
|---|---|---|
Customer Invoices
| Open Customer Invoices for Settlement Filter | Displays open customer invoices that are valid for payment. |
Customer Refunds
| Open Customer Refunds for Settlement Run Filter | Displays open customer refunds that are valid for payment. |
Intercompany Transactions
| Open Intercompany Items for Settlement Run | Displays open intercompany items that are valid for payment. |
Miscellaneous Payment Request
| Open Miscellaneous Payment Requests for Settlement | Displays all open miscellaneous payment requests that are valid for payment. |
Open Pay Groups for Settlement Run
| Open Pay Groups for Settlement Run | Displays on-cycle payroll payments that are valid for payment. |
Payments for Company
| Open Pay Group Exceptions for Settlement | Displays off-cycle payroll payments that are valid for payment. |
Supplier Invoices
| Open Supplier Invoices for Settlement | Displays all open supplier invoices that are valid for payment. |
Integrations
You can use these web services to mass retrieve and upload custom filters through the Enterprise Interface Builder (EIB):
- Get Settlement Run Custom Filter
- Put Settlement Run Custom Filter
Connections and Touchpoints
Features | Considerations |
|---|---|
Cash Advance
Customer Invoice Customer Refund Expense Credit Card Transaction Expense Report Intercompany Item Miscellaneous Payment Request Procurement Card Transaction Student Payment Student Refund Student Sponsor Refund | Workday creates and settles these payments. The payment date is the settlement date. |
Supplier Invoice
| Workday creates and settles these payments. By default, the payment date is the settlement date. You can enable dynamic supplier payment date to match supplier payment dates dynamically based on:
|
Ad Hoc Payment
Bank Account Transfer for Settlement Customer Payment Customer Refund On-Cycle Payroll Pay Group Exception Pay On-Demand | Workday settles the existing payments. The payment date derives from the transaction itself and the settlement date doesn't have any bearing. |
Workday offers a Touchpoints Kit with resources to help you understand configuration relationships in your tenant. Learn more about the Workday Touchpoints Kit on Workday Community.