Reagent inventory management system requirements: lot-level tracking, expiry, and tying every result to the lot that produced it

Lot-level requirements

1. Track the lot, not just the item. Every receipt is a lot with its own certificate, expiry and storage history, and every use should record which lot was consumed. This is the property that makes the inventory useful for investigation rather than only for reordering.
2. Hold the certificate with the lot. Certificates of analysis arrive as documents and are lost as documents. Storing them against the lot record means the acceptance criteria and the measured values are available when somebody questions a result rather than in an inbox nobody can search.
3. Expiry, open-vial life and storage. Many reagents have a shelf life once opened that is far shorter than the printed expiry, and a storage condition excursion can end a lot regardless of date. The system should record opening and support a storage exception rather than tracking the printed date alone.
4. Reservation for a study. A study running for months needs enough of one lot to finish, and the system should let that quantity be reserved so it is not consumed by routine work. Discovering mid-study that the lot is gone forces an unplanned bridging exercise.
5. Bridging when a lot changes. Where a lot change is unavoidable, the system should make it visible and support recording the bridging comparison against a retained reference. An undocumented lot change is the classic invisible confound in a long dataset.

Tying results to lots

The real value appears when the inventory and the result record share the lot identifier, so that a question about a drifting assay can be answered by looking rather than by remembering. That integration is worth more than most features either system offers alone.

Where results support regulated work, the obligations on electronic records apply to the reagent record too, because it forms part of the evidence for how a result was produced.

Keeping retained references

Retain an aliquot of critical reagent lots under your own control and record where it is. It is the only instrument available for distinguishing a lot effect from an experimental one, and it costs almost nothing.

Record the retained sample in the same system, or it will be found years later with nobody able to say what it was for.

Common questions

Why track reagents at lot level?

Because results depend on the lot. An inventory that records quantity but not which lot was used cannot answer whether a change in results came from the reagent, which is the question that eventually gets asked.

What about open-vial life?

Many reagents have a much shorter life once opened than the printed expiry suggests. The system should record opening and support storage exceptions, not track the printed date alone.

How do I handle a lot change mid-study?

Reserve enough of one lot to finish the study where possible. Where a change is unavoidable, bridge the new lot against a retained aliquot of the old one in your own assay and record the comparison.

Should reagent inventory integrate with results?

Yes, through a shared lot identifier. That is what lets a question about a drifting assay be answered by looking rather than by recollection.

Browse by service class

• Compare Gene synthesis on advertised prices