19.11. UNFPA LMS reports app

Some of our UNFPA users are periodically required to produce LMS reports. These can be time consuming and difficult to produce manually so we've created an app for that!

This app runs on the central server of your mSupply installation and will create a selection of UNFPA formatted LMS reports for you; all you have to do it make some selections to define what transactions have ot go in the reports.

mSupply needs to know which of the stores in your datafile are considered the central store and which are considered decentralised for the purposes of the LMS reports. You do this by adding appropriate tags to the stores.

The Central store must be given the tag UNFPA_Central and all decentralised stores must be given the UNFPA_decentralised tag.

For details of how to add tags to stores, please see the 26.07. Virtual stores page.

To get to the app, the webserver must be running in mSupply (see the 26.07. Virtual stores page for details on that).

In your browser, enter the URL of your server followed by the port the app is running on (if you don't know what this is, ask Sustainable Solutions), something like this:

https://example.com:4000

The login window will load which looks like this:

To login enter your mSupply username and password in the Username and Password fields and click on the Sign in button.

After successfully logging in, the report options window will be displayed:

On this window, make your selections to define what will go in your report:

• Report to create drop down list: CSelect one of the following options:
  • Quarterley review report
  • LMA IP SC Fact Sheet report
  • Stock on date
  • Ledger
• Include transactions in this date range in the report fields: click on the From and To dates to select the dates from calendars. Only transactions with a confirmed date that falls between the From and To dates will be included in the report.
• Items to include in report drop down list: Contains a list of all the master lists in your datafile. Select one to include only items from that master list in the report.
• Include stock from these donors in the report drop down list: You can choose one or more donors - if you do then only stock that came from them will be included in the report. You can also choose None (the default option), in which case a donor filter will not be applied.

If you select any report in the Report to create drop down list EXCEPT the Quarterley review report, an additional store filter is added to the botom of the options:

The table shows a list of all the stores in your datafile. To make it more manageable you can shoose to display only stores with particular tags by selecting them in the Filter stores by tag drop down list.

If there are many stores, you can use the paging controls at the bottom of the window to move through the different pages and choose how many stores to display on each page.

Click on the SELECTED column checkbox to select a store to include in the report. You can click on the All on/off checkbox to toggle the SELECTED checkbox on and off for all stores on all pages at once. Only transactions and stock from the stores that have a check in the SELECTED checkbox will be included in the report.

When you are happy with your selections, click on the Create Report button to create the report.