tender_management:creating_purchase_orders

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
tenders:creating_purchase_orders [2019/09/21 11:40] – [6.07. Analysing supplier responses & creating purchase orders] loutender_management:creating_purchase_orders [2023/05/09 15:36] (current) – [Reports] Gary Willetts
Line 1: Line 1:
-{{indexmenu_n>50}} +{{indexmenu_n>70}} 
-===== 15.07. Analysing supplier responses creating purchase orders =====+====== 18.07. Analysing supplier responses and creating purchase orders ======
 ===== 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// tab, in the //Benchmark supplier// section select the desired benchmark supplier in the Benchmark supplier drop down list: 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// tab, in the //Benchmark supplier// section select the desired benchmark supplier in the Benchmark supplier drop down list:
  
-{{ tenders:include_benchmk.png?750 }}+{{ tender_management:include_benchmk.png?750 }}
  
-For more details on using benchmark price see [[tenders:benchmark_prices|Using benchmark prices]].+For more details on using benchmark price see [[tender_management:benchmark_prices|Using benchmark prices]].
  
 ==== Analysing the responses ==== ==== Analysing the responses ====
 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:
  
-{{ tenders:tend_items_and_comp.png?700 }}+{{ tender_management:tend_items_and_comp.png?700 }}
  
 <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:
  
-{{ tenders:item_quotations.png?700 }}+{{ tender_management:item_quotations.png?700 }}
  
 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:
  
-{{ tenders:tender_items_tab.png?750 }}+{{ :tender_management:pasted:20230406-113422.png?750 |}}
  
-Two of the lines have been changed to a green colour and the **Show** drop down list just above the list of items has been changed to "Not chosen" so that it displays all the items for which a preferred supplier needs ot be chosen - helpful for seeing what still has to be done!+Two of the lines have been changed to a green colour. The //Preferred supplier// column can contain the following values: 
 +  * **No bids:** no bids from any supplier have been entered for this item. 
 +  * **Not selected:** bids have been entered for the item but none has been selected as preferred yet. 
 +  * **A supplier name:** bids have been entered for the item an one, from the displayed supplier, has been selected as preferred.
  
-If the **Show** drop down list is changed back to "All", all items will be displayed in the list, with the name of the Preferred supplier column for each line shown in the //Preferred Supplier// column.+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 of packs:** show only those lines that have zero packs entered for them. This is not possible for manually created tenders but could, in certain circumstances, be possible with auto-generated tenders or tenders downloaded from the [[https://docs.msupply.foundation/health-supply-hub/introduction/|Health Supply Hub]].
  
 ===== 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 Suppliers and Enter responses tab =====+===== Back to the Choose suppliers and enter responses tab =====
 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:
  
-{{ tenders:report_options.png?350 }}+{{ tender_management:report_options.png?350 }}
  
 **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:
  
-{{ tenders:winning_itms_exmpl.png?800 }}+{{ tender_management:winning_itms_exmpl.png?800 }}
  
 **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: 
 +{{ :tender_management:pasted:20230509-153541.png?950 |}} 
 +===== 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:
  
-{{ tenders:tender_prefs.png?700 }}+{{ tender_management:tender_prefs.png?700 }}
  
 mSupply offers two options for creating Purchase Orders: mSupply offers two options for creating Purchase Orders:
  
-{{ tenders:po_calc_method.png?400 }}+{{ tender_management:po_calc_method.png?400 }}
  
  
Line 119: Line 130:
 Note that the creation of purchase orders from tenders will be [[admin:the_log|logged]] by mSupply. Note that the creation of purchase orders from tenders will be [[admin:the_log|logged]] by mSupply.
  
-==== Creating Purchase Orders with split deliveries ==== +==== Creating purchase orders with split deliveries ==== 
  
   - Go to the **Purchase Orders** tab   - Go to the **Purchase Orders** tab
   - If you have checked the "Split deliveries" checkbox in the preferences for this tender, the first button on the toolbar will be **Create blank POs**.     - If you have checked the "Split deliveries" checkbox in the preferences for this tender, the first button on the toolbar will be **Create blank POs**.  
  
-{{ tenders:po_tab.png?700 }}+{{ tender_management:po_tab.png?700 }}
  
 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:
  
-{{ tenders:po_confirm.png?450 }}+{{ tender_management:po_confirm.png?450 }}
  
 You are then shown a list of suppliers: You are then shown a list of suppliers:
  
-{{ tenders:po_create_blank.png? |}}+{{ tender_management:po_create_blank.png? |}}
  
 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 Purchase Orders without split deliveries (single delivery) ==== +==== Creating purchase orders without split deliveries (single delivery) ==== 
 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:
  
-{{ tenders:tender_purchase_orders_tab.png?800 |}}+{{ tender_management:tender_purchase_orders_tab.png?800 |}}
  
 To see the details of the items on any of the purchase orders in the list, simply double-click on the purchase order's line in the table and you will be shown the details in a window which looks like this: To see the details of the items on any of the purchase orders in the list, simply double-click on the purchase order's line in the table and you will be shown the details in a window which looks like this:
  
-{{ tenders:tender_purchase_order_summary.png?600 |}}+{{ tender_management:tender_purchase_order_summary.png?600 |}}
  
-==== Editing Purchase Order Quantities ====+==== Editing purchase order quantities ====
 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.
  
-{{ tenders:po_tender_edit_qty.png?750 }}+{{ tender_management:po_tender_edit_qty.png?750 }}
  
  
Line 191: Line 202:
 When you finalise a tender you will be warned if there are no Purchase orders associated with it because you won't be able to create them later! When you finalise a tender you will be warned if there are no Purchase orders associated with it because you won't be able to create them later!
 </WRAP> </WRAP>
 +
 +
 +===== Field Descriptions and Formulae =====
 +
 +^ Column name   ^ Description    ^ Formula ^
 +| **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/Offered packsize)|
 +
 +
 +
 \\ \\
 \\ \\
-|  //  Previous:  **[[tenders:benchmark_prices|6.6. Benchmark prices for tenders]]** | | Next: **[[tenders:tender_web_module_for_suppliers|6.8. Supplier instructions for using tender submission web interface]]** //  |+|  //  Previous:  **[[tender_management:benchmark_prices]]** | | Next: **[[tender_management:tender_web_module_for_suppliers]]** //  |
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2019/09/21 11:40
  • by lou