SystemContract Manufacturing (CDMO)

Material Expiry & Retest Management

Material expiry management that sets each lot's retest or expiry date against its planned weigh-outs, names the last day a retest sample can be taken, and rehearses each fix before people sign.

See one lot's retest date meet its weigh-out ↓
Watch with transcript →
The problem

A refused scan the night before is too late for any retest to finish

The dispensing plan sits in the ERP, each lot's retest or expiry date on the lot record, QC's real retest time in the LIMS and the client's shelf-life rule in a quality agreement. The ERP allocates a released lot to a batch weeks ahead and checks status and quantity, not whether the lot will still be in date on the weigh-out day.

QC's retest list is sorted by retest date, so the lot a batch is waiting on can sit below one that is merely early. The first person to see the collision is often the dispensary operator whose scan is refused. By then a retest cannot finish, a swap takes a lot another batch was counting on, and moving the batch costs the client its date.

Built forMaterials plannersQC leadsRelease specialistsDispensing supervisors

The Problem Today

The weigh-out date and the lot's limit date sit in different systems, so they first meet at the scale.

5.34
EU GMP: only lots within their retest period may be used published

Kept in four places

  • Weigh plan
  • Lot dates
  • Lab times
  • Client rule
  • Allocated by status aloneA lot in date today is planned for a day it is not
  • The lab's true pace unknownA retest booked on the procedure's time finishes too late

The Solution

  1. Each lot drawn as a lineFrom today to its limit, with each planned weigh-out on it
  2. The last day to sampleCounted back from the limit with QC's measured retest time
  3. Each way out played forwardRetest, swap or move, with the other batch each one breaks
  4. Booked, blocked, signed twiceQC books the sample, the lot is blocked, a second person signs

Built-in controls

  • No lot weighed past its date or unreleased
  • No retest date beyond supported stability data
  • A second signature on each status change

What You Get

Each date that would stop a batch is found while a retest, a swap or a move can still help.

  • Caught before the scaleCollisions found across the next three weeks of weigh-outs
  • Client batches keep their slotA retest in time instead of a weigh-out moved by days
  • Less stock run out unusedLots near their limit go first where the rules allow
Features

Material expiry management features, from the board to a signed retest

An active planned for a weigh-out one day past its retest date is caught three weeks early, and planning, the lab, quality assurance and the weigh room each take their part.

demoEvery lot, date, person, client and supplier shown here is sample data.

  1. 01Collision board

    Retest and expiry dates drawn against each planned weigh-out for three weeks

    • One line per lot to its limit. Each lot planned for weigh-out runs from today to its retest date, expiry or the client's earlier limit, so two dates meet on one line.
    • Collisions sorted first. A weigh-out past the limit or on an unreleased lot is a collision, and one inside a few working days of it is a warning, so the planner works the worst first.
    • The lot label beside the line. Status, cage, quantity, limit and sample-by date sit next to the board, as the warehouse label shows them.
  2. 02Lot record

    Lot record showing how each retest date was set and where it came from

    • Each date with its source. The retest date links to the certificate line it came from, and the sample-by date to the measured lab time behind it.
    • Why the lot was planned past its date. The history shows how a hold moved the allocation onto a later batch, so the planner sees what caused the collision.
  3. 03Options

    Retest, swap or move rehearsed against every other batch on the plan

    • The batch a swap would break. Taking another released lot fixes this weigh-out and leaves a later batch short, and the card says so before anyone chooses it.
    • Weighing early ruled out by procedure. A lot must be inside its date on the day it is charged into the batch, so the obvious shortcut is shown as not allowed, with its clause.
    • What a move costs the client. Moving the weigh-out shows the release date it pushes back and the other client's batch it displaces on the line.
  4. 04Retest queue

    Raw material retest booking drafted from the specification for QC to book

    • The panel from the specification. Containers, tests, sample quantity and slot are drafted from the specification and the sampling procedure, ready for the QC lead to book.
    • Each booking tied to its weigh-out. A booking starts from the batch planned to use the lot, so the lab sees which weigh-out each retest is for as well as its date.
  5. 05Blocked lot

    Lot blocked for dispensing the moment its retest is booked

    • The safer status applies at once. Released becomes on retest the moment the QC lead books, and the scan refuses the lot until a result returns it.
    • A warning that keeps its margin. With one working day between the result and the weigh-out, the row stays a warning so the release specialist's read of the result is planned into that day.
  6. 06Second person

    Every status change and swap read and signed by a second person

    • A release waits for its reader. A release after a retest or a swap that departs from oldest-first waits until the material release specialist has opened the record.
    • Nobody checks their own change. The specialist agrees, or sends the change back with a reason, and a change they made themselves stays out of their queue.
  7. 07Dispensing

    Weigh and dispense lists with each lot's status checked line by line

    • Each weigh line with its check. The dispensing supervisor sees for each batch which lot, quantity and cage it uses, and whether it is inside its limit on that day.
    • A scan that refuses and says why. An expired, unreleased or on-retest container is refused at the scan with its reason, before anything is weighed.
  8. 08Supplier request

    Stability data requested from the supplier in fixed fields before a new date

    • Three fields, no email thread. Months of long-term data, the storage condition and the summary itself come back as fields, so QC can check what supports a new retest date.
    • No new date beyond the data. Without data covering a longer period, a passing retest allows use only for the named batch, and the rest of the lot is rejected.
  9. 09Lead times

    QC retest lead times learned from the lab's own results, approved by QC

    • Measured, then approved. The lab's real retest times per material group are learned from the LIMS, and a learned time applies only once the QC lead approves it.
    • At least the procedure's time. A new planner sees the true last day to sample without knowing the lab's queue, and a learned time can only bring it earlier.

A swap that departs from oldest-first waits for the release specialist's read

Planning chooses the fix, QC owns the retest and its lead times, a release specialist signs each status change second, and the weigh room refuses what the board blocks.

Materials planners

Run the dispensing plan and fix what will not weigh out

  • Collisions three weeks ahead, worst first
  • Each fix played against the other batches
  • A reason code on the option chosen
QC leads

Own the retest queue, the lab's capacity and its lead times

  • Bookings drafted from the specification
  • Each booking tied to the batch waiting
  • Learned lab times to approve or reject
Material release specialists

Second person on each status change, swap and reject list

  • The record opened before agreeing
  • Safer changes read after they apply
  • A sample opened before a bulk sign
Dispensing supervisors

Run the weigh room and its two shifts

  • Weigh lists checked against each limit
  • Blocked lots shown before the shift
  • A scan refusal with its reason

Dates read from the certificate, the lot record and the client's agreement

Planned orders and weigh listsThe dispensing plan for the next three weeks, from the ERP and MES.
Lot status, quantity, location and datesEach lot's record in the ERP, as its label shows it.
Supplier certificatesThe retest or expiry date as the supplier's quality unit stated it.
QC retest times and resultsEvery retest in the LIMS, the source of the learned lead times.
Client quality agreementsAny client rule on remaining shelf life on the dispensing day.
Supplier replies, field by fieldStability coverage and storage condition, with the summary attached.
More screens

A client's shelf-life rule can end a lot's use months before its expiry

A collision set by a client's rule, a component that is never retested, stock by status at four plants, the limit rules and the record of who signed.

A collision set by the client's ruleThe client asks for six months of shelf life left on the dispensing day, so a sorbitol lot still in date is past its limit; a retest cannot help.
Sterile stoppers have no retestA ready-to-use sterile component's expiry comes from its sterilization validation, so the way out is a swap to a lot released in time.
5,600 lots by status at four plantsReleased, quarantine, on retest, on hold, expired and rejected, by plant, with each held lot's reason and the date it went on hold.
The limit rules by material typeActives on their retest date, excipients and components on expiry, sterile components without a retest, the client's rule, and who proposes and approves a change.
Every choice, booking and check in orderThe read of the plan, the option chosen, the drafted and booked retest and the second person's agreement, each with the meaning of its signature.

demoSample data, from the working solution.

A learned lab time applies only once the QC lead approves it

Plan joiner

Reads the dispensing plan and each planned lot's status, quantity, location and dates.

  • Never changes a plan or an allocation
Date checker

Sets each lot's limit date and its sample-by date, and marks collisions and warnings.

  • Never extends a date
  • Never treats an expired excipient as retestable
Option rehearser

Plays retest, swap and move forward, listing each other batch that changes and any departure from oldest-first.

  • Never chooses
  • Never takes another batch's lot without showing that batch
Retest booker

Drafts the retest: test panel, containers to sample, quantity and QC slot.

  • Never books by itself
Supplier liaison

Asks the supplier for stability data in fixed fields, then reads the reply's fields and attachments.

  • Passes outside free text to a person
Lead-time keeper

Learns QC's actual retest times by material from the LIMS and proposes a rule.

  • Never proposes a time shorter than the procedure's

The QC lead's booking blocks the lot before the second person has read it

Materials planner
Sees
Each option played forward, and the batch it would break
Signs
The option chosen, with a reason code
QC lead
Sees
The drafted panel, containers, sample and slot
Signs
The retest booking, which blocks the lot at once
Material release specialist
Sees
The lot record, opened before agreeing
Signs
Each status change and swap as second person, or a send-back
Warehouse lead
Sees
Expired lots by cage and plant
Signs
The proposal to reject them, which the release specialist signs second after opening a sample

Questions planners and QC ask about material expiry management

What is material expiry management at a contract manufacturer?

Material expiry management keeps every lot from being weighed past its retest or expiry date, or a client's stricter limit. Here agents draw each lot planned for the next three weeks against its weigh-outs, name the last day a retest sample can be taken, and rehearse each fix for people to choose and sign.

How does a retest date differ from an expiry date?

In ICH Q7, a retest date is when a material should be re-examined to ensure it is still suitable, and an expiry date is the date after which it should not be used. Actives here carry a retest date; excipients and packaging components carry an expiry.

Can a retest date be extended after a passing retest?

Only as far as the supplier's long-term stability data support it, as ICH Q7's questions and answers set out. QC opens the stability summary before proposing a new date, and a release specialist signs it second; without that data, no new date is given.

Can an excipient be retested past its expiry?

Not under the plant's procedure: an excipient or packaging component is retested only before its supplier expiry, and a ready-to-use sterile component is not retested at all. For those lots the options are a swap or a move.

Why not weigh the lot a day early, while it is still in date?

The plant's procedure applies the date on the day the lot is charged into the batch, which here falls after it. The option is shown and marked not allowed, with its clause, so the planner does not have to ask.

Find the lot that will fail
at next week's weigh-out.

Send three weeks of one plant's dispensing plan and lot dates, and we will draw where they collide.