Stock lifecycle

Book-in → open → use → finish → adjust → labels → search. Actor is always the logged-in user.

Book in ──► Open ──► Use ──► Finish
   │
   ├── Adjust (volume / expiry / storage)
   └── Label / QR

Lists

The application name opens the dashboard. Inventory → List of Reagents shows unopened and open counts against the minimum. Use the rest of Inventory for lots:

Inventory Items In Stock table with laboratory scope, barcode, dates and storage
Inventory → In Stock. A Status column shows Expired (red, or yellow when the project is research and a risk assessment covers expired use) and Quarantine (open lot still needing validation).

Book in

Add → Inventory Item (admins) or New Inventory Item (lab users). First select the reagent, then complete lot, quantity/volume, lab scope, condition, dates, PO, expiry, project, and storage. Note the barcode(s) assigned. New barcodes are 4 random characters (look-alike characters 0, O, 1, I, and L are skipped). Existing codes such as NGS-J1G2 stay as they are. Save stays disabled until the page finishes loading, so a second click does not book the same receipt in twice. A receipt of many units writes one audit row per barcode.

Booking into a different lab than the reagent home lab may widen the reagent to shared across labs (warning shown); lot ownership stays as chosen.

Number Received controls how many lots receive individual barcodes. Item measurement unit starts with the reagent's recommendation and can be changed for this booking. Received Quantity is the required amount in each barcoded lot in that unit. Unit defaults to 1; enter volume or mass manually. Example: 3 containers of 100 ml means Number Received = 3 and Received Quantity = 100 ml per barcode. A bottle can be one Unit used in parts, or a box of 50 pipettes can be 50 Units behind one barcode.

Existing lots keep the booked description, manufacturer, units and handling settings when catalogue defaults change. Current COSHH safety updates remain visible on existing stock. See Reagent documentation.

Volume booking with Number Received and required Received Quantity in reagent units
Number Received controls the number of barcodes; Received Quantity is the amount in each barcode.
Select Reagent to Book-in
Step 1: Select Reagent to Book-in, then book-in.
Searchable reagent dropdown
The reagent list is searchable. Type part of the name or catalogue number.

Item page: usage table

Each lot keeps a Usage & attribution table under Date Received / Received By. Opening is the first row; later Use item rows sit under it; Finish / Discard is last. Every usage is kept (dates plus project, process, experiment, consumers, notes, last updated, recorded by).

  1. Open Item — date, project/process/experiment/consumers, FEFO justification if prompted. Confirm storage and attribution; they seed the usage trail. Opening a lot that is already open returns to the item page and says so; it does not add another opening row.
  2. Use Item — record the quantity or volume used, date, notes, attribution and any return location. A multi-unit lot records how many units were used from that barcode and reduces its remaining quantity. The usage table is not overwritten.
  3. Finish / Discard Item — last usage row, same attribution fields, plus reason. Finishing a lot that is already finished says so and does not write a second finish row.
  4. Record usage under the table is the same form as Use item.

Open, use, finish, validate, adjust, transfer, and label download/reprint from the item page are written to that lot’s audit trail.

Opening warnings compare stock within the item's own lab. Open stock in another lab is optional sharing information with the lab and location; it does not require justification to open your own stock. Same-lab warnings may still require an explanation.

If a booked lot shows Not recorded for quantity, open Use item and enter Received Quantity and Quantity Used together. Choose the unit if it was never recorded. Existing amounts and earlier usage are retained; remaining stock is calculated automatically. The entered receipt details and the new use are saved together in the audit trail.

For Unit items, choose Half a Unit (0.5), Quarter of a Unit (0.25), or enter any amount such as 5 Units from a box of 50. Quantities support up to six decimal places. Choose ml or another measured unit when exact volume or mass is needed.

On Use item, tick Change this item's measurement or received quantity to choose a new unit and received total. Check the amount remaining before this use and give a reason. Where possible the form suggests a remaining amount that preserves the fraction left; replace it with a measured amount if needed. Enter today's usage in the selected unit and save once. The audit trail keeps the previous and new state; earlier usage keeps its original quantities and units. Reagent defaults and other items are unchanged. Reload if another person changes this item's balance first.

COSHH safety information is at the bottom of the item view, after usage, validation and audit history.

Opening form with same-lab warning and optional other-laboratory information
Same-lab opening checks and optional sharing information from other labs are separate.
Use Item form with quantity used from a multi-unit lot
Record the amount used from this barcode, with its usage attribution.
Item page with current safety information, quantities, usage and audit trail
Lot summary, received/opened/validated row, Usage & attribution, validation status, and this-lot audit trail. Download label.xlsx reprints this barcode without going through the bulk label file.
Actions on the item are only offered when the lot belongs to your active laboratory. Otherwise the page stays readable and shows a banner to switch lab or request a transfer.

Finish / adjust / expiry

  1. Finish Item — reason + date (consumed, disposed, failed validation, stability…).
  2. Actions → Adjust stock record — correct Received Quantity, quantity remaining and the item's measurement unit together, for opened or unopened Unit, volume or mass items. Missing booking amounts can be entered without recording consumption. Explain the correction; previous quantities and units remain in the log. Change expiry or storage separately from quantities.
  3. Expiry cannot be before the received date. A reagent made from a recipe cannot be dated later than the earliest expiry of the components it was made from.

Finished the wrong barcode? Choose Actions → Restore item on its item page. Check the received total and actual quantity still available, explain the mistake, tick the confirmation and save. Where possible the latest finish record supplies a suggested remaining amount; an item emptied through usage needs that amount entered explicitly. The same barcode becomes available with its original opened/unopened status and validation. Earlier finish and usage entries stay visible, followed by Restored, with before/after states and the actor in the audit trail. Only the owning active laboratory can restore stock, and read-only system mode blocks restoration.

Adjust stock record with received quantity, quantity remaining, item unit and explanation
Correct the total received and the amount remaining for this barcode without booking usage. Earlier values remain in the adjustment log and audit trail.

Expired and quarantine lights

The reagent list, the inventory list, and the item page show:

Finished lots show neither light. Tick Research project and Risk assessment covers expired use under Edit Data → Project. The risk-assessment tick is only accepted on a research project.

Labels

  1. Item page → Download label.xlsx or label preview / reprint (witness if required).
  2. Inventory → Download label file — choose the Laboratory printer if you belong to multiple labs. Each Excel file contains only that lab's pending labels and marks only those items as printed. Unassigned items have a separate file. Reprint a single barcode from its item page when needed.
Laboratory printer selector for pending label files
Printer files are separated by laboratory and include only pending labels for the selected lab.

Search

Search (magnifying glass) finds a barcode, reagent name, catalogue number, supplier, lot, or PO. Finished lots are included by default (Include Finished Items? = YES). Open lots stay included unless you turn that off.

Lots migrated from NGS or IOB keep codes such as NGS-J1G2 and IOB-J1G2. Search matches the full code and the short code (J1G2). New lots are given a random 4-character code that does not start with a required J and does not use 0/O or 1/I/L. Autocomplete can fill a labelled value and still find the lot.

As you type, matching values appear; if there is no exact hit, closest matches are ranked (prefix, contains, fuzzy), limited to your laboratory scope.

Search inventory form with a demonstration barcode
Search inventory. Date ranges have Today −1 Month / −6 Months / −1 Year shortcuts.
Barcode field showing NGS autocomplete suggestions
Typing in Barcode (here NGS) opens labelled matches such as NGS-J001. The same autocomplete exists on reagent, catalogue #, supplier, lot, and PO.

For many barcodes at once use Reports → Barcode lookup.

Undo

Admin undo is for genuine data-entry mistakes only. Prefer Adjust so the audit trail stays complete. Stocktake exists at /stock/stocktake/ but is not on the main menu.