Product Batch Tracking Report
Lists every transaction of one batch of a product managed by Batch, and how much of the batch is left.
Menu: Reports › Product Reports › Product Batch Tracking Report
What it's for
Use it for recalls and expiry checks: it shows where a batch came from, which customers and branches received it, and the Total Remaining Qty.
A supplier recalls batch L2401 of Paracetamol 500 mg. The pharmacist picks the product, enters the batch in Batch No. and sees 50 boxes received, 42 sold to 9 customers and 8 remaining. She pulls the 8 boxes from the shelf and contacts the customers.
Options on the screen
- Product Selector: pick the product.
- Batch No.: the batch to trace.
Filters
Click Filters to narrow the report. You can filter by:
Product Name, Expiration Date, Manufacturing Date, Admission Date, Manufacturer Warranty Start, Manufacturer Warranty End, Remarks.
Columns
| Column | What it shows |
|---|---|
| Transaction Date | The transaction's date. |
| Transaction Type | The kind of transaction. |
| Sheet No. | The transaction's sheet number; click it to open the transaction. |
| Created For | The branch the transaction is for (whose stock or money it affects). |
| For Location | The branch location whose stock the transaction affects. |
| Particular | The supplier, customer or branch on the other side. |
| Parent Category | The category one level above the product's category. |
| Qty | Quantity of the batch on that transaction. |
| Price | Price per unit on the transaction line, after line discounts. |
| Amount | Line amount: quantity × price. |
| Name | The product name. |
| Deleted | Whether the transaction has been deleted. |
Also shows: Category, Stock No., Barcode.
For searching, express filters, sorting, column settings, exporting and printing, see About reports.