Bulk Update Statements of Work with File
Have the
sow.bulk.update
and sow.edit
permissions.Note
: If you don’t have the sow.edit
permission for any of the statements of work (SOWs) in the file, the update fails for those SOWs.The Bulk Update SOWs With File feature enables you to add payments and roles to
Active
SOWs by uploading a CSV file. You can use this feature to save time and reduce the manual effort needed to update multiple SOWs at once. Note
: For the bulk update to succeed, the SOWs that you include in the file must meet these criteria: - Must have anActivestatus.
- Cannot have any change orders currently in progress.
- Must already be configured with the payment types for the payments you want to add.
- Must have planned dates and budgets that align with the dates and amounts that you indicate in the file.
- From the header, select .
- ClickNew Bulk Update.
- ClickBulk Update SOWs With File.
- Complete theSelect Recordspage.
- ClickNext.
- (Optional) Complete theGenerate Templatepage:Note: You can also create your own CSV file to upload. For information about all the fields you can include in the file, see the specification file linked in the Statement of Work - Active SOW Payments and Roles Import section of the Workday VNDLY File Import Specifications page on Community.OptionDescriptionSelect a payment typeSelect the type of payment that you want to include in your bulk update template. You can only select 1 payment type per bulk update file.If you selectMilestoneorFixed Priceand theEnable payment allocation between multiple charge codes for Fixed Price/Milestone Paymentssetting is enabled in your tenant, the template will include fields for payment allocation. See Bulk Actions for Fixed Price and Milestone Payments with Multiple Charge Codes.Generate TemplateorExport # records to fileIf you click:
- Generate Template, Workday VNDLY creates a blank template.
- Export # records to file, Workday VNDLY creates a template that is automatically populated with SOW IDs based on criteria you selected on theSelect Recordspage.
- ClickNext.
- Complete theUpload Filepage:OptionDecriptionUpload FileSelect your CSV file.Payment TypeSelect the type of payment you want to add to the SOWs.Skip Approvals(Optional) Select this check box if you want to skip all approvals for the change orders that Workday VNDLY will create for the bulk updates. To do this, you must have thesow.bulk.skip_approvals permission.If you don’t select this check box, any internal approvals that your program has configured will be required on the change order. However, vendor approvals will not be required.Reason for Change OrderThis reason will display on the change orders that Workday VNDLY creates for the bulk updates.If you selectOther (Please Specify), you must enter a reason in theCommentsfield.Reason for Bulk UpdateThis reason will display in theDescriptioncolumn on theBulk Updatespage.
- ClickNext.
- Verify the details on theUpdatepage.
- ClickConfirm Bulk UpdateandConfirm.
Workday VNDLY validates the bulk update file and displays the results.
When the validations are successful, Workday VNDLY:
- Creates change orders for the successful SOWs.
- Triggers internal approvals for the change orders, unless internal approvals aren’t configured or you selectedSkip Approvals.
- Creates invoice line items for payments in theApprovedstatus and updates budget amounts accordingly, once the change orders are approved.
- Adds the payments or roles to the associated tabs on the SOW, once the change orders are approved.
Workday VNDLY doesn’t create change orders for SOWs that failed the validations.
You can click
View Bulk Update Results
or go to the Bulk Updates
page () to view more details about the update, including any errors that occurred.