Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| faq:wastage_prediction_due_to_expiry_v7-12 [2024/02/16 09:40] – [New Columns on Suggested order reports and changes] Ujwal Khatry | faq:wastage_prediction_due_to_expiry_v7-12 [2024/03/11 08:13] (current) – [Suggested Order reports] Ujwal Khatry | ||
|---|---|---|---|
| Line 4: | Line 4: | ||
| Prior to mSupply v7.12, when ordering or reporting on suggested ordering, you could simply tell mSupply to ignore stock that was going to expiry in three or four months time. mSupply would then lower it's stock level and order according to usages. | Prior to mSupply v7.12, when ordering or reporting on suggested ordering, you could simply tell mSupply to ignore stock that was going to expiry in three or four months time. mSupply would then lower it's stock level and order according to usages. | ||
| - | However due to popular demand with mSupply v7.12 we have tried to do a better job of predicting stock wastage due to expiry. Using the consumption data that we have, we have travelled into the future and worked out the likely wastage stock. This page describes the workflow. | + | So previously if you asked mSupply to ignore stock that is likely to expire within the next six months while ordering or reporting, then mSupply would simply reduce the Stock on hand of the items by taking out the six months expiring stock as un-usable and then created a order based on the reduce stock. This is highly inaccurate as mSupply just removes the six months expiring stock instead of trying to workout if the stock can be dispensed in a timely manner. |
| + | |||
| + | Due to popular demand with mSupply v7.12 we have tried to do a better job of predicting stock wastage due to expiry. Using the consumption data that we have, we have travelled into the future and worked out the likely wastage stock. This page describes the workflow. | ||
| ===== Suggested Order reports ===== | ===== Suggested Order reports ===== | ||
| Line 12: | Line 14: | ||
| * 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 38: | Line 40: | ||
| When the above report is run, mSupply will immediately ignore the batch `b12-2023` as it has already expired as the current date is `1/ | When the above report is run, mSupply will immediately ignore the batch `b12-2023` as it has already expired as the current date is `1/ | ||
| - | For batch `b06-2024` : mSupply works out that you can only dispense this batch till the end of April 2024, due to the set 3 months cutt-off date for expiry. | + | For batch `b06-2024` : mSupply works out that you can only dispense this batch till the end of March 2024, due to the set 3 months cutt-off date for expiry. |
| * January 2024 | * January 2024 | ||
| * February 2024 | * February 2024 | ||
| * March 2024 | * March 2024 | ||
| - | * April 2024 | ||
| - | So the stock that can be used from batch `b06-2024` is : | + | So the stock that can be used from batch `b06-2024` is : |
| - | So the wasted quantity for batch `b06-2024` is : 550 - 200 = 350 (This is expiring stock, | + | So the wasted quantity for batch `b06-2024` is : 550 - 150 = 300 (This is expiring stock, |
| - | For batch `b06-2025` : So from May 2024, mSupply will need to start using this batch for distribution. So this is 8 months remaining | + | For batch `b06-2025` : So from April 2024, mSupply will need to start using this batch for distribution. So this is 9 months remaining |
| + | * April 2024 | ||
| * May 2024 | * May 2024 | ||
| - | * June 2024 | ||
| So for batch `b06-2025` all the stock will be used up and they will be no wastage. | So for batch `b06-2025` all the stock will be used up and they will be no wastage. | ||
| - | 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 7 months starting from June 2024 till the end of December 2024 where we don’t have any stock, so mSupply will suggest a immediate order of : 7 * 50 =350 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. | 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. | ||
| Line 62: | Line 63: | ||
| * Expiring stock : This is the stock quantity that can’t be used due to predicted expiry and cut-off date. | * 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` | + | 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 | ||
| ---- | ---- | ||