Free Items Received Report - hmislk/hmis GitHub Wiki
Free Items Received Report
Path: Pharmacy > Pharmacy Analytics > Procurement Reports > Free Items Received (GRN / Direct Purchase)
Shows the free items suppliers gave you as part of a purchase, with the quantity received free and what those items are worth. Use it to see which suppliers give the best free-item offers, how much free stock an item brings in, and to check individual GRNs.
Only lines that have a free quantity are listed. Items received from GRNs and Direct Purchases are included. Cancelled bills are left out.
Returns to the supplier are deducted (issue #24667). Each line shows the paid and free quantity received, the quantity returned against it through a GRN Return or Direct Purchase Return, and the Net Paid Qty and Net Free Qty left after those returns. When returns are made by total quantity (paid and free together), anything returned beyond the paid quantity received is counted as returned free stock. A return counts whatever its date, as long as it is approved (or, for older returns, it has already left stock) and has not been cancelled. A line whose free quantity was returned in full stays in the report with a Net Free Qty of 0.
Free Value is the net free quantity multiplied by the item's purchase rate (unit price), the value of the discount the free items still represent after returns.
- Free items on a normal line use that line's purchase rate.
- A free-only line (Paid Qty 0) has a value only if a purchase rate was entered on it. With no rate, its Unit Price and Free Value are 0.00. Entering a rate on free-only lines is encouraged, but it is not required.
- GRNs saved before this rule did not keep the rate on free-only lines. For those lines the report uses the purchase rate that was entered on the line, net of any line discount and worked out per unit, so they show a value too. If the rate entered was 0, the line stays at 0.00.
Filters
- From / To: the date the items were received. Defaults to today.
- Department Type: tick one or more types (for example Pharmacy, Inward, Theatre). Leave it empty to include all department types.
- Institution, Site, Department: the department that received the items. Leave as All to see every department.
- Supplier: start typing the supplier name. Leave it blank for all suppliers.
- Item: start typing the item name. Leave it blank for all items.
- Report Type: how the results are shown, see below.
Click Process to run the report. Excel downloads the table on screen, and Print prints it.
Print shows only the report itself. The per-column search boxes and the page navigation (paginator) that appear on screen are left out of the printout, so the printed page carries the headings, rows and totals without the on-screen controls.

Print output: the column search boxes shown on screen are not printed. Report rows are redacted here.
Totals are shown above the table: net free quantity, net free value, net paid quantity, number of GRN / bills, and number of lines.
Report types
| Report Type | Shows |
|---|---|
| Detail (default) | One row per free-item line: Received Date, Type (GRN or Direct Purchase), GRN No, Invoice No, Department, Supplier, Item Code, Item Name, Paid Qty, Returned Paid Qty, Net Paid Qty, Free Qty, Returned Free Qty, Net Free Qty, Unit Price and Free Value |
| Supplier-wise Summary | One row per supplier, highest free value first |
| Item-wise Summary | One row per item, highest free value first |
| Date-wise Summary | One row per day |
Each summary row shows the number of bills and lines, the net paid quantity, the net free quantity and the free value, all after returns. A total row is at the bottom.
In the Supplier-wise and Item-wise summaries, click Details on a row to open the Detail view for just that supplier or item. The Supplier or Item filter is filled in for you, so clear it before you run the report for everyone again.

Detail view: on the Direct Purchase line, 2 paid and 1 free were returned, so Net Paid Qty and Net Free Qty are 0. On the GRN line, 1 of the 3 free items was returned, leaving 2 (Free Value 200.00). GRN numbers, invoice numbers, suppliers and codes are blurred.

Supplier-wise Summary: free quantity and free value per supplier (screenshot taken before returns were deducted; the columns are now Net Paid Qty and Net Free Qty). Click Details to see that supplier's GRN lines.
Access
The button needs the Pharmacy Analytics - GRN Purchase Items by Supplier privilege, found under Pharmacy Analytics > Procurement Reports in the privilege tree. It is shown when the configuration option Pharmacy Analytics - Show GRN Purchase Items by Supplier is enabled. Click the ⭐ beside the button to add it to your Favorites tab.
This report replaces the earlier GRN Purchase Items by Supplier report. The privilege and configuration option kept their old names, so existing access and favourites still work.