Goals/Scope
Product lists and prices in OpenLMIS are updated in line with updates to product lists and prices in the ERP, so that this does not cause problems during import of orders from OpenLMIS to ERP and facilitates other future interoperability between OpenLMIS and the ERP.
Status in eLMIS: Not in eLMIS currently.
Status in OpenLMIS: Not in OpenLMIS currently
Priority: High priority for Tanzania especially for MSD
Background
The PMU staff act as eLMIS administrators and configure eLMIS. Zonal level PMU staff are active in configuration of product lists and national advisors do other configuration.
Product meta-data are entered manually into eLMIS (with descriptions matching those on paper R&R forms). Products are entered into the ERP in parallel and by other MSD staff. This can result in mismatching, which throws up errors when requisitions are being imported from eLMIS to the ERP, which then need to be resolved manually.
Products in both eLMIS and in the ERP are generally the generic commodity as opposed to branded trade items. Kits are generally listed as one product as opposed to the constituent parts. The same item under different programs (for example cotrimoxazole under ILS and under ARV&OI) is coded and treated as separate items.
Prices are normally changed once per year, at the start of the financial year (i.e., 1 July). The system stores old prices as well as new prices and uses the appropriate prices for any particular time period.
Imports of R&Rs/orders currently return errors when product lists do not match. If prices do not match, this means that eLMIS does [not] give accurate cost information to R&R submitters and approvers.
Product prices are normally changed at the start of each financial year. New products can be created at any time.
See also sections of the document “System requirements specifications for eLMIS interface with mSupply” which discuss import of product lists.
Assumptions
While some non-vaccine items do require cold chain conditions, they are not given any special configuration treatment.
User Stories
| # | Title | User Story | Label | Importance | Notes | JIRA Tickets |
|---|---|---|---|---|---|---|
| 1 | Product list update from ERP | As an administrator I want product lists in OpenLMIS updated in line with updates to product lists in the ERP so that I don't have errors with other OpenLMIS-ERP data exchanges. | Tanzania ERP | Must have | ||
| 2 | Product list update review | As an administrator I want to be able to manually review product list changes and add additional information or configurations which are not available in the ERP. | Tanzania ERP | Must have | ||
| 3 | Price list update from ERP | As an administrator I want prices in OpenLMIS updated in line with updates to prices lists in the ERP so that R&R submitters and approvers have accurate cost information. | Tanzania ERP | Must have |
Diagrams
Dependencies
| Description | Link |
|---|---|
Open Questions
Below is a list of questions to be addressed as a result of this requirements document:
| # | Question | Outcome | Status |
|---|---|---|---|
| 1 | Will product list updates always go through a manual validation and update process? | ||
| 2 | Was this background detail confirmed as not a gap in OpenLMIS: "Prices are normally changed once per year, at the start of the financial year (i.e., 1 July). The system stores old prices as well as new prices and uses the appropriate prices for any particular time period"? | ||
| 3 | Need for adding in "System requirements specifications for eLMIS interface with mSupply" on import of product lists. | ||
| 4 | Is there a desire to have this done automatically? |