Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision | ||
tender_management:creating_purchase_orders [2017/11/28 10:52] – [Viewing tender purchase orders] Gary Willetts | tender_management:creating_purchase_orders [2023/05/09 15:36] – [Reports] Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{indexmenu_n> | + | {{indexmenu_n> |
- | ===== Analysing supplier responses | + | ====== 18.07. |
===== Review ===== | ===== Review ===== | ||
At this stage you should already have performed the following: | At this stage you should already have performed the following: | ||
Line 16: | Line 16: | ||
To set a benchmark supplier, open the tender (choose **Suppler > Show Tenders...** from the menus and double-click on the tender in the list) and on the //Tender preferences// | To set a benchmark supplier, open the tender (choose **Suppler > Show Tenders...** from the menus and double-click on the tender in the list) and on the //Tender preferences// | ||
- | {{ :tender_management: | + | {{ tender_management: |
For more details on using benchmark price see [[tender_management: | For more details on using benchmark price see [[tender_management: | ||
Line 23: | Line 23: | ||
Once you have the tender open (choose **Suppler > Show Tenders...** from the menus and double-click on the tender in the list), select the **Items and compare prices** tab: | Once you have the tender open (choose **Suppler > Show Tenders...** from the menus and double-click on the tender in the list), select the **Items and compare prices** tab: | ||
- | {{ :tender_management: | + | {{ tender_management: |
<WRAP info center round 80%> | <WRAP info center round 80%> | ||
Line 31: | Line 31: | ||
Then double-click the first item in the list, which in our example is Acetazolamide 250mg tablets, to bring up the //Edit tender item window//, which opens at the //Compare supplier responses// tab: | Then double-click the first item in the list, which in our example is Acetazolamide 250mg tablets, to bring up the //Edit tender item window//, which opens at the //Compare supplier responses// tab: | ||
- | {{ :tender_management: | + | {{ tender_management: |
In our example, 5 suppliers have been invited to tender, and 4 have submitted tenders, one supplier having submitted prices for two different pack sizes. One supplier has not submitted a quotation, so all the entries for that supplier are zero. | In our example, 5 suppliers have been invited to tender, and 4 have submitted tenders, one supplier having submitted prices for two different pack sizes. One supplier has not submitted a quotation, so all the entries for that supplier are zero. | ||
Line 62: | Line 62: | ||
Here is an example of a tender that has been partially processed, looking at the //Items and Compare prices// tab: | Here is an example of a tender that has been partially processed, looking at the //Items and Compare prices// tab: | ||
- | {{ : | + | {{ : |
- | Two of the lines have been changed to a green colour | + | Two of the lines have been changed to a green colour. The //Preferred supplier// column can contain |
+ | | ||
+ | * **Not selected:** bids have been entered | ||
+ | * **A supplier | ||
- | If the **Show** drop down list is changed back to "All", | + | The **Show** drop down list just above the list of items is currently showing all lines but it has these options: |
+ | * **All:** show all tender lines, no filtering. | ||
+ | * **Filled:** show only those lines that have had bids entered for them, whether a preferred one has been selected or not (helpful for showing what still needs to be processed). | ||
+ | * **No bids:** show only those lines that have had no bids entered for them. | ||
+ | * **Lowest cost not chosen:** show only those lines where a bid has been selected as preferred and it did not have the lowest cost. | ||
+ | * **0 number | ||
===== Back to the Items and compare prices tab ===== | ===== Back to the Items and compare prices tab ===== | ||
Line 75: | Line 83: | ||
The **Original** column will display the cost of that line if you purchase the tender quantity of that item from the preferred supplier in the currency quoted (The **Original Local** column displays the cost in the local (default or home)currency you are using in mSupply). Note that you might end up editing the quantity on the purchase order to a different value, and then the **PO local** column will have a different value. | The **Original** column will display the cost of that line if you purchase the tender quantity of that item from the preferred supplier in the currency quoted (The **Original Local** column displays the cost in the local (default or home)currency you are using in mSupply). Note that you might end up editing the quantity on the purchase order to a different value, and then the **PO local** column will have a different value. | ||
- | ===== Back to the Choose | + | ===== Back to the Choose |
Just before you create purchase orders for the winning suppliers you might like to see the value that each supplier has won. To do this, click on the //Choose Suppliers and Enter responses// tab and the total value that each supplier has won (i.e. the total value of all the lines where they were selected as the preferred supplier) will be shown in the //Tender value// column. The total amount that each supplier bid will be displayed in the //Total bid// column. | Just before you create purchase orders for the winning suppliers you might like to see the value that each supplier has won. To do this, click on the //Choose Suppliers and Enter responses// tab and the total value that each supplier has won (i.e. the total value of all the lines where they were selected as the preferred supplier) will be shown in the //Tender value// column. The total amount that each supplier bid will be displayed in the //Total bid// column. | ||
Line 81: | Line 89: | ||
You might need to provide reports to a tender board, or for internal records. The tender module has several reports built in, accessed by clicking on the **Print internal report** button on the //Items and compare prices// tab of the tender details window. Clicking on the button displays this window with a drop down list of reports to choose from: | You might need to provide reports to a tender board, or for internal records. The tender module has several reports built in, accessed by clicking on the **Print internal report** button on the //Items and compare prices// tab of the tender details window. Clicking on the button displays this window with a drop down list of reports to choose from: | ||
- | {{ :tender_management: | + | {{ tender_management: |
**Winning tender lines**: Shows all the items in the tender which have been allocated a preferred supplier and the costs of those lines. This is an example: | **Winning tender lines**: Shows all the items in the tender which have been allocated a preferred supplier and the costs of those lines. This is an example: | ||
- | {{ :tender_management: | + | {{ tender_management: |
**Supplier quotes for each item**: Shows quotes from all suppliers for all items, grouped by item. Handy for a summary of all received quotes. | **Supplier quotes for each item**: Shows quotes from all suppliers for all items, grouped by item. Handy for a summary of all received quotes. | ||
Line 92: | Line 100: | ||
**Tender lines: lowest price not chosen**: Shows all tender lines which have been chosen as the winning bod when their price was not the lowest. Summary detail shows how much more you will pay than choosing the cheapest lines. | **Tender lines: lowest price not chosen**: Shows all tender lines which have been chosen as the winning bod when their price was not the lowest. Summary detail shows how much more you will pay than choosing the cheapest lines. | ||
- | ===== Setting up Purchase Order (PO) preferences ===== | + | |
+ | **Evaluation report**: Useful for showing all evaluation details or for using during a manual evaluation exercise. Shows all quotes for each item and the outcome of the evaluation (or space for you to enter the outcome). It looks like this: | ||
+ | {{ : | ||
+ | ===== Setting up purchase order (PO) preferences ===== | ||
Once the choice of preferred supplier has been made for all the items you want to purchase in the tender, the next stage is to generate the Purchase Orders. | Once the choice of preferred supplier has been made for all the items you want to purchase in the tender, the next stage is to generate the Purchase Orders. | ||
Click on the **Tender Preferences** tab on the **Edit Tender** window: | Click on the **Tender Preferences** tab on the **Edit Tender** window: | ||
- | {{ :tender_management: | + | {{ tender_management: |
mSupply offers two options for creating Purchase Orders: | mSupply offers two options for creating Purchase Orders: | ||
- | {{ :tender_management: | + | {{ tender_management: |
Line 119: | Line 130: | ||
Note that the creation of purchase orders from tenders will be [[admin: | Note that the creation of purchase orders from tenders will be [[admin: | ||
- | ==== Creating | + | ==== Creating |
- Go to the **Purchase Orders** tab | - Go to the **Purchase Orders** tab | ||
- If you have checked the "Split deliveries" | - If you have checked the "Split deliveries" | ||
- | {{ :tender_management: | + | {{ tender_management: |
You will need to confirm that this is what you want to do by clicking the **Yes** button on the confirmation window which appears: | You will need to confirm that this is what you want to do by clicking the **Yes** button on the confirmation window which appears: | ||
- | {{ :tender_management: | + | {{ tender_management: |
You are then shown a list of suppliers: | You are then shown a list of suppliers: | ||
- | {{ :tender_management: | + | {{ tender_management: |
Click on the supplier(s) you want to add, and enter the requested delivery date, then click **OK**. | Click on the supplier(s) you want to add, and enter the requested delivery date, then click **OK**. | ||
Line 143: | Line 154: | ||
Use the **Delete PO** button to remove a purchase order (highlight to one(s) to delete before clicking the button). | Use the **Delete PO** button to remove a purchase order (highlight to one(s) to delete before clicking the button). | ||
- | ==== Creating | + | ==== Creating |
If you aren't creating split deliveries, the first button will be labelled **Create PO** | If you aren't creating split deliveries, the first button will be labelled **Create PO** | ||
Line 153: | Line 164: | ||
When you have created purchase orders in a tender you can view them at any time by clicking on the **Purchase order** tab which will look like this: | When you have created purchase orders in a tender you can view them at any time by clicking on the **Purchase order** tab which will look like this: | ||
- | {{ :tender_management: | + | {{ tender_management: |
To see the details of the items on any of the purchase orders in the list, simply double-click on the purchase order' | To see the details of the items on any of the purchase orders in the list, simply double-click on the purchase order' | ||
- | {{ :tender_management: | + | {{ tender_management: |
- | ==== Editing | + | ==== Editing |
Once you have created Purchase orders you might want to edit some quantities (for example, you might want the first of two purchase orders for a supplier to have 60% of the total order, and the second purchase order only 40%) | Once you have created Purchase orders you might want to edit some quantities (for example, you might want the first of two purchase orders for a supplier to have 60% of the total order, and the second purchase order only 40%) | ||
Line 170: | Line 181: | ||
- Use the tab key to advance to edit the quantity of the second row, etc. | - Use the tab key to advance to edit the quantity of the second row, etc. | ||
- | {{ :tender_management: | + | {{ tender_management: |
Line 193: | Line 204: | ||
- | // Previous: [[tender_management: | + | ===== Field Descriptions and Formulae ===== |
+ | |||
+ | ^ Column name ^ Description | ||
+ | | **Price** | The price per pack offered by the supplier | | | ||
+ | | **Net Cost** | The cost in local currency (i.e. datafile default currency) of the offered pack size, multiplied by freight factor | Offered price * currency rate * freight factor | | ||
+ | | **Local Cost** | Alternative name for Net Cost | | | ||
+ | | **Total Cost** | The Total cost of the offered number of packs in Local Cost | Net Cost * Offered Number of Packs | | ||
+ | | **Adjusted Cost** | The cost adjusted by currency, freight factor and item's default pack size for direct comparison between quotes | Net Cost * (Default packsize/ | ||
+ | |||
+ | |||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | | | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||