You can create and update supplier child contracts:
1. manually one by one, by filling in the SCOT contract creation form
2. via mass upload using Excel template file
1. Manual contract creation
1) Go to Penalization Contracts > Child Contract.
2) Search for the needed supplier number. If you cannot find it or need to create a new contract with different parameters (e.g. different validity period, different Buying Domain ID), click on the Create Child Contract button.
3) Fill in the needed information (red asterisk marks mandatory fields) then click on the Add button.
- Mandatory fields are marked with a red asterisk
- Fields contain instructions regarding data format or action to take
e.g. OTIF Target: 0.05 is Equal to %%
- Use commas, without spaces, to separate multiple email IDs
e.g. email@email.com,example@example.com
2. Mass contract upload
1) Go to the three-dot menu and select Export Mass Contract Template.
2) An Excel file is downloaded to your computer. This is the Contract Template that you need to fill in for the contract mass upload.
- The headers of the columns contain relevant information which helps you fill in the needed data
- Do not change the original cell format (e.g. General, Text should remain as they are)
- Use the default decimal separator (dot or comma) of your system.
e.g. 0.98 OR 0,98
- In SCOT, consult the guide available when clicking on Info button Click here to view contract template guide. It will show you the mandatory fields for your country as well as explanations on how to fill in certain fields of the Excel contract template.
Fill in the Excel template and save it. Make sure it is NOT Restricted.
3) In SCOT, click on the Upload Mass Contracts (Excel) button. Read the instructions and follow the steps to upload the Contract Template Excel to SCOT.
3) After clicking Upload, a green message is shown indicated the successful file upload. Contracts are now being processed in the system.
4) Click on Refresh to check the status. The grid will show relevant information as well as a Result Excel file explaining the possible errors in case not all records could be processed by the system. This way, you can correct them in the original Contract Template Excel and re-upload it to SCOT. Processed records are marked with "Success".
5) To check if all is good, you can search for some supplier numbers and see their contract data on the right side of the page. Or you can search for the needed supplier numbers and extract their contract data in Excel from the three-dot menu > Export Excel option.
