SOW Supplier Response Upload
This integration uploads supplier responses to statements of work.
File Formatting
Assumptions/Tips
-
This is buyer-side upload.
-
Successful upload will change the status of the SOW from Pending Response to Approved.
-
Both buyer- and supplier-entered Custom Fields will display and can be updated by both parties regardless of who created the Custom Field first.
-
For user entered amounts, a validation has to happen on the upload to ensure that the value entered is a whole number for those currencies requiring the precision to be zero decimals.
-
When SOW is Pending supplier review and Allow supplier to control SOW worker rules and create worker roles rule is enabled, this upload will be blocked.
-
This upload cannot be used for an SOW response for statements of work that use a Fieldglass Talent Network (FTN) SOW Type.
-
When company configuration SOW owner name updates on existing line items is enabled for SOW and upload changes SOW status from Pending Response to Approved and if the SOW Owner was changed, the new SOW Owner is updated on existing line items.
-
If this SOW revision reaches final response approval, the system re-evaluates the activity checklist to determine if there are additional activity items affected.
-
If Creation Type = Integration, this upload cannot be used.
-
Regarding leading and dependent custom fields:
When leading and dependent custom fields have been set up and a buyer downloads a blank upload template for this connector from the user interface, leading and dependent custom fields are automatically added as individual columns.
The system reads the value of the leading custom field and validates the first dependent custom field. This process continues for all dependent custom fields in the defined sequence until it is completed.
Configuration Considerations
|
# |
Item |
Notes |
|---|---|---|
|
1 |
External SOW ID |
In case the clients are using external ref or testing with external ref instead of SOW ID, then go to SA admin page, edit the bulk upload batch job for company, select the specific batch job ID, and change the column key from SOW ref. to external ref. Example: For “SOW Characteristic Upload”, it is ‘dbo.get_split_key(data, 1,''' + ''','''')' by default. Change 1 to 2 (column 2 is external ref column). |