Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
reports:purchasing [2024/02/16 11:11] – [Suggested order quantities] Ujwal Khatry | reports:purchasing [2024/02/16 11:33] (current) – [Report output] Ujwal Khatry | ||
---|---|---|---|
Line 111: | Line 111: | ||
**Include items with no usage in the last 12 months:** If this box is checked, items which have not been used over the last year will be included. This check box will have no effect if the previous "days cover" field is filled in, as an item with no usage will have " | **Include items with no usage in the last 12 months:** If this box is checked, items which have not been used over the last year will be included. This check box will have no effect if the previous "days cover" field is filled in, as an item with no usage will have " | ||
- | **Order quantity for X months | + | **Months |
+ | |||
+ | **Exclude stock that will expire within 3 months of projected consumption date** is a new/updated checkbox to accurately predict amount of stock that is likely to be wasted due to expiry and current consumption rate. In this current example, mSupply will only aim to distribute stock if the expiry is more than 3 months away. This updated feature is only available | ||
+ | |||
+ | This topic is huge so it may be worth reading this topic [[faq: | ||
**Open report in Excel:** Checking this box opens Excel (or any other installed spreadsheet application) and displays the report as a spreadsheet. If you want to save the report, choose File > Save as... in your spreadsheet application. | **Open report in Excel:** Checking this box opens Excel (or any other installed spreadsheet application) and displays the report as a spreadsheet. If you want to save the report, choose File > Save as... in your spreadsheet application. | ||
==== Report output ==== | ==== Report output ==== | ||
- | **Cover column: ** if the column prints ">>>>" | + | |
+ | A typical `Suggested Order` report will look something like below. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Important Columns and their meaning : | ||
+ | | ||
+ | | ||
+ | * Effective SOH : This is the Effective stock on hand. i.e | ||
+ | * Effective Months | ||
+ | * Suggested order : This is the suggested order and will depend on `Effective SOH` and `Effective Months | ||
+ | |||
+ | For a more detail guide click on this topic : [[faq: | ||
===== Suggest order quantities with prices and price extension ===== | ===== Suggest order quantities with prices and price extension ===== | ||
This report is an extension of the previous one, allowing you to see what the suggested order will cost. The filter choices you have are the same as for the suggested order quantities report. You get an option to price your suggested order. | This report is an extension of the previous one, allowing you to see what the suggested order will cost. The filter choices you have are the same as for the suggested order quantities report. You get an option to price your suggested order. | ||
- | {{ :reports:suggested_order_quantities_with_prices.png?400 |}} | + | {{ :reports:suggested_order_quant_with_price-2024-02-16-t16-58.png?600 |}} |
Key Column headers : | Key Column headers : |