Inventory Reports

There are 2 Inventory reports available for CommCare Supply deployments

•  Inventory by Location

• Aggregate Inventory

Inventory by Location

Select the desired Location, Program and Date filters. The filtered locations/facilities will be shown along the far left column while the product names appear horizontally. The corresponding data in the table shows the amount of stock for each product per location on the filtered date. A "0" reflects a stock out, while "no data" means that no movements were ever entered into the system for that product at that location.

Open

Aggregate Inventory

This is the process of counting the total numbers of units of products at any given time. In order to enable views of monthly consumption and months of stock on hand, select "show advanced columns" This report includes: 

1. Stock on Hand (total quantities of usable stock available. Items that are unusable are not considered part of stock on hand but losses to the system) 

2. Monthly Consumption (total average of the quantities of product dispensed to users in the most recent three months, as appropriate) If both location and program filter are not specified, Months of Stock 

3. Months of Stock : remaining stock measured in months, this gives an assessment of how long the coartem supply in the clinic will last. It is the result of dividing Stock on Hand by Monthly Consumption)

4. Stock Status (the status is decided by two factors: Stock Level settings and the remaining MOS.) You can alter the values that correspond to these definitions by manually setting the Stock Levels.

   1.  If Remaining MOS < Emergency Level/Low Stock level, understock; 

   2.  If Remaining MOS > Adequate & Remaining MOS < Overstock level, adequate

   3.  If Remaining MOS > Overstock level, overstock

Open