Repository navigation
Movement Report Stock By Date
buddhika edited this page Nov 9, 2026
·
1 revision
The Movement Report Stock By Date shows, for each item in a category, how much stock left a department during a period, its sale value, its purchase value and the margin. It also lists cancellations and returns, and disposals and transfer receives.
Pharmacy → Pharmacy Analytics → Item Reports → Movement Report Stock By Date
The report is also available from the ⭐ Favorites tab if you have marked it as a favourite.
- Enter the From Date and To Date.
- Select the Department.
- Select the Category.
- Click Process.
Use Excel to download the table, or Print to print it.
Each item can have two rows. The Type column tells you which one you are looking at:
| Type | What it contains |
|---|---|
| Movement | Stock that left the department: retail sales, sales settled at the cashier, wholesale sales, inward and theatre issues, department issues and transfer issues, and disposals. Transfer receives are also shown on this row. |
| Cancellation / Return | Cancelled sales and issues, and items returned. These are shown as minus figures. |
The totals at the bottom add both rows together, so they show the net movement after cancellations and returns.
| Column | Meaning |
|---|---|
| Quantity | Quantity sold or issued (retail sale, wholesale, inward issue and department issue). |
| Opd Sale | Sale value of retail sales, including sales settled at the cashier. |
| Wholesale | Sale value of wholesale sales. |
| Inward Issue | Value of medicines issued to inpatients and theatre. |
| Department Issue | Value of direct issues and transfer issues to other departments. |
| Total | Opd Sale + Wholesale + Inward Issue + Department Issue. |
| Purchase Value | Purchase value of the quantity in the Total. |
| Margin | Total minus Purchase Value. |
| Disposal Quantity and Disposal (Purchase Value) | Items disposed of, at purchase value. Disposals are not part of the Total. |
| Transfer Receive (Purchase Value) | Stock received from other departments, at purchase value. This is stock coming in, so it is not part of the Total. |
- A sale is counted once. A sale made through Sale for Cashier is counted when the sale bill is made, not again when the cashier accepts the payment.
- When a sale is cancelled, the original sale stays on the Movement row and the cancellation appears on the Cancellation / Return row as a minus figure. The two cancel out in the totals.
- Returns to suppliers, purchases and stock adjustments are not part of this report.