Fee Response Update Upload
This integration uploads fee responses or revised fee responses.
File Formatting
Assumptions/Tips
-
For multi-line handling, records are grouped with keys as Statement of Work ID + External SOW ID + Fee Response ID, creating a single Response with multiple line items using the multi-line group keys, if the respective multi-line configuration rules are met.
-
For a single response with multiple line items, line items provided in the upload file are only considered and the missing line-items from the previous response are not carried forward if they are not provided in the upload file.
-
Both Buyer and Supplier entered Custom Fields will display and can be updated by both parties regardless of who created the Custom Field first.
-
When Fee Availability on SOW flag is set to Available for Associated Suppliers, if a supplier is not selected/associated to a particular fee in the library, that fee will not be available to copy on an SOW, irrespective of who is adding the fee (buyer or supplier).
-
A revision is determined if the Fee Response ID is in invoiced status.
-
Supplier can use this upload to revise fee response holdback.
-
Since a CSOW can have different currency than a MSOW, each line item amount on the CSOW will be converted to the MSOW's base currency using the conversion factor already captured on the CSOW, and then will be validated against MSOW budgets.
-
Upload will allow Fees whose Start & End Date match with the Fee Response's Effective Date and have Enable Effective Fee Period flag set to Yes. No validation on dates for fees that have Enable Effective Fee Period flag set to No.
-
Enabling the rule 'Allow Supplier to Edit Value' allows the supplier to modify the value of the affected adjustments in an adjustment group.
-
If Can select a subset of Fees and Roles, and alter the Rates, but cannot add new Fees and Roles rule is enabled on a MSOW, the user will be able to use any fees currently on the CSOW.
-
When company configuration SOW owner name updates on existing line items is enabled for the SOW and the SOW Owner has been updated, and when Fee Response ID is in Invoiced status and a Revision is created, the new SOW Owner is reflected on the revised Fee.
-
If the SOW Type/Template flag Set Fee response / revision attachments as mandatory is set to Yes, then the user must add an attachment before submitting the Fee Response.
-
When account category is unknown, the cost center name cannot be Unknown during the buyer submit or approve action on the document. The account category and related cost center must be chargeable.
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). |