When Reports > Items and Stock is chosen, a range of available reports are displayed; click on the one you require to select it:

Opening Stock

In the early days of mSupply, this report was designed to show the stock at the start of the financial year; it is dependant upon having Set the start of year stock, a topic covered in the Special Menu section of the guide. The report produced lists the stock at the start of the year.

If you have not used this Set the start of the year stock feature we suggest you consider using the Stock on date report, entering the first day of your financial year as the date, and selecting Stock at start of the day.

Current Stock

A report will be produced that lists each stock line that is currently showing stock greater than zero. Should you wish the report to include items/batches with zero stock, the box in the lower left needs to be checked.

Item filter

A “Find” report allows you to enter the normal item find criteria to choose which items to include.

A random report allows you to enter a number only. That number of items will be randomly chosen, and stocktake sheets for those items printed. This facilitates spot checking of your actual stock situation.

Additional options

Should you wish the report to be department specific, then that department should be selected from the drop down list of the departments which you have created.

Should you wish the report to give information on a particular location, then that location should be specified , selecting the appropriate operator of the three available in the drop down box alongside the Filter by actual stock location option.

Report format

You can choose from three formats:

  • “Each batch shown separately” will also give you a column on the right where, having done a physical stocktake, you can enter the quantity that is actually in stock, allowing any corrections to be made in mSupply.
  • “Total stock for each item” will not show individual batches, but the total quantity on hand of each item.
  • List the price of each batch in stock, with a total at the end of the report.

The lines are reported alphabetically either by item name or shelf location, depending on what you have chosen in the “Sort report by” options

Donor Reporting

mSupply provides the feature of printing the Donor name on the Current Stock report so that organisation donating the goods can be identified and tracked.

Stock on date

This report allows you to produce a report for the stock in your store on a particular date. You are shown a window like this:

Enter the date for which you wish to show the stock.

Type of report

You have 3 options:

  1. Show items only: each item in your system will have a single entry with the total quantity on that date.
  2. Show items with batches: each batch, its expiry and batch number along with the quantity of stock will be shown.
  3. Show batches with summary: as 2, but every item has an aggregate line before the lines for each batch, showing the total quantity for all batches of the item. So it's a bit like a combination of 1 and 2.

The Report on items whose box allows you to restrict the report to certain items only, using item properties or different categories as filters.

Open report in Excel

Check this checkbox to view the report directly in your chosen Spreadsheet program.

Show total stock value

This report is used to find the total stock value either for a particular department or all departments. The drop down menus allow customisation of your report by entering appropriate search criteria from the many options.

Check this checkbox to directly open the report in Excel rather than printing.

Graph: stock by item

This report shows a graph for an item or items showing the quantity of stock on hand for each day over a defined period.

Note that if you have allowed editing of confirm dates on transactions, mSupply's ability to calculate accurately the data used in this report may be affected.

Choosing this item from the menu displays this window:

Enter the date range, or select the required period from the drop down list, the items on which you wish to report, and appropriate filters, if any. Remember you can use the item flag field to select an ad hoc list of items to include in your report.

Clicking OK displays a window where you are shown a graph of the quantity in stock on each day for the first item that matched the criteria you entered.

This window also displays a list of items that were found. To display the graph for a different item, choose it from the list.

This report can be used as one of a set of key indicators for performance of a facility by comparing days out-of-stock of key items from one year to the next.

Graph: total stock

The total stock graph report allows you to view the value of your stock over a desired period of time. When you choose total stock graph, you are able to enter the required period which you would like to view:

Select OK and a graphical stock history report showing stock value will be displayed

Item list

This report allows you to view an on-screen or printed list of items.

There is only one report layout listed in the window, but please tell us what you would like, and we'll consider adding it.

Local/Remote Report

This option will only show “local data” as an option unless you purchase a web services enabled version of mSupply, in which case you can view reports from remote locations running mSupply. Contact us for more information.

Items out of stock

Selecting this report displays this window:

Specify your required options from the drop down lists;

Days out of stock

Selecting this report displays this window:

Specify your required options from the drop down lists; the desired period may be identified either by entering dates in the From and To fields, or by using the drop down list to the right.

Clicking ok will generate a report like the one below:

Clicking the Complex find button opens the Query Editor, allowing you to enter specific criteria relating to your search.

You may also specify what level in percentage terms of the maximum stock should be considered as being “out of stock..” Here's an example over 1 month:

Day of month 123456789101112131415161718192021222324252627282930
stock on hand 20000200002000020001000500300200300002520020200180001800018000100005000500020002000800800200002000020000200002000020000200002000020000
Out of stock m(m( m( This day had maximum stock. 5% of 30000=1500 m(m(
Note the 5% stock out level = 1500

Item usage

This report gives you a breakdown of item usage for the last few months, with summaries for the last 2 years, It also includes stock on hand and stock on backorder for each item in the report.

The report produced is very useful for forecasting or for seeing a list of items that need to be ordered.

When you choose the menu item you are shown a window like this:

Your can choose the type of report you want to run from the drop-down menu

This menu includes an item usage report, a suggested ordering amount report, or to auto generate a tender from the drop-down list at the top. This form is used for all 7 functions. For now, leave this as it is (Note that the Item usage report with pending purchase order option will show you item usage with details of items currently on order and their expected date of delivery).

If you want to report on all items, leave the item name field blank:

otherwise enter an item name or code. For example, to report on amoxycillin stocks, you could enter “amox” into the field.

Depending on the entry in the first field, further options are available in the following two fields, but these will vary according to the entry in the first field. Among the options, he first field allows you to make your selection from the names given to custom item fields in the Preferences if this feature has been used.

If you wish to use shelf locations, then select the shelf location option and specify the desired shelf.

You can use the drop-down list to find Items with a particular code, or to use the values you have entered into one of the custom user fields. If this isn't powerful enough, use the complex find button to display the full query editor.

Click the refresh button to calculate the number of items these basic parameters will find. This screenshot shows that 17 items meet the parameter specified, i.e. items whose names begin with 'pro';

Only include items whose stock cover is less than...

If you want only to report on items whose stock is low, enter the threshold for days of stock on hand into the second field. For example, entering 90 into this field will only include items in the report whose stock is not sufficient to cover average usage for the next 90 days.

Enter “0” (zero) for this field to report on items with any amount of stock remaining.

Include items with no usage in the last 12 months

If this box is checked, items with no usage over the last year will be included. This check box will have no effect if the previous “days cover” field is filled in, as an item with no usage will have “infinite” cover- any stock you do have is going to last you forever!

Include usage for build ingredients

If you manufacture items, you can choose whether the use of ingredient lines in manufacturing is included in the report or not.

Open report in Excel

Checking this box opens Excel (or any installed spreadsheet) and displays the report directly. If you want to save the report, choose File > Save as… in your spreadsheet program.

Item Usage Report Preview

Suggested Ordering Report

When in the Item usage report dialogue box, select the 'Suggested ordering report' option from the drop down box at the top left. Note the extra options for including item usage when calculating item ordering quantities. Also note the option to include ordering for build items. See item builds for more on built items.

Suggested Ordering Report Preview

This report gives analysis per item and the final column provides a suggested quantity to order. It is then the responsiblity of the Purchaser to make the final decision on how much stock to order.

Item usage with outstanding Purchase Orders

The window that appears when you choose this report is the same as the previous one; with exactly the same options available; the report produced differs only in that any lines having outstanding Purchase Orders have the relevant details of the Purchase Order displayed.

Item slow movers

You will be shown a window to enter the item details:

Enter your search criteria in the top section.

Item name field

  • If you want a report for all items, leave this field blank. Otherwise enter some text to reduce the report to just a few items (e.g. entering “am” will produce a report of just the items whose name starts with “am” (Amitriptylline, Amoxycillin, etc)

Category and Department

  • Use the drop down boxes as appropriate to select Category and/or Department if required.

Days stock

  • Enter the number of days stock to report on. Items with more than this number of days stock on hand will be included in the report. The correct figure to enter here depends upon your desired stock turn. In general, if you are turning over your stock 3 or 4 times a year, you would want to know about items which have more than 240 days stock on hand.
  • The report is calculated using the last 12 months usage as a guide to the average monthly usage.

You can check the Open report in Excel box to open the report in Excel, or any installed spreadsheet.

The report produced is very useful for managing under-performing inventory. It allows you quickly to obtain a list of items where a reduction in stock is desirable.

Expiring items

This report will ask you to enter a date, and will then give a report of all item lines in stock whose expiry date is before the date you have entered.

For example, entering 31/8/11 will display all items with expiry dates before 31st August 2011 (Enter the date in short format in the way your computer is set to handle dates (DD/MM/YY or MM/DD/YY or YY/MM/DD).

You can additionally filter the stock by the location type or the actual location in the warehouse. This is helpful for reporting on items in certain sections of your warehouse.

Three report type options are offered; select as appropriate. You may refine the search by using the Name filter and/or the Item filter..

Donor Reporting

mSupply provides the feature of printing the Donor name on the Expiring Items report so that the organisation donating the goods can be identified and tracked. This can help with disposing of or returning goods to the Donor.

Expiring items vs cover

This is a versatile report which allows you to see at a glance the amount of any stock items, and the number of days' cover provided by that amount of stock you have. Note: The cover calculation uses the last 12 months of usage data to calculate your rate of consumption.

Many filters may be applied in the drop down lists, which are the same as described under Item usage… above.

Note that If the field you are searching is a boolean field, e.g.Essential Drug List, “false” appears as the default entry, which you may change to “true”.

Cover Calculation

This allows the user to include or exclude specific categories to be used in calculating coverage. Clicking the magnifying glass to the right lists categories to be chosen.

If you wish mSupply to remember the criteria which you have entered, click on the paperclip icon, and your selections will appear the next time you open the report.

Once you have selected your required criteria, click on the Refresh icon to show the number of items which match your criteria, and which will, therefore, feature in the report.

Item Ledger

Ledger entries may be viewed in this report; different formats of report are available in addition to several filter options from the drop down lists, so the report may be designed to meet your specific requirements.

Previous: Custom Reporting Tutorial Next: ATC based reports

  • reports/items_and_stock.txt
  • Last modified: 2017/08/30 15:17
  • by gary