Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
tender_management:tender_web_module_for_suppliers [2019/10/16 16:58] – [How to Finalise] Emily Porrello | tender_management:tender_web_module_for_suppliers [2022/09/29 10:25] (current) – [Preparing the quotation file] Ujwal Khatry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{indexmenu_n> | + | {{indexmenu_n> |
- | ====== | + | ====== |
===== Introduction ===== | ===== Introduction ===== | ||
This user guide explains how to use the web site at https:// | This user guide explains how to use the web site at https:// | ||
Line 71: | Line 70: | ||
The example shows that 4 tender documents from client Namaste Medical Stores, have been uploaded and await the supplier’s attention. | The example shows that 4 tender documents from client Namaste Medical Stores, have been uploaded and await the supplier’s attention. | ||
- | ===== The My Information button ===== | + | ===== My Information button ===== |
Clicking the **My Information** button displays this window: | Clicking the **My Information** button displays this window: | ||
{{ rtm_my_info.png? | {{ rtm_my_info.png? | ||
- | <WRAP center round important 60%> | ||
- | The above window may not display properly using the Google Chrome web-browser. If this is the case, then please use Firefox. | ||
- | </ | ||
This is where the supplier’s details held on the server are entered and stored, and this is also where they can be edited. | This is where the supplier’s details held on the server are entered and stored, and this is also where they can be edited. | ||
Line 89: | Line 85: | ||
**Inactivity time** This is the length of time in minutes after which you will be logged out if there is no activity. 10 minutes is the default but you can choose from between 1 and 60 minutes. | **Inactivity time** This is the length of time in minutes after which you will be logged out if there is no activity. 10 minutes is the default but you can choose from between 1 and 60 minutes. | ||
- | **Email me manufacturer list** As the name suggests, this will email an excel file with the complete list of manufacturer names and their corresponding codes to the email address specified. If you want to take advantage of the new facility to upload a quotation as an excel file, you will need to use the manufacturer codes specified in this list. | + | **Email me manufacturer list** As the name suggests, this will email an Excel file with the complete list of manufacturer names and their corresponding codes to the email address specified. If you want to take advantage of the new facility to upload a quotation as an Excel file, you will need to use the manufacturer codes specified in this list. |
{{tender_management: | {{tender_management: | ||
Line 119: | Line 115: | ||
**Reset lines button:** Removes any changes you have made to the selected quote lines. | **Reset lines button:** Removes any changes you have made to the selected quote lines. | ||
- | **Email me this quote button:** Sends you a copy of your quote as it currently stands. It will be sent to you as excel file attachment to an email. | + | **Email me this quote button:** Sends you a copy of your quote as it currently stands. It will be sent to you as Excel file attachment to an email. |
**Email me a quote template button:** Sends you a copy of the tender with all items included with no price or other information added. This is the perfect thing to use as a base for your quote if you are going to create it in a spreadsheet and upload it using the upload button (see below). | **Email me a quote template button:** Sends you a copy of the tender with all items included with no price or other information added. This is the perfect thing to use as a base for your quote if you are going to create it in a spreadsheet and upload it using the upload button (see below). | ||
- | **Browse button:** Allows you to select an excel file to upload as your quote. | + | **Browse button:** Allows you to select an Excel file to upload as your quote. |
- | **Upload button:** Uploads the selected | + | **Upload button:** Uploads the selected |
===== Entering prices ===== | ===== Entering prices ===== | ||
Line 139: | Line 135: | ||
**Price per pack** The unit price of the pack you are offering to supply in the chosen currency. | **Price per pack** The unit price of the pack you are offering to supply in the chosen currency. | ||
+ | <WRAP center round important 60%> | ||
+ | Cost Including Freight (CIB): The quoted price should include international freight charges. | ||
+ | </ | ||
**Expiry date and delivery time** When completing these fields, it is suggested that a series of abbreviations be used: | **Expiry date and delivery time** When completing these fields, it is suggested that a series of abbreviations be used: | ||
Line 181: | Line 180: | ||
| Universal Supplies | | Universal Supplies | ||
- | If you do not want to or cannot specify the manufacturer, | + | If you do not want to or cannot specify the manufacturer, |
**Country of Origin:** Some tenders require you to specify country of origin instead of manufacturer. Common countries are specified in the Manufacturer list, so you can just choose a country rather than a specific manufacturer if you wish. | **Country of Origin:** Some tenders require you to specify country of origin instead of manufacturer. Common countries are specified in the Manufacturer list, so you can just choose a country rather than a specific manufacturer if you wish. | ||
Line 196: | Line 195: | ||
This facility allows you to upload an *.xlsx file containing a header line and one or more item lines for your quotation. The template for the *.xlsx spreadsheet is provided with your invitation to tender. | This facility allows you to upload an *.xlsx file containing a header line and one or more item lines for your quotation. The template for the *.xlsx spreadsheet is provided with your invitation to tender. | ||
- | <WRAP center round info 60%> | + | <WRAP center round info 95%> |
As of August 2019, spreadsheets are now provided and to be uploaded in *.xlsx format.\\ | As of August 2019, spreadsheets are now provided and to be uploaded in *.xlsx format.\\ | ||
You can use Microsoft Office or the Free Libre Office. | You can use Microsoft Office or the Free Libre Office. | ||
Line 209: | Line 208: | ||
* Item name | * Item name | ||
* Quantity | * Quantity | ||
- | * Pack size | + | * Pack size [Must be number, not words like " |
* Currency (in 3 letters international code format: e.g. AUD USD EUR ) | * Currency (in 3 letters international code format: e.g. AUD USD EUR ) | ||
* Price per pack | * Price per pack | ||
Line 236: | Line 235: | ||
**Update existing quote lines:** Select this if you want the contents of the file to update quote lines already in the tender. Note that information will only be updated for items in the tender where the current price for the line is 0. If a line in the tender has a non-zero price any line in the file with details for that item will be ignored. So, if you want item lines to be updated by the contents of the file reset their prices to 0 before you carry out the upload. Note also that if there is more than one matching zero-price tender item line with the same item code, then it will select the first match it comes to i.e. the system will cope with multiple quote lines for the same item. Therefore, if you want to upload multiple lines for an item, you need to duplicate that line in the tender first (using the // | **Update existing quote lines:** Select this if you want the contents of the file to update quote lines already in the tender. Note that information will only be updated for items in the tender where the current price for the line is 0. If a line in the tender has a non-zero price any line in the file with details for that item will be ignored. So, if you want item lines to be updated by the contents of the file reset their prices to 0 before you carry out the upload. Note also that if there is more than one matching zero-price tender item line with the same item code, then it will select the first match it comes to i.e. the system will cope with multiple quote lines for the same item. Therefore, if you want to upload multiple lines for an item, you need to duplicate that line in the tender first (using the // | ||
- | **Replace existing quote lines:** Select this if you want the contents of the file to replace everything already in the tender. All your existing lines will be deleted from the tender and the contents of the upload file will be entered into the tender. Note that if there are multiple lines in your upload file with the same item code this method will put them all into the tender. This is helpful if you keep your excel file as a master copy and use it to update your quotes. And also means that you can easily input multiple quotes for the same item (with different pack sizes or manufacturers, | + | **Replace existing quote lines:** Select this if you want the contents of the file to replace everything already in the tender. All your existing lines will be deleted from the tender and the contents of the upload file will be entered into the tender. Note that if there are multiple lines in your upload file with the same item code this method will put them all into the tender. This is helpful if you keep your Excel file as a master copy and use it to update your quotes. And also means that you can easily input multiple quotes for the same item (with different pack sizes or manufacturers, |
Click on the //Cancel// button to cancel the upload or the //OK// button to continue. | Click on the //Cancel// button to cancel the upload or the //OK// button to continue. | ||
Line 244: | Line 243: | ||
Please note the following points regarding the file upload process: | Please note the following points regarding the file upload process: | ||
- | * Only excel files (extension of ' | + | * Only Excel files (extension of ' |
- | * Currently, the only web browsers which fully support file upload are Firefox and Chrome. The next versions of Internet Explorer, | + | * Currently, the only web browsers which fully support file upload are Firefox and Chrome. The next versions of Safari and Opera are also planned to include support for this new HTML5 feature. |
* A successful upload message does NOT imply that the contents of the file are valid, simply that it has been processed. An email will be sent to your email address, with two attachments: | * A successful upload message does NOT imply that the contents of the file are valid, simply that it has been processed. An email will be sent to your email address, with two attachments: | ||
* A text file which contains the output generated from the upload process i.e. the number of records which were successfully processed, and any error messages generated during the upload process. | * A text file which contains the output generated from the upload process i.e. the number of records which were successfully processed, and any error messages generated during the upload process. | ||
- | * An excel file in the same format as produced by the 'Email me this quote' button, which will include the updated tender items - you should check that this reflects the changes you are expecting. | + | * An Excel file in the same format as produced by the 'Email me this quote' button, which will include the updated tender items - you should check that this reflects the changes you are expecting. |
* Any blank lines in the uploaded file will be ignored. | * Any blank lines in the uploaded file will be ignored. | ||
* Any lines which do not contain the expected number of columns, or with data in the wrong format will generate an error message and will not be imported. | * Any lines which do not contain the expected number of columns, or with data in the wrong format will generate an error message and will not be imported. | ||
Line 283: | Line 282: | ||
- Click on the Finalise button. | - Click on the Finalise button. | ||
- You're done | - You're done | ||
+ | |||
+ | |||
+ | {{: | ||
==== Closing date and time ==== | ==== Closing date and time ==== | ||
Note that closing date and time is specified as GMT (Greenwich Mean Time). This is **NOT** likely to be the same as your local time. Please take this into account when planning for when you will finalise your prices. | Note that closing date and time is specified as GMT (Greenwich Mean Time). This is **NOT** likely to be the same as your local time. Please take this into account when planning for when you will finalise your prices. | ||
Line 316: | Line 318: | ||
\\ | \\ | ||
\\ | \\ | ||
- | | // Previous: | + | | // Previous: |
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||