Reporting - Order & Item Fill Rate Report

Target release
EpicReporting - Order fill rate
Document status
DRAFTED
PriorityHIGH
eLMIS StatusImplemented
OpenLMIS StatusNot Implemented
PATH 
OpenLMIS Mary Jo Kochendorfer (Deactivated)
JSI Ashraf Islam (Unlicensed)

Goals/Scope

Provide statistics about Order and item fill rates

Status in eLMIS: Implemented.

Status in OpenLMISNot implemented within OpenLMIS, can be created in Tableau 

Priority: High priority for Tanzania

Background

Use: A priority for systems interfaced with WMS/ERP, labor/data entry intensive to get if not interfaced (requiring delivery) 

Used by both warehouse and facility, but especially for warehouse as part of the performance KPIs - they are accountable to their 

At a facility it is good to know if your order is getting filled/to what level (tech. a different report but there are elements in it that would be used prior to delivery/receipt) - trends can be useful for advocacy if need to make complaints or encourage more procurement etc.- hold people accountable 

  • technically order fill rate/item fill rate - based on what is picked/packed, this also has POD - quantity received for facility to sign off on what was received in the shipment
    • Also may have a transport piece in between shipment and receipt

The report shows:

  • product code
  • product name
  • quantity ordered
  • quantity received
  • item fill rate

Note: PDF and Excel export includes addional datapoint Supplimental Funds Used

Parameters:

  • program
  • schedule
  • year
  • period (which can be an A / B / C quarter period)
  • Geographic Zone (district, region, country)
  • Facility Type
  • Facility
  • Product Type
  • Product

Assumptions

In this story user means or one of the following, Health Facility incharge, DMO, Community and Regional Management Team (C/RHMT), Logistics officer/Advisors, Senior level decision maker, M&E officer/Advisor etc 

User Stories

#TitleUser StoryLabelImportanceNotesJIRA Tickets
1

Report

As an user/supervisor/admin I want to be able to ...ReportsMust have for TZ



2View order fill rateAs a user, I need to see how my order was fulfilled and which products were not fulfilledReportsMust have for TZ

3View item fill rateA a user, I need to how much each product was fulfilled.ReportsMust have for TZ

4Export reports to ExcelAs a user, I need to be able to export all reports and analysis reporting results into Excel so that I can process the data more and analyze it in Excel.ReportsMust have for TZ

5Print reports with headings and logsAs a user, I need to be able to print reports with customized headings and logos so that I can file the report for future references.ReportsMust have for TZ








Diagrams


Dependencies

DescriptionLink


Open Questions

Below is a list of questions to be addressed as a result of this requirements document:

#QuestionOutcomeStatus
1


Out of Scope

OpenLMIS: the global initiative for powerful LMIS software