Server started 2026-11-02 13:18 UTC
2.1.11 (2026-11-02) • Finished or discarded items have a Restore item action. Users confirm the actual remaining amount and explain the mistake. The item keeps its barcode, opening and validation details; original finish and usage records remain, with a new restoration entry and before/after audit. Stock counts are recalculated, repeated submissions are harmless, and stale restoration forms are rejected. • Adjust stock record can correct received quantity, remaining quantity and the item measurement unit together for opened or unopened stock, including unit items and missing booking amounts. Corrections do not record consumption. Previous totals and units remain in the adjustment log and audit trail; laboratory ownership and read-only restrictions still apply. • Requires migration 0043_restore_and_quantity_corrections to retain received quantities and original measurement units in adjustment records and add the Restored history event. 2.1.10 (2026-11-02) • Each barcoded item can use its own measurement unit and received quantity at booking. Reagent measurement settings are recommendations for new bookings; changing an individual item does not alter the reagent or other lots. • Unit items support decimal usage, including Half (0.5) and Quarter (0.25) shortcuts. A bottle can be counted as one Unit and used in parts, or a box can contain 50 Units with five used at a time. Measured volume and mass also accept decimals, up to six places. • Use item can change the selected lot's unit, received total and remaining balance before recording usage, with a required reason and an audit of the previous and new state. Historical usage retains its original unit, and stale measurement changes are rejected. • Stock lists separate quantities in different units. Reports, receipt records, stock corrections and stocktakes retain decimal quantities and item units. Includes database migration 0042_item_measurements. 2.1.9 (2026-11-02) • Use item accepts a missing received quantity and the amount used in one submission, with a unit choice when none was recorded. Existing quantities and recorded usage are retained, remaining stock is calculated automatically, and the recovered values and usage are audited together. • COSHH safety information appears at the bottom of the item view, after usage, validation and audit history. 2.1.8 (2026-10-29) • Updated the illustrated user guides for laboratory scope, manufacturers and COSHH, booked-item snapshots, quantities and usage, storage moves, laboratory printer files, reporting and system audit history. Added a repeatable local Playwright check using a temporary database and demonstration screenshots. • Fixed login rejecting otherwise valid usernames and passwords longer than 20 characters. Passwords retain intentional leading/trailing spaces during authentication. • Fixed the reagent detail page failing to render because its COSHH edit-button condition was not closed; the record remains readable for laboratory users while safety editing stays admin-only. • Included user-guide screenshots and COSHH pictograms in source-control asset rules so packaged pages retain their illustrations after a fresh checkout. 2.1.7 (2026-10-29) • Project and Experiment reports show the results first. Output configuration and downloads appear below the results table only when matching items are found. 2.1.6 (2026-10-29) • Project and Experiment reports share the barcode lookup's output configuration: stock and usage column choices, PDF/Excel/CSV tables, and a printable Reagent Usage Log with an optional experiment reference. Selected columns also control the on-screen preview. Report filters, laboratory scope and export audit records are retained. 2.1.5 (2026-10-29) • Fixed browser controls blocking barcode dragging on the Storage map. Reagent labels can also be dragged directly between shelves and “Not on a shelf yet”. When several items share a label, choose one barcode before confirming the destination, reason and explanation. Moves continue to retain their previous location in the audit trail. 2.1.4 (2026-10-28) • Undefined COSHH classifications no longer show a question-mark badge. COSHH status choices and hazard checkboxes clear conflicting selections automatically. Returning with the browser Back button restores form submit buttons, including Search, while retaining double-submit protection. 2.1.3 (2026-10-28) • Reagent add/edit forms show main reagent details first and COSHH fields and safety reminders in a separate section afterwards. 2.1.2 (2026-10-28) • Reagents support multiple COSHH/CLP hazard types from the COSHH SOP, with its pictograms across reagent and stock lists. Reagent and item pages show type-specific reminders plus SDS, assessment references and recorded substance-specific controls. Unassessed stock is explicitly marked; current safety markings apply to existing lots, and booking snapshots and audit history retain classification changes. 2.1.1 (2026-10-28) • Opening warnings and justification requirements compare stock within the item’s own laboratory. Open stock in other laboratories is shown as optional sharing information, with the owning lab, location and barcode; it never requires a justification to open your own stock. Earlier-expiry recommendations also stay within the same laboratory. 2.1.0 (2026-10-28) • Reagents have a separate manufacturer. Administrators can add, edit and deactivate manufacturers from Add / Edit Data. Booked items retain the manufacturer name recorded at booking, and changes are audited. • Existing barcoded stock retains a snapshot of its booked reagent description, units and handling settings; catalogue edits apply to future bookings. Existing data is frozen from its current known settings during migration. • Administrators can browse the system audit trail from Inventory, filter by actor, action, record, laboratory and dates, and page through before/after changes. Normal saves, batch updates and deletes retain record states. • Missing volume and invalid usage form values are handled without crashing item and usage pages. • Item pages handle volume-tracked records with missing received/current volume values; affected items show a data warning and cannot be used until corrected. • Booking records a quantity and unit for each individually barcoded lot. Using a lot records the amount or volume used, updates its remaining quantity, and shows the amount in the usage history and stock reports. • Inventory list pages and the storage map share a four-option laboratory switch: active lab only, active lab plus generic/shared reagents (default), all your labs, or all labs. The selected scope filters the reagent catalogue and item lists. • The storage map links reagent names to their reagent record and lets users move individual lots between shelves or back onto the unit by drag and drop. Each move records a reason and explanation in the stock adjustment log and audit trail. • Bulk storage moves include items whose reagent is assigned to the selected lab even when an older stock row has no lab owner. Unassigned legacy items stay excluded, with a message explaining the ownership data that needs correction. • Edit Data includes a reviewed bulk storage move for opened and unopened items belonging to lab-owned reagents. The user reviews the item list, acknowledges suitability warnings when present, and confirms the move before locations change. • Barcode label downloads are separated by laboratory. Users with multiple laboratories choose the printer's laboratory before downloading, and each file marks only that laboratory's items as printed. • Opening a discrete stock item no longer fails on MySQL when the cached reagent count is already zero; the unopened count is kept at zero instead of underflowing. 2.0.17 (2026-10-20) • A study can have its own worksheet template. Design it under Add → Worksheet template and change it under Edit Data → Worksheets. The template names the reagents that come from stock and the boxes that are typed or written by hand. • Add → Worksheet saves one filled sheet for that study. Reagent lines offer the open lots first, with barcode, lot, storage, and expiry. Empty boxes can be completed on the printout. Inventory → Worksheets keeps each saved sheet with who did the work and which lots were used. • The paper sheets R002, R004, R008, R009, R010, and S011 are loaded as examples. Pick one when adding a worksheet and choose the study it belongs to. Link a reagent line to stock before its lots appear. 2.0.16 (2026-10-20) • Inventory rows and the reagent list show a traffic light for expired stock and for quarantine. Expired stock is red. It is yellow when the lot’s project is a research project and a risk assessment covers using it after expiry. Quarantine is an open lot that still needs validation. • A reagent made from a recipe takes the shelf-life expiry from the date it was made, and that date is not later than the earliest expiry of the components used. 2.0.15 (2026-10-20) • Storage locations can sit inside each other. The NGS fridges, freezers, and the -80 at JR are renamed in the same style as the IOB units (NGS - JR …) and now have named shelves and doors. Lots that were already on those units stay on the unit until someone moves them onto a shelf. • Inventory → Storage map draws each unit with its shelves and door, a mark for each reagent stored there, and a table you can print. 2.0.14 (2026-10-07) • Booking in many units at once no longer fails. The audit used to store every new barcode in one 80-character field, so a receipt of about 17 or more units was rejected and nothing was saved. Each unit now has its own audit row. • Mark as not needed and Copy selected on the procurement tracker record one audit row per selected line. A large selection used to overflow the same field, and that audit row was dropped. • The barcode label file leaves the project column blank when no project was entered at book-in. It no longer writes ClinIO in that case. • Clicking Save again while a form is still sending does not submit it a second time. The buttons stay disabled until the page finishes loading. Download and export buttons can be used again after a short pause. • Opening a vial twice no longer writes extra opening records or reduces the unopened count below zero. A second open returns to the item page and says the item is already open. • Finishing a lot twice no longer writes a second finish record or reduces the open count again. A second finish says the item is already finished. • Mark as not needed and Copy selected stay disabled until that tracker request finishes. 2.0.13 (2026-10-05) • A recipe batch now requires a witness: another user, not the person entering it. This applies when booking in a new recipe and when making a solution from an existing recipe. The item page shows Witnessed By. • New barcodes are 4 random characters, not a sequence, and do not have to start with J. Characters that are easy to confuse are skipped (0, O, 1, I, L). Migrated barcodes such as NGS-J1G2 and IOB-J1G2 stay as they are. A new code will not reuse a 4-character ending already used by a labelled barcode. • After login the first screen is the dashboard (/stock/dashboard/). The logo goes there. Inventory starts with List of Reagents; Dashboard is not in that menu. • List of Reagents is one header line: the page title, a short explanation, and a switch for this lab, all of your labs, or all labs. The selected switch is the scope; there is no separate “showing stock for…” message. • Inventory lists page on one line: Previous, page numbers, Next, and the range (for example 1–200 of 250). • Scheduled jobs (low stock emails, open-vial emails, pending-transfer emails, integration export, and volume-counter rebuild) run only for a call from this server (127.0.0.1) or a call that sends X-Cron-Token matching CRON_TOKEN. Anyone else gets Forbidden, and the job does not run. 2.0.12 (2026-09-22) Making a recipe now records when it was made, does not ask for a witness, and lets you enter the volume used and the total volume of each ingredient unit when you select its barcode. On Inventory → book in a recipe: Date made is required. It defaults to today, and the expiry date is the shelf life counted from that date. The witness field is gone. New batches are saved with no witness. Each ingredient row shows the barcode plus Unit volume and Volume used. If the unit volume is already on the lot, it is shown (with the amount left for volume-tracked lots). If it is not, you can type the total volume of that unit. For a volume-tracked recipe, Volume of each unit made is the volume stored on each new item. Volume used on a volume-tracked ingredient is still taken off that lot. For other ingredients, the volume used and the unit volume are recorded on the new item and shown next to that component. 2.0.11 (2026-08-21) • Welcome and password-reset emails now send from the configured Gmail account (previously a mismatched From address meant mail did not arrive). • Admin Reset password emails the temporary password even if Emailed is already ticked. • A forced password change can no longer be skipped by reopening login, using the menu, or opening admin. 2.0.10 (2026-08-21) • Search inventory: barcode and reagent name fields no longer reject labelled barcodes (e.g. NGS-JKJM) or full reagent names; catalogue, supplier, lot, and PO search lengths match the stored data. • Barcode search matches both the labelled code (NGS-JKJM) and the short code (JKJM); autocomplete can fill the labelled value and still find the lot. • Search includes finished/closed lots by default (Include Finished Items? = YES). Open lots stay included unless you turn that off. • Edit Data → Edit users (superusers only) opens the Django user list for accounts and staff flags. • Admin user save and Reset password no longer error when a user has no password-reset row yet; missing ForceReset / login-security rows are created on save. • Note: migrations `0031_alter_internal_options` and `0032_alter_internal_batch_number` are required (barcode field length aligned with labelled LAB-XXXX codes). 2.0.9 (2026-08-19) • Item page usage is a history, not a single current block. A Usage & attribution table sits under Date Received / Received By. • Opening is the first usage row; later Use item rows sit under it; Finish / Discard is the last row. Every usage is kept (dates plus project, process, experiment, consumers, notes, last updated, recorded by). • Use item records a new usage with a date; it no longer overwrites the previous attribution. Record usage under the table is the same form. • Existing lots are backfilled: earliest attribution is opening, later rows are uses, and a finish/discard row is added when the lot is already finished. • Item-page actions are written to that lot’s audit trail: open, use, finish/discard, validate, stock adjust, transfer request/decision (stored against the lot), label download, and reprint. • Note: migration `0030_usageattribution_event_history` is required. 2.0.8 (2026-08-19) • Menus regrouped into Inventory, Procurement, Reports, and Edit Data; the plus menu is labelled Add. • Inventory: Dashboard, All, In Stock, Expiring Soon, Solutions, Validated, Not validated, Transfer Requests, Download label file; Recipes stay under Inventory for lab users. • Procurement: Tracker, Reorder forecast, Supplier performance; admins also have PO / receipts / invoice. • Reports: Inventory, Barcode lookup, Project, Experiment, Recharge billing; admins also have Role review export. • Add (admins) is only Inventory Item, Reagent, and Recipe. Lab users still have New Inventory Item. • Edit Data dictionaries (one line each): Supplier, Project, Process, Experiment, Internal consumer, External consumer, Storage location — each screen lists entries with Edit, Activate/Deactivate, and Add on the same page. Separate De/Activate commands for those lists are removed. • Edit Data still has Recipes, Edit Reagent, De/Activate Reagents, default supplier/storage/minimum tools, supplier approvals/catalogue, and System Mode / Continuity. • Removed from the menu (URLs still work): protocol picking, stocktake, List View, barcode scan, report catalog, stock report, downtime pack, items-to-order. 2.0.7 (2026-08-18) • Operational dashboard is visual: metric cards show each count against its total (low stock, expiring ≤90 days, open-vial, not validated, transfers), plus stock-by-laboratory, open vs unopened, expiry profile, and recent receipts. • Analytics dashboard is folded into Inventory → Dashboard (`/stock/reports/analytics/` redirects there). • “Stock number” renamed to “Barcode” on search, item, lookup, and label forms; Search finds a barcode. • Download label file page explains it exports items booked in since the last download (not yet printed). 2.0.6 (2026-07-20) • Search page suggestions: as you type in Stock Number, Reagent Name, Catalogue Number, Supplier, Lot Number, or Purchase Order, the form now shows matching values in a dropdown. • Closest-match fallback: when there is no exact match, the suggestions API ranks and shows the nearest values using prefix, contains, and fuzzy matching. • Suggestions respect the current laboratory inventory scope and can be selected by mouse or keyboard. • Search suggestions endpoint: `/stock/search/suggestions/`. • Procurement tracker UX: removed the “Not ordered yet” / “Ordered, not received” filter checkboxes; status filtering now uses the Status dropdown (including a new “Not needed” status). • Needs ordering differentiation: low-stock sync marks rows as “Needs ordering (oos)”; expired-stock sync marks rows as “Needs ordering (exp)” (manual rows stay “Needs ordering”). • Bulk actions: select rows and run “Mark as not needed” or “Copy selected” (duplicates as new pending orders without PO/receiving references). • Edit protection: once ordered, entry fields are locked until order details (ordered date / PO / requisition) are cleared; once received data is entered, ordered dates and details are locked until received fields are cleared. • Refresh expired-stock rows: adds pending tracker lines for reagents with inventory expiring within 90 days or already expired (alongside existing low-stock refresh). • Procurement bulk endpoint: `POST /stock/reports/procurement/bulk/`. • Note: migrations `0028_procurementneed_not_needed_status` and `0029_procurementneed_need_kind` are required. 2.0.5 (2026-07-16) • Fix: creating an in-house solution (`/stock/createnewsol/`) no longer raises `KeyError: 'lot_no'`. `Inventory.create` defaults missing `lot_no`, and audit logging records the lot numbers actually assigned (stock number when empty). • `Solutions.create` now passes an empty `lot_no` explicitly so solution receipts follow the same path. • Migration `0027_alter_procurementneed_status`: aligns procurement need status choice labels with the tracker (“Needs ordering”, “Items ordered”, “Items received”). • Regression test: `test_solution_create_lot_no`. 2.0.4 (2026-07-09) • Inventory reports and stock reports now include Supplier Catalogue Number (`reagent.cat_no`) on item export rows (URS-XX1). • Barcode batch lookup (Reports): paste or upload stock numbers; view all matches in one table within laboratory scope (URS-XX2). • Batch export: selectable columns; download PDF, Excel, or CSV with barcode, reagent, supplier, catalogue #, lot, dates, storage, and status (URS-XX3). • Reagent Usage Log (PDF): printable log from the batch lookup results for experiment documentation, with optional experiment reference (URS-XX4). 2.0.3 (2026-07-09) • Procurement tracker (Reports): single spreadsheet-style grid replaces the separate planner form and planner queue screens; edit all fields inline with dropdowns, date pickers, and text cells. • Row colours: white = needs ordering, amber = ordered, green = received; status is derived automatically from requisition, PO, dates, and received quantity. • Auto-populate: low-stock reagents are added to the tracker on open (and via “Refresh low-stock rows”); filters and column sorting included. • New planner fields: procurement route (R12 / Manual PO / Other), person ordering, date ordered, date received, quantity received; Manual PO no longer requires an R12 requisition. • Audited cell saves via `/stock/reports/procurement/save/`; CSV export updated; legacy planner queue / add / edit URLs redirect to the tracker. • Note: database migration `0026_procurement_need_tracker_fields` is required. 2.0.2 (2026-06-16) • Experiment report added (Reports menu and catalog): select an experiment and export stock as PDF or XLSX (attributed at open or used in usage records). • Procurement planner queue (Edit Data): separate list, add, and edit screens for planner lines; status workflow Needs ordering → Items ordered (R12 requisition) → Items received (PO reference). • Procurement control: edit and remove PO lines and goods receipt lines on dedicated screens; receipt linking updates received quantities and PO fulfilment status; removal blocked when inventory is linked. 2.0.1 (2026-06-01) • Add controlled storage-location adjustments: `storage_before` / `storage_after` fields and `storage` adjustment kind. • UI and form support for changing storage location from the item adjustment form. • Safety: validation to require one change at a time and improved help text. • Backend: `apply_stock_adjustment` handles storage updates and audit logging; adjustment log now selects related storage objects. • Search: add `cat_no` (catalogue number) search support. • Note: a database migration is required to add the new `storage_before` / `storage_after` columns. 2.0.0 (2026-05-22) Topics in this release: • Laboratory-based access (an admin can assign one or multiple laboratories to a user) • Shared/global stock concepts (a lab attribute for a reagent or item) • Actor versus consumer attribution (experiment names and consumers can be added) • Barcode-driven stock workflows • FEFO / oldest-lot-first handling (warnings when newer lots are opened before older lots are opened) • Open-vial handling • Storage-condition modelling • Expanded validation workflows • Procurement planning and supplier metadata • Audit and traceability flows