faq:wastage_prediction_due_to_expiry_v7-12

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
Next revisionBoth sides next revision
faq:wastage_prediction_due_to_expiry_v7-12 [2024/02/16 09:29] – [Suggested Order reports] Ujwal Khatryfaq: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…
  
-{{ :faq:report_suggested_orderreport_label_corrected-2024-02-15-t15-21.png?400 |}}+{{ :faq:report_suggested_orderreport_label_corrected-2024-02-15-t15-21.png?450 |}}
  
 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`.
 +
 +
 +{{ :faq:suggested_order_report-2024-02-14-t18-17.png?600 |}}
 +
 +===== 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. 
 +
 +{{ :faq:po_generated_label_corrected_2024-02-15-t15-20.png?400 |}}
 ---- struct data ---- ---- struct data ----
 pagestatus.status    :  pagestatus.status    : 
 ---- ----
  
  • Last modified: 2024/03/11 08:13
  • by Ujwal Khatry