Items

Managing your catalogue

An item in Open mSupply is usually a product that you purchase from a supplier, hold in stock and supply to a customer. From the Items menu, you can view all of the items that are currently visible in your store.

Viewing items listšŸ”—

In the navigation panel, tap on Catalogue > Items to show the items list:

Items nav

You can see all the items which are available for use by your store:

The Items list is divided into 6 columns:

ColumnDescription
CodeCode assigned to this item in mSupply
NameThis is the name by which mSupply will refer to the item
UnitThe unit of measure for the item
SOHHow much stock is available in your store
AMCAverage Monthly Consumption. This is how much stock your store uses each month on average (based on a configurable number of months, defaults to 3 months).
MOSNumber of months of consumption left with current stock. This is calculated as: Stock on Hand / AMC.

Items list

Viewing an item's detailsšŸ”—

To view the details of an item, simply tap on one. A new window opens:

Item detail

On top of the screen, you can the following information:

  • Stock on Hand: How much stock is currently available in your store
  • AMC: Average Monthly Consumption. This is how much stock your store uses each month on average (based on a configurable number of months, defaults to 3 months).
  • Months of Stock: Number of months of consumption left with current stock. This is calculated as: Stock on Hand / AMC.
In the below example, we have 20,219 units of Acetylsalicylic Acid available in our store. The average consumption is 3,443.67 units per month which means that there is the equivalent of 5.87 months of stock in the inventory.

Item detail headers

There are two tabs in the bottom part of the screen:

  • General: The item's basic information
  • Master Lists: Master lists associated with the item

GeneralšŸ”—

DetailsšŸ”—

  • Name: This is the name by which mSupply will refer to the item
  • Code: This should be unique for each item and is a helpful shorthand for referring to items
  • Unit: The unit you use for this item. It is useful to distinguish items you issue by pack (eg. eye drops) from items you issue by volume (eg. oral liquids)
  • Strength: For a medicine, the concentration of its active ingredients (eg. for Amoxillin 250mg, the strength is 250mg)
  • Defined Daily Dose: The assumed average maintenance dose per day for a medicine used for its main indication in adults
  • Type: The type of item (eg. Stock or Service)
  • Doses: For vaccines, the number of dose per vial
  • Vaccine (check box): If this is checked, this item is a vaccine and a number of dose can be assigned

CategoriesšŸ”—

  • ATC Category: ATC stands for Anatomical, Therapeutic, Chemical and is a method of classifying entities, and identifying them by category
  • Universal Name: if the item is linked to the universal drug code database, this shows the universal, or generic name for the given item
  • Universal Code: similarly, the code allocated to the universal drug code item

PackagingšŸ”—

  • Default pack size: This is the default pack size that will be assigned to incoming stock as it is received
  • Outer pack size: The number of units in a carton (outer pack). Not the number of preferred pack size packs in a carton (outer pack).
  • Volume per pack: The default volume per preferred pack size pack. This is the volume that will be used by default when receiving goods. We recommend you divide a carton volume by the number of preferred pack size packs in a carton to get this figure. Open mSupply always stores volumes in m3 (cubic metres), but you can enter a volume as millilitres (ml) or litres (l) by entering the appropriate abbreviation after the number representing the volume. e.g. enter ā€œ0.5lā€ to enter a volume of 0.5 litres (= 0.0005m3).
  • Volume per outer pack: The default volume of an Outer pack size pack of this item
  • Weight: The weight of a preferred pack size pack in kg

PricingšŸ”—

  • Margin: This is the default margin that will be applied to this item on Inbound Shipments to calculate the selling price

Master ListsšŸ”—

This tab lists the Master Lists associated with this item. Item detail headers

Item VariantsšŸ”—

On the Open mSupply Central Server, a third tab, Item Variants, is available. This tab allows you to configure variations of the item, such as different manufacturers or packaging sizes.

Currently, Item Variants are only used for GAPS functionality.

variants tab

Adding an Item VariantšŸ”—

To create a new Item Variant, click the Add Variant button in the top right corner.

add variant button

This will open a new window, where you can enter a name for the variant, and its details:

add variant window

Temperature options are configured as Location Types on the mSupply Central Server. Manufacturers are also managed in mSupply.

PackagingšŸ”—

Different facilities work in different levels of packaging, e.g. a warehouse may work in cartons, while a clinic works in boxes or individual units. In the Packaging section, you can define the pack size (units per pack) and packaging volume for the different packaging levels of an item variant.

This allows GAPS calculations to accurately account for the cold storage requirements for this item variant, at the packaging level used by a particular facility.

The pack sizes defined in Item Variants are used for GAPS calculations ONLY, to provide greater accuracy across item variations. It does not affect the pack sizes used in your usual ordering workflows in Open mSupply.

Editing an Item VariantšŸ”—

To edit an Item Variant, click the Edit button next to the variant you wish to update.

edit variant button

This will open the same window as when adding a new variant, with the existing details pre-filled. Make any changes you need, and click OK to update the variant.

edit variant window

Deleting an Item VariantšŸ”—

To delete an Item Variant, click the Delete button next to the variant you wish to remove.

delete variant button

You will be asked to confirm the deletion. Click OK to confirm, or Cancel if you no longer wish to delete the variant.

Bundling itemsšŸ”—

You can also add bundled items to each Item Variant. These are other items that are always issued with this item, so GAPS calculations should consider the storage required for all items in the bundle.

Bundled items are not implemented in dispensing workflows in Open mSupply. You still need to dispense each item in the bundle separately.

Bundling is done at the Item Variant level, giving you fine-grained control over which variants should be bundled together. For example, a vaccine may only be able to be bundled with a specific diluent from the same manufacturer.

Adding bundled itemsšŸ”—

To bundle an item with the current variant, click the Add bundled item button under the Bundled with section.

This will open a new window, where you can search for the item you wish to bundle with the current variant.

After selecting the item, you will be prompted to select the specific variant of that item, along with the ratio at which it should be bundled.

In this example, 0.2 units of Silverfern Normal Saline should be bundled with every 1 unit of Silverfern Adsorbed (Paediatric) DPT Vaccine.

Click OK to add the bundled item. It will then appear in the Bundled with section.

item variant with bundled item

Editing bundled itemsšŸ”—

To edit a bundled item, click the row in the Bundled with section. This will open the same window as when adding a new bundled item, with the existing details pre-filled. Make any changes you need, and click OK to update the bundle.

Removing bundled itemsšŸ”—

To remove a bundled item, click the Delete icon next to the item you wish to remove.

remove bundled item button

You will be asked to confirm the removal of the bundled item. Click OK to confirm, or Cancel if you no longer wish to remove it.

Item variants that are a part of bundlesšŸ”—

You aren't able to bundle items for an item variant that is already part of another bundle.

The Add bundled item button will be disabled, and you will instead see a list of the item variants that this variant is already bundled with.

item variant part of another bundle