Example: Set Up Custom Validations on Billable Project Transactions
This example illustrates how to set up custom validations on billable project transactions.
You want to prevent the need for invoice adjustments that result from project billers omitting data when they modify billable project transactions:
- When project billers modify amounts to bill, they sometimes forget to include an adjustment reason. You want to ensure that users select aRevenue Adjustment Reasonwhen theAmount to Billdoesn't match theBillable Amount.
- Since your organization posts adjustment amounts to a different ledger account, you also want to ensure that users select aRevenue Adjustment Reasonwhen they change theTotal Amount to Billon the summary screen of theManage Project Billing Transactionstask.
Security:
Set Up: Custom Validations
domain in the Common Financial Management and System functional areas.- Access theMaintain Custom Validationstask.Create a validation on the summary screen of theManage Project Billing Transactionstask.
- In the sidebar, select theProject Billing Transaction Summarytransaction type.
- In the grid, clickNew Validation.
- In theDescriptionfield, enterSelect an Adjustment Reason. The New Total Amount to Bill is different to the amount from transactions that are ready to bill.Workday displays this message to users when the validation triggers.
- In theCommentfield, enter an explanation of the validation logic:Triggers when the value in New Total Amount to Bill is different to the value in Total Amount to Bill from Ready to Bill Transactions and Adjustment Reason is empty. Requires the user to select an Adjustment Reason.
- In theRule Conditionsgrid, select these values:And/OrSource External Field or Condition RuleRelational OperatorComparison TypeComparison ValueAndNew Total Amount to Billnot equal toValue from another fieldTotal Amount to Bill from Ready to Bill TransactionsAndRevenue Adjustment Reasonis empty
- ClickOK.
- Stay on theMaintain Custom Validationstask.Create a validation on the details screen of theManage Project Billing Transactionstask.
- In the sidebar, select theProject Billing Transaction Detailstransaction type.
- In the grid, clickNew Validation.
- In theDescriptionfield, enterSelect a Revenue Adjustment Reason. The Amount to Bill is different to the Billable Amount.Workday displays this message to users when the validation triggers.
- In theCommentfield, enter an explanation of the validation logic:Triggers when the value in Amount to Bill is different to the value in Billable Amount and Adjustment Reason is empty. Requires the user to select an Adjustment Reason.
- In theRule Conditionsgrid, select these values:And/OrSource External Field or Condition RuleRelational OperatorComparison TypeComparison ValueAndAmount to Billnot equal toValue from another fieldBillable AmountAndRevenue Adjustment Reasonis empty
- ClickOKandDone.
Test your validations on the
Manage Project Billing Transactions
task.