The best report to run for this would be Product Usage Trend Analysis
To run this report:
- Navigate to Modules -> Data Viewer
- Sign in using your dispensary PIN number
- Select the Stock module
- Select the Product Usage Trend Analysis - select it again from the blue bar
-
Select a From and To date
-
Click Run Report
- A report similar to the below will then be displayed
When the report is run, filter the following columns with = 0:
- You can do this by selecting the cog and ticking the box to the left of 0.00
- Qty Disp, -1
- Qty Disp, -2
- Qty Disp, -3
- Qty Disp, -4
- Qty Disp, -5 Filter the following column with > 0
- Qty Dispensed - In Date Range
- See report example after I have applied the above filters - Note: I have filtered the report even further by selecting the columns I wanted to see.