# 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 1. Enter the **From Date** and **To Date**. 2. Select the **Department**. 3. Select the **Category**. 4. 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.