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 | ||
faq:wastage_prediction_due_to_expiry_v7-12 [2024/02/16 09:29] – [Suggested Order reports] Ujwal Khatry | faq:wastage_prediction_due_to_expiry_v7-12 [2024/02/16 11:03] – [Suggested Order reports] Ujwal Khatry | ||
---|---|---|---|
Line 12: | Line 12: | ||
* Report > Purchasing > Suggested Order quantities… | * Report > Purchasing > Suggested Order quantities… | ||
- | {{ : | + | {{ : |
The Suggested ordering report now has a new/updated expiry filter checkbox : //Exclude stock that will expire within 3 months of projected consumption date// | The Suggested ordering report now has a new/updated expiry filter checkbox : //Exclude stock that will expire within 3 months of projected consumption date// | ||
Line 54: | Line 54: | ||
However we now have 6 months starting from July 2024 till the end of December 2024 where we don’t have any stock, so mSupply will suggest a immediate order of : 6 * 50 =300 to cope with the 12 months starting from `1/1/2024` | However we now have 6 months starting from July 2024 till the end of December 2024 where we don’t have any stock, so mSupply will suggest a immediate order of : 6 * 50 =300 to cope with the 12 months starting from `1/1/2024` | ||
+ | mSupply has effectively time travelled into the future to work out the **Effective Stock on hand (SOH)** and the order will be carried out based on this and not the current stock on hand. | ||
+ | ===== New Columns on Suggested order reports and changes ===== | ||
+ | |||
+ | Now the suggested ordering reports will have two new column : | ||
+ | * Effective SOH (Stock on Hand) : From above this is the stock quantities that can be used before they expire. | ||
+ | * Expiring stock : This is the stock quantity that can’t be used due to predicted expiry and cut-off date. | ||
+ | |||
+ | The `Effective Month of Stock` is now calculated from the `Effective SOH` and not from the `Stock on Hand`. The `Suggested order` is now calculated from the `Effective SOH` and the `Effective Month of Stock`. | ||
+ | |||
+ | |||
+ | {{ : | ||
+ | |||
+ | ===== Generating a Purchase order and Tender ===== | ||
+ | The same logic is now applied when generating a purchase order or a tender. Like with the reports, we can ask mSupply to calculate potential stock wastage and order an appropriate quantity. | ||
+ | |||
+ | {{ : | ||
---- struct data ---- | ---- struct data ---- | ||
pagestatus.status | pagestatus.status | ||
---- | ---- | ||