Target release3.5
Epic

 

Ashraf please insert the edge case epic here.

Document status
Priority
eLMIS StatusImplemented, not in use now in use
OpenLMIS StatusNot Implemented
PATH Jenny Thompson (Unlicensed)
OpenLMIS Mary Jo Kochendorfer (Deactivated)
JSI Ashraf


Goals/Scope

To enable import of shipment data from an ERP into OpenLMIS so that that data can be visible to facilities and districts, and so that delivery data can be compared to shipment data through OpenLMIS.  Shipment data shows whether and when orders are shipped and any changes between the ordered and shipped products and quantities.  If the facilities and districts have this data, they can take actions such as re-distributions or purchases through private supply chains earlier, rather than waiting for the actual MSD delivery before they know of any changes to their order.  This also increases accountability and visibility showing at what point in the supply chain any problems or bottlenecks occur.

Status in eLMIS: In eLMIS, not in use

Status in OpenLMIS: Not in OpenLMIS

Priority: High priority

Background

After MSD receives R&Rs from OpenLMIS and converts them into orders, a shipment is done.  The shipment may or may not correspond exactly to the order.  For example, amounts may be lower due to lack of stock at the central stores, or lack of availability of one product may lead to another similar product being substituted for it.

MSD records the shipment data in the ERP, but without this feature, this data is not accessible to facilities or districts.  For that reason, facilities and districts do not know whether their order has been adjusted by MSD, whether and when it has been shipped, and when to expect delivery.  

See also sections of the document System requirements specifications for eLMIS interface with mSupply” which discuss export of shipment file. [called out in open questions]

Assumptions

User Stories

This feature is documented at https://openlmis.atlassian.net/browse/OLMIS-644 


#TitleUser StoryLabelImportanceNotes
1Import shipment data from ERP to OpenLMISAs a facility/district user, I want to be able to import shipment data from an ERP into OpenLMIS so that data are visible to facilities and districts and delivery data can be compared to shipment data in OpenLMIS.  Tanzania eLMISMust Have
2View shipment dataAs a facility/district user, I want to be able to see when shipments were made and any differences between the products and quantities shipped from what was ordered in OpenLMIS so that I can take action, such as re-distributions or purchases through private supply chains earlier. Tanzania eLMISMust HaveWithout this they have to wait for the actual MSD delivery before they know of any changes to their order.  
3View shipment adjustment data against ordersAs a facility/district user, I want to visibility to order differences against what's shipped so that I can identify and address problems or bottlenecks in the supply chain.Tanzania eLMISMust Have
4Export shipment data from ERP to central store

As a central store user I want data exported from the ERP to OpenLMIS when shipment occurs so that I can track shipments.

Tanzania eLMISMust Have

The shipment file should contain:

  • order number (as generated by OpenLMIS at the time of ordering, and exported into the ERP)

  • ordered product code

  • substituted product code (if different product substituted for ordered product)

  • quantity shipped (of either ordered product or substituted product)

  • packed date

  • shipped date

  • notes (which could contain explanations for any substitution or quantity changes)

  • as an extra feature, it may be useful to list batch numbers and expiration dates.  One product shipment may be fulfilled by multiple batches with different expiration dates.  This feature is not in the current shipment file format in in eLMIS, but was included in specifications for mSupply interoperability.

5Human readable shipment file

As an Logistics office I want data to be included in the shipment file which is human readable, including data that can be derived from the shipment file together with order data and configuration data, so that I can manually cross-check, if needed.

Tanzania eLMISMust Have

To make the information human-readable:

  • facility code

  • program code

  • ordered product name

  • quantity ordered

  • pack size of ordered product

  • product name of substituted product if any

  • pack size of substituted product if any

  • cost of shipped product

6Advance shipment notification

As a supervisor at a receiving facility, I want an advance shipment notification can be sent to me and my facility when shipment data is received into OpenLMIS, an the receiving facility so that I know a shipment is on its way.

Tanzania eLMISMust Have
7Error handlingError handling for shipment files with invalid data ...


Diagrams

Include any business process mapping, mockups, diagrams or visual designs relating to these requirements. Describes the tasks and the personas who perform those activities. The diagram provides the context for the user stories and serves as a focal point for achieving clarity and agreement among stakeholders. Looks like a standard flow chart.


Dependencies

Identify initial dependencies that are on the critical path for this functionality and may affect the delivery time and serving of business goals. Include links to stories.

DescriptionLink
Name of story or release Link to JIRA


Open Questions

Initial communication between stakeholders and the development team to help understand scope and estimates.

#QuestionOutcomeStatus
1Confirm where “System requirements specifications for eLMIS interface with mSupply” is/which document this is referring to. There's a specifications document and the interface-related Tanzania gap documentation speaks to mSupply, but it's not referenced this way.Chris Opit (Unlicensed) could you share more information on how it is done with mSupply? How does mSupply tell eLMIS about the shipments?Open
2For Tanzania user stories: review the "so thats" added, review the label, and review the priority level.
Open
3Does this align with our documentation or understanding of shipments outlined Order and Shipment files? Is there any diagrams for these?
Open
4Is the shipment file in anyway related to proof of delivery and closing the loop on quantity requisitioned, ordered, shipped, received/rejected (and therefore returned), updated stock on hand at warehouse/depo?

Out of Scope

Gap Estimation Notes 4/12/2018