Movement Report Stock By Date¶
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.
How to open it¶
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.
Running the report¶
- 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.
What the report shows¶
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. |
Good to know¶
- 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.