Blueprint library/inventory

Pharmaceutical Inventory Management Software

Know exactly what material you have—and whether it can be used now.

Control every material definition, lot, container, quantity, location, status, expiry, storage exposure, reservation, movement, dispense, use, reconciliation, and disposition—from receipt to batch genealogy.

A green balance can still hide unusable stock

The inventory view says 47 units are on hand. One operator has a container in front of them. Its label is legible, the material name is correct, and the printed expiry has not passed. But part of the lot is reserved, the storage unit has an open excursion, and this container is released for development work—not the GMP batch about to consume it.

The number is not wrong. It is answering the wrong question.

The operational question is not “How much do we have?” It is “Which exact containers may be used for this exact operation now, and what evidence supports that answer?”

Seal controls the physical population behind the balance: material, lot, container, quantity, place, quality state, environmental history, demand, and actual use. Each answer can be traced to the records and rules that produced it.

One balance collapses different populations

Inventory records split across purchasing, quality, laboratories, production, and local trackers
Fig. 1 / Inventory records split across purchasing, quality, laboratories, production, and local trackers

Purchasing may know what was ordered. A warehouse system may know what was received and moved. Quality knows what was released or held. Laboratory and manufacturing records know what was sampled, prepared, dispensed, or consumed. Local trackers often fill the gaps between them.

Each source can be accurate for its own job while the combined inventory picture is already stale. Seal keeps the distinctions explicit:

  • On hand means the material is physically recorded at a location.
  • Released means an authorized quality decision permits a defined scope of use.
  • Available subtracts reservations, allocations, and minimum remaining quantities.
  • Eligible means a specific container satisfies the rules for a specific use at a specific time.

Production planning, laboratory scheduling, and point-of-use selection consume different views of the same controlled population—not separately maintained totals.

The container is the unit of control

Material, lot, container, and physical location hierarchy
Fig. 2 / Material, lot, container, and physical location hierarchy

A material definition says what an item is. A lot preserves its manufacturing and supply identity. A container is the physical object that can be received, labeled, moved, opened, sampled, partially consumed, damaged, quarantined, or destroyed.

Instead of “polymerase, 47 units,” Seal can identify container C03 from supplier lot RM-0417: a 250 µL aliquot in ULT-03, shelf 2, box C, with 180 µL remaining, an intact seal, a current quality decision, and a complete movement and use history.

Pallets, drums, bottles, vials, bags, kits, plates, and aliquots can form parent-child handling units. A split creates new physical identities without losing source genealogy. A relabel changes the label, not the history. Current quantity and state are derived from what actually happened to each object.

Receipt creates governed inventory, not just stock

The effective material definition controls approved manufacturers and sites, supplier scope, grade, specification, unit, packaging, storage, shelf life or retest, sampling, testing, release, hazards, potency, and use restrictions. Version changes apply from a defined date without rewriting historical receipts.

Receiving preserves purchase and shipment references, manufacturer and supplier lots, internal lot, quantities, condition, certificates, dates, ownership, and initial location. Labels are generated from the governed record. The incoming population normally begins in a state that prevents unapproved use while sampling, testing, document review, and disposition remain open.

Supplier datasheets, specifications, safety data sheets, and certificates can be extracted into a source-linked change set. AI proposes values; a qualified person reviews, corrects, and approves them. The source remains attached, and no extracted value becomes approved master data merely because a model found it.

Status changes what the system allows

Received, quarantine, sampled, under test, released, restricted, reserved, held, rejected, expired, consumed, returned, and destroyed are operating states—not colored labels on a report.

Every state change retains scope, reason, effective time, evidence, conditions, authority, and approver. A lot-level hold can propagate to every child container. A damaged-container restriction can remain limited to one physical item. Release can permit R&D use while still blocking GMP manufacturing.

Expiry, retest, open life, preparation life, and use-by rules can update eligibility automatically. If governance permits an exception, it follows a separate authorized path with defined scope, rationale, controls, duration, and approval. There is no generic “continue anyway” action that silently turns a failed check into an accepted use.

Eligibility is evaluated at the moment of use

Point-of-use eligibility
One decision, preserved with the execution record
Input

Container C03

Supplier lot RM-0417
180 µL remaining
ULT-03 / shelf 2 / box C
Barcode scanned
Decision
6 rules resolved
Material and grade match
Quality state permits use
Dates remain current
Storage history is acceptable
Quantity is unreserved
User and process are authorized
Eligible
Record the lot and quantity, then continue the step.
Blocked
Show the failed rule and the governed next action.
Evidence
Exact records evaluated
Rule
Effective version retained
Context
Use, user, and time preserved
Fig. 3 / A scan resolves material eligibility before use and records the accepted consumption

Before a batch step, laboratory method, preparation, or other controlled activity can consume material, Seal evaluates the intended material and grade, manufacturer, supplier, lot attributes, specification, quality status, dates, storage and excursion state, location, reservation, available quantity, product, market, process, method, restrictions, and user authorization.

The decision returns eligible, conditional, or blocked with the rule and evidence that produced the result. Selection lists can exclude ineligible stock; a barcode scan confirms the physical container at the point of use. An accepted dispense records the exact lot, container, quantity, operator, time, and execution context while updating the remaining balance.

The execution record therefore preserves not only what was used, but why it was considered suitable at that moment.

Every movement and quantity change leaves a balanced transaction

Receipt, transfer, split, consolidation, sampling, preparation, dispense, consumption, return, spill, loss, adjustment, destruction, and shipment debit and credit identified stock. The current balance is the sum of transactions—not an overwritten cell.

Expected and actual quantities, units and conversions, measurement basis, tolerances, discrepancies, reasons, witnesses, and approvals remain attached to the event. Container history shows who moved or changed it, when, from where, to where, and because of which activity.

Physical location can resolve from site to building, room, storage unit, shelf, rack, box, and position. The address remains useful to operators while the movement history supplies the evidence needed for custody, counting, and environmental impact.

Storage events resolve the actual exposed population

A freezer alarm should not create a guess based on where inventory sits now. Seal combines the location hierarchy, container movement intervals, sensor coverage, event start and end, mapping, conditions, and alarm evidence to determine which containers were present during the affected period.

A container moved into the unit halfway through the excursion has a different exposure from one stored there throughout. Assessment, supporting stability or shipping evidence, status actions, and final disposition remain connected to the exact population. The same trace can identify work that already consumed an affected container.

Reservations make future availability visible

On-hand inventory does not show what tomorrow's work has already claimed. Reservations connect production orders, laboratory plans, studies, campaigns, kits, shipments, safety stock, priority, quantity, expiry, and due time to eligible stock.

Planners can distinguish released inventory from available-to-promise inventory and see shortages before execution begins. FEFO rules can propose the appropriate containers without taking material reserved for higher-priority or earlier work. Substitution and reallocation remain explicit decisions with impact and approval.

Actual use builds the genealogy

Forward trace / supplier signal to bounded impact
The trace explains inclusion and exclusion
01Source

Supplier lot RM-0417

Quality notification
Scope opened
02Population

12 containers

8 remain on hand
4 already consumed
03Actual use

Linked execution

3 preparations
2 batches · 1 sample
04Decision

Bounded impact

Affected work held
Ruled-out stock retained
Resolved scope
One query, three accountable outcomes
Remaining stock
Container-level hold applied
Consumed material
Downstream work identified
Excluded population
Reason and evidence preserved
Fig. 4 / A source lot traces forward through every consuming activity and affected output

Laboratory and manufacturing workflows record material at the point of sampling, preparation, dispensing, or consumption. The inventory transaction and the execution record refer to the same physical container and quantity, so reconciliation does not depend on someone posting a second summary later.

From a supplier lot or container, Seal can traverse samples, tests, preparations, experiments, batches, intermediates, finished products, shipments, retained samples, remaining stock, returns, and destruction. From a batch or result, it can trace backward to the exact containers, approvals, locations, excursions, and movements that supported the work.

When a supplier notification arrives, the question is no longer “Where might this lot have gone?” The trace separates stock still on hand, material already consumed, affected work in progress, released outputs, and ruled-out populations—with the evidence for each conclusion.

Reconciliation tests the record against reality

Cycle counts and full inventories freeze a defined population while accounting for transactions in progress. Counts can be blind, risk-based, location-based, material-based, or sampled. Operators record observed quantities and conditions; the system routes recounts, discrepancies, impact assessments, adjustments, and approvals.

An adjustment does not erase the difference. Expected quantity, observed quantity, cause, evidence, decision, and resulting transaction remain visible. Repeated variance by location, shift, material, transaction type, or user can become a process-improvement or investigation signal.

Keep each system's job clear

Seal does not need to replace the ERP that buys the material or the WMS that moves it through a warehouse. Those systems can continue doing the jobs they already do well. Seal supplies the operational answer they usually cannot provide alone: whether this particular container is suitable for this particular use right now.

When a laboratory or manufacturing step requests material, Seal evaluates the live inventory state and records the actual consumption. When a storage monitor reports an excursion, Seal resolves the affected containers and downstream uses. Each system remains authoritative for its own record; the handoffs no longer leave eligibility or genealogy to inference.

Start with the material that causes the most pain

Choose one material class with costly shortages, frequent expiry, difficult storage, or weak traceability. Govern its suppliers and storage rules, label new receipts at container level, and connect one real laboratory or manufacturing use. That is enough to test whether the digital record matches physical practice.

Before expanding, put the flow under pressure. Hold a supplier lot. Trigger a storage excursion. Create a count discrepancy. Trace one source lot forward and one batch backward. If the system can explain what exists, where it is, whether it may be used, what consumed it, and why the balance changed, the pattern is ready to scale.

Operating model

The control layer sits above the systems that supply governed records and execution.
Control · 09

Owned here

  • Container-Level Tracking
  • Status Enforcement
  • Scan-to-Use
  • Expiry Management
  • Stock Visibility
  • Recall Impact
  • AI Material Setup
  • Storage Monitoring
  • Cycle Counting
Foundation · 05

Connected systems

Capabilities

Seal turns experiments into structured evidence. AI-configured methods evolve with your process. Unified with LIMS, MES, and QMS.
Seal checks results against live specs. AI-configured methods evolve with your process. Unified with MES, QMS, and ELN.
Seal captures the batch as it runs. AI-configured workflows evolve with your process. Unified with LIMS, QMS, and ELN.
04Container-Level Tracking
Track every receipt, container, aliquot, handling unit, location, quantity, seal, status, and event—not only an aggregate material balance.
05Status Enforcement
Make quarantine, release, restriction, hold, rejection, expiry, and disposition change what users can select and what workflows can execute.
06Scan-to-Use
Evaluate identity, grade, status, dates, storage, reservation, quantity, and intended use when the operator scans; record accepted consumption in the same action.
07Expiry Management
Apply shelf life, retest, open-life, preparation-life, and use-by rules to selection, alerts, FEFO proposals, and governed exceptions.
08Stock Visibility
Separate on-hand, quality-released, reserved, available-to-promise, and eligible quantities so plans reflect the stock execution can actually use.
09Recall Impact
Trace a supplier lot through remaining containers, samples, preparations, batches, products, shipments, returns, and destruction with explicit included and excluded populations.
10AI Material Setup
Extract candidate material and lot data from supplier documents into a source-linked change set for qualified review, correction, and approval.
11Storage Monitoring
Map monitored storage events through container movement intervals to the actual exposed population, its assessment, status, use, and disposition.
12Cycle Counting
Freeze a count population, capture blind observations and recounts, investigate variance, approve adjustments, and trend recurring discrepancy patterns.

Entities

Entity hierarchy
What it records
Kind
Container
Physical inventory identity with lot, quantity, unit, condition, seal, label, location, status, dates, reservation, and complete event history.
entity
RM-0417 / C03
A 250 µL aliquot in ULT-03, shelf 2, box C, with 180 µL remaining, an intact seal, current status, and linked use history.
record
Status
Scoped quality and operating state with effective time, reason, evidence, conditions, authority, and permitted uses.
entity
Released
Authorized for a defined scope of products, processes, methods, markets, projects, and effective dates.
template
Quarantined
Unavailable for normal use while receipt, testing, review, investigation, or disposition remains open.
template
Expired
Past the applicable expiry, retest, open-life, preparation-life, or use-by condition and blocked from normal selection.
template
Movement
Timestamped transfer of an identified container or handling unit between precise source and destination locations.
entity
Location
Site-to-position hierarchy for warehouses, rooms, freezers, cabinets, shelves, racks, boxes, and point-of-use storage.
entity
Storage Unit
Controlled storage identity linked to conditions, monitoring coverage, alarms, mapping, capacity, restrictions, and resident inventory.
entity
Material
Governed identity and effective requirements for the item that may be received, stored, tested, and used.
entity
Lot
Manufacturer, supplier, and internal lot identity with dates, certificates, attributes, status, parentage, and quality decisions.
entity
Material Definition
Versioned grade, specification, manufacturers, suppliers, unit, packaging, storage, dates, sampling, testing, release, hazards, and use restrictions.
entity
Material Genealogy
Parent and child lineage across receipt, sublot, split, combine, repack, aliquot, preparation, issue, use, return, and destruction.
entity
Inventory Transaction
Debited and credited stock, quantity, unit, source, destination, reason, activity, people, time, evidence, and approval.
entity
Inventory Reservation
Demand, priority, quantity, due time, eligibility, selected lots, expiry, release, shortage, and substitution decision.
entity
Material Eligibility Decision
Point-in-time allowed, conditional, or blocked decision for the exact material, container, use, quantity, location, and context.
entity
GMP Material Use
Material, lot, container, status, date, storage, location, reservation, quantity, product, process and restriction evaluation.
template
ELIG-MAT-00442
Blocked use decision because the scanned container was inside an unresolved freezer-excursion population.
record
Storage Excursion Impact
Condition event mapped through container movement intervals to affected inventory, evidence, assessment, status, and disposition.
entity
Inventory Reconciliation
Frozen population, blind count, observations, recounts, variances, causes, adjustments, impact, approval, and effectiveness.
entity

FAQ

An ERP can remain authoritative for purchasing, suppliers, financial valuation, and enterprise planning. Seal controls the GxP material population at lot and container level: quality state, precise location, remaining quantity, dates, reservations, environmental exposure, point-of-use eligibility, actual consumption, reconciliation, and genealogy. The systems can exchange receipts, demand, balances, and status without assigning both of them authority for the same decision.
Containers from the same lot can differ in location, remaining quantity, seal condition, open life, reservation, exposure, damage, or restriction. Lot-level control is still available, but container identity lets a decision match the actual physical population. Aliquots and repacks inherit their source genealogy while receiving their own labels, quantities, states, dates, and custody.
Eligibility can resolve shelf life, retest, open-life, preparation-life, and use-by conditions for each container. A failed date rule removes the container from normal selection or returns a blocked decision with the reason. If your governance permits an exception, it is a separate, authorized, time-bounded decision with defined scope and evidence—not a generic override.
Receiving preserves purchase and shipment references, manufacturer and supplier lots, internal lot, quantities, condition, certificates, dates, ownership, and initial location. It creates the required container or handling-unit records and labels. The incoming population enters the configured quality state while sampling, testing, document review, and disposition remain open.
A laboratory method, preparation, or manufacturing step requests material with defined eligibility rules. Selection or scanning resolves the physical container and records the accepted lot, quantity, operator, time, and execution context. The inventory transaction and execution record reference the same event, so later traceability does not depend on reconciling two manually posted summaries.
Each event debits the source quantity and, where applicable, creates a child container or preparation with its own identity. Original quantity, remaining quantity, unit conversion, measurement basis, tolerance, operator, equipment, destination, and source genealogy remain traceable. Empty or otherwise exhausted containers move to the configured terminal state without disappearing from history.
Yes. Seal combines the storage hierarchy, monitoring coverage, event interval, and container movement history to derive which items were present for which part of the event. Assessment, supporting stability or shipping evidence, status actions, disposition, and prior uses remain linked to that exact population.
A hold can begin at material, lot, sublot, container, location, or another defined population and propagate only as broadly as the evidence requires. The trace separates remaining stock, reserved material, work in progress, samples, consumed quantities, finished outputs, shipments, returns, and destruction. Included and excluded populations retain the reason and evidence for the scope decision.
A count freezes a defined population and records the transaction cutoff or in-progress movements that must be considered. Counts may be blind, risk-based, sampled, location-based, or material-based. Recounts, discrepancies, cause, impact, adjustment, approval, and effectiveness remain in the reconciliation record rather than being collapsed into the new balance.
Supplier datasheets, specifications, safety data sheets, and certificates are extracted into a source-linked change set. AI proposes values such as material attributes, storage conditions, dates, and lot data; a qualified person reviews, corrects, and approves them. The source remains attached, and extraction never grants approval by itself.
Choose one material class and prove the full control loop: governed definition, receipt, labels, location, sampling, quality status, expiry, reservation, one laboratory or manufacturing consumption path, one storage event, one count discrepancy, and bidirectional traceability. This exposes master-data, interface, permission, physical-process, and exception-path gaps before expanding across sites.

Related blueprints

Supplier

Pharmaceutical Supplier Quality Management Software

Manage supplier, manufacturer and site identities; risk and material or service scope; qualification plans, questionnaires and audits; quality agreements; approved-supplier states; incoming lot and CoA performance; deviations, complaints and SCARs; supplier changes; scorecards, monitoring, requalification, restrictions, and disqualification.

Standards & Reagents

Laboratory Standards, Reagents & Solution Preparation Software

Qualify standards and critical reagents, prepare controlled solutions, enforce container and open-life state, record exact analytical use, and find every result affected by a later material concern.

UD

Bioprocess Upstream Development Software

Run cell-culture and fermentation development with governed cell lineage, media and feed versions, executable recipes, connected bioreactors, samples and assays, clone and process comparisons, scale-up models, perfusion state, harvest decisions, characterization, and technology transfer.

DD

Bioprocess Downstream Development Software

Run purification and formulation development with governed harvest inputs, buffers and solutions, chromatography and filtration methods, column and membrane lifecycle, fractions and pools, samples and assays, yield and clearance balances, holds, scale-up models, characterization, and technology transfer.

Deviation

GxP Deviation & Investigation Management Software

Capture manufacturing, laboratory, facility, equipment and data deviations with live context; control containment and notifications; classify and scope impact; plan and execute evidence-based investigations; test hypotheses and recurrence; approve root cause and product decisions; connect CAPAs and changes; verify effectiveness; trend systemic signals; and close with complete rationale.

Pharma

Pharmaceutical Manufacturing Software

Connect materials, electronic batch records, QC, equipment, quality events, labels, stability, and release without rebuilding the batch across systems.

Go live in 48 hours.