Skip to content

Inventory Stock Transfers Report

Buddhika Ariyaratne edited this page Oct 29, 2026 · 4 revisions

Stock Transfers Report

Lists the stock moved between departments in a date range: the goods a department issued, or the goods a department received. Use it to reconcile transfers between stores and pharmacies, or to see what a department sent or received in a month.

Page: Reports → Reports → Inventory Reports tab → 3. Stock Transfers Privilege: ReportsStockTransferReport Favorite key: stockTransferReport (star it to also pin it to the ⭐ Favorites tab)


Filters

Stock Transfers report filters

The filter panel: dates, the issuing and receiving side, item filters, Transfer and Report Type.

Filter What it does
From Date / To Date Transfer bills created in this range.
Issuing/Returning Institution, Site, Department Keeps transfers sent from this institution, site or department.
Receiving Institution, Site, Department Keeps transfers sent to this institution, site or department.
Category / Dosage Form / Item Name/Code Keeps bills that contain a matching item.
Transfer Issue lists the issue bills (with their returns and cancellations). Receive lists the receive bills (with their cancellations).
Report Type Summary, Breakdown Summary, Detail or Bill (see below).
Department Type For example, Pharmacy or Store.

The Department lists follow the Institution and Site you choose; see Reports: Institution, Site and Department Filters.

Which department filter to use

The report groups rows by the issuing department for Issue and the receiving department for Receive.

  • To see what one department sent: Transfer = Issue, set Issuing/Returning Department.
  • To see what one department received: Transfer = Receive, set Receiving Department.

If you choose Receive and set only the Issuing department, the report correctly lists the goods received from that department. The rows are grouped by the departments that received them, so it can look as if the filter was ignored.


Report types

Report Type Shows
Summary One row per store with purchase, cost and retail value, plus the Good In Transit amount. Expand a row to see the breakdown by the other department.
Breakdown Summary Totals per department pair, with quantity and values.
Detail One row per item: bill number, reference bill, item, quantity, rates and values.
Bill One row per transfer bill: department, bill number, date, reference bill, and cost, purchase, retail and net values.

To Print, Download (Excel) and PDF output the same results.

Summary in Excel and PDF

The Download (Excel) and PDF files of the Summary include the same breakdown you see when you expand a row on screen. Each store row is followed by its breakdown rows, with three extra columns:

Column Shows
Category The other department of the transfer, as on screen (for example To: Inward for an issue, From: Main Pharmacy for a receive).
From Department The department that sent the goods.
To Department The department that received them.

The store row and the total row leave these three columns blank.

Stock Transfers Summary PDF with Category, From Department and To Department columns (values hidden)

Summary PDF for Transfer = Receive. Each store row is followed by its breakdown rows. Values are hidden in this picture.

Before issue #19246 was fixed, the breakdown rows in these files showed only the category and the values, without the From and To departments.


Bills with incomplete data

Every transfer bill in the range that matches the filters is listed, even when part of its data was never saved. For example:

  • A bill with no department recorded.
  • A cancelled issue with no link to the original bill.
  • An older bill saved before value details were recorded. Its purchase, cost and retail values show as 0 until an administrator fills them in (see below).

In the Summary, a bill with no department at all is grouped under (No department).

Before issue #24702 was fixed, the Bill and Summary views silently left such bills out. They could show fewer bills, and lower totals, than the Detail view for the same filters.

Older transfers that show zero values

Transfer bills saved by older versions of the system have no value details, so every view shows 0 purchase, cost and retail value for them, even though the quantities are right.

Breakdown Summary for an older week: quantities shown but every value is 0.0

Before: an older week of transfer issues. Quantities are listed, but all values are 0.0.

An administrator can fill in the missing values once, period by period, with the Backfill Transfer Finance Details API (POST /api/pharmacy/backfill_transfer_bifd, Finance API key). It works out the values from each item's saved purchase and retail rates and its batch. When the batch has no cost rate, the cost value uses the purchase rate. It only fills empty values, never changes saved ones, and can be run first with dryRun to preview the totals. After it runs, the report shows the values for those periods:

The same week after the backfill: purchase, cost and retail values filled in

After: the same week, with purchase, cost and retail values.

Ask your system administrator to run it; the request format is in the developer API guide (developer_docs/api/using-apis/API_PHARMACEUTICAL_MANAGEMENT.md, section POST /api/pharmacy/backfill_transfer_bifd).


Related

Clone this wiki locally