Pharmacy Prescription List - hmislk/hmis GitHub Wiki
Prescription List
Overview
The Prescription List shows every pharmacy retail sale bill for a period, with the referring doctor of each bill. Cancellations, refunds and returns are listed as their own rows with minus values, so the totals at the bottom are net sales.
The figures come from the same source as the Referring Doctor Wise Sale Report, so the two reports always agree.

Prescription List: filters on top, one row of buttons, then the bill list with totals. Bill numbers and totals are hidden in this picture.
When to Use
- To list the bills a referring doctor's prescriptions brought in.
- To check which retail bills have no referring doctor.
- To get a bill-by-bill list of retail sales, net of returns, for a period or a department.
How to Use
Menu path: Pharmacy → Pharmacy Analytics → Retail Sale Reports → Prescription List
You can also click the star beside the button to add it to your Favorites tab.
You can also open it from Prescription Summary (Legacy): click a doctor's name there and the Prescription List opens with that doctor and the same dates already filled in.
- Set From and To. Both include the time. By default they cover today.
- Optionally pick an Institution, a Site and a Department. The Department list shows only the departments of the institution and site you picked.
- Optionally pick a Referring Doctor.
- Tick Only bills without a referring doctor to see only bills where no doctor was entered. Leave Referring Doctor empty when you tick it.
- Click Process, or press Enter in the Referring Doctor box.
The List
| Column | What it shows |
|---|---|
| Bill No | The bill number. |
| Date / Time | When the bill was made. |
| Bill Type | Sale, Cancellation, Return or Return Cancellation. |
| Referring Doctor | The doctor of the original sale, or "No referring doctor". |
| Patient | The patient, or "No patient" when the bill has none. |
| Department | The pharmacy that made the bill. |
| Payment Method | How the bill was paid. |
| Gross, Discount, Net | Bill values. Cancellations and returns are negative. |
The last row shows the number of bills and the totals of Gross, Discount and Net.
Click View on a row to open that bill.
Showing or hiding columns
Open Customize Columns under the list and tick or untick a column. Your choice is saved for your user and is kept the next time you open the report.
Exporting
- Download saves the list as an Excel file.
- Print prints the list.
- PDF saves the list as a PDF file.
The buttons work after you click Process.
Notes
- A sale made through Sale for Cashier is counted once it is settled at the cashier.
- A cancellation or return is listed on the date it was made, under the doctor of the original sale.