When a completed batch has no recorded lot for an actual material addition, the operation status cannot supply the missing history. Build the batch production record from the approved instruction version and the evidence of what happened: material use, operation results, checks, and authorized decisions. Keep the missing lot as an exception even if input and output weights reconcile. A matching total does not identify what went into the batch.
The process below recommends a general operations record, with US drug-manufacturing requirements identified where cited. FDA’s 21 CFR 211.188 requires production and control information for each drug-product batch. Part 211 has a defined drug-product scope; its requirements do not apply to every factory by default. Your quality owner must establish the rules, approvals, and retention requirements for your product and jurisdiction.
Stage 1: Bind the batch to its approved instructions
Owner: production planning and the instruction approver. Create a unique batch reference, identify the product and site, and retain the instruction version authorized for execution. Record the intended batch size and units, operations, required checks, and applicable acceptance criteria. The failure point is a batch record that always opens the latest instruction, leaving no evidence of the version used during production.
Keep planned work separate from actual execution. A manufacturing work order provides the authorized build and operational reference. The batch record collects the results of that execution, including departures from the plan. Retain links between them when one order contains multiple batches or a batch passes through several orders, rather than treating the identifiers as interchangeable.
For drug products covered by the rule, section 211.188(a) addresses an accurate reproduction of the appropriate master record, checked, dated, and signed. That is a sector-specific requirement. In a general operations workflow, have the responsible owner define the controlled relationship between the approved recipe or instructions and the batch-specific execution record.
Stage 2: Record actual material identity at consumption
Owner: material handling and the operator making the addition. Record each actual input with its item, lot or serial identity where required, quantity, unit, and source transaction. Include returns, additional issues, and authorized substitutions. The failure point is copying a planned component or reservation into the actual-use field without evidence that the reserved material was consumed.
In its drug-product context, section 211.188(b) includes component or in-process material batch identification and weights or measures used. For your batch review, separate what the ERP expected from what the operator or source transaction recorded. If the lot was not captured, assign an investigation instead of selecting the most recent receipt for the item.
Retain the receipt-to-consumption reference when inventory uses internal lot codes that differ from supplier codes. The lot traceability process covers those physical relationships across batches and shipments. Here, the narrower job is to preserve the input evidence inside this batch’s execution history, including unresolved references that a wider trace may need later.
Stage 3: Capture operation results and checks as work occurs
Owner: the operator and the designated checker. Attach operation times, equipment identity, required process values, inspections, and test references to the batch and step they support. Keep performed, checked, and approved statuses distinct. The failure point is a shift-end completion entry that implies every required observation was captured even though the supporting result is blank.
FDA’s drug CGMP data-integrity guidance describes data as needing context such as acquisition time, user identity, instrument identity, and material information to reconstruct the activity. Apply the same record-design principle to your operations: preserve the original value, unit, source reference, and event time together. A timestamp on an exported file does not establish when an operator performed the step.
Define the evidence required for each handoff before the batch runs. An inspection may need a report containing the result, while an equipment check may need its own source log. Use explicit statuses for missing results and pending checks. A supervisor can then distinguish unfinished production from finished work whose required evidence has not reached the reviewer.
Authorized instructions
Batch and revision
Actual execution
Inputs, steps, results
Review decision
Exceptions and authority
Stage 4: Reconcile quantities without filling evidence gaps
Owner: production reconciliation with material control and quality. Compare actual inputs with recorded output, returned material, samples, scrap, and any material still in process. Use the same boundary and units on both sides. The failure point is posting an unexplained balancing loss or treating a zero quantity difference as proof that all input identities are known.
Consider a hypothetical non-drug dry-material batch B200. Its input records show 600 kilograms on addition A1 and 400 kilograms on A2. A2 identifies lot L2, while A1 has no lot reference. Assume net weights, no added material, no moisture change, and no unmeasured loss or remaining material in equipment. All output categories below are separate, weighed destinations; packed product is awaiting release.
| Record category | Example quantity | Evidence needed |
|---|---|---|
| Input addition A1 | 600 kg | Weight recorded; actual lot missing |
| Input addition A2 | 400 kg | Weight and lot L2 recorded |
| Packed product awaiting release | 960 kg | Batch-linked packing and weight records |
| Recoverable material returned | 25 kg | Return reference and recorded status |
| Material designated as scrap | 10 kg | Weight and disposition reference |
| Retained samples | 5 kg | Sampling references and weights |
The recorded input is 600 + 400 = 1,000 kg. The destinations sum to 960 + 25 + 10 + 5 = 1,000 kg, leaving a zero arithmetic difference under the assumptions. Packed product is 960 / 1,000 × 100 = 96% of recorded input mass. That calculated share is neither a universal expected yield nor an acceptance criterion, and the missing lot on A1 remains unresolved.
In a real process, define how evaporation, reaction, moisture changes, or other transformations affect the expected balance before using a mass reconciliation. Keep returns and samples distinct from discarded material. The manufacturing scrap rate article covers the separate choice of a loss numerator and denominator. A batch record should preserve the underlying quantities so different metrics do not erase their dispositions.
Review one batch across its source records
Start with permitted execution extracts, material transactions, and output records that share a batch reference.
Stage 5: Investigate exceptions and preserve corrections
Owner: the assigned deviation or discrepancy investigator. Give each missing record, unexplained quantity, or failed requirement its own reference and resolution evidence. The failure point is replacing the original observation with an edited summary that no longer shows the discrepancy. For A1, retain the missing-lot exception until the investigation establishes the actual consumed lot or documents the unresolved limitation.
For drug products subject to the provision, section 211.192 requires investigation of unexplained discrepancies and specification failures, including consideration of associated batches or products, with written conclusions and follow-up. That is a regulatory requirement in its stated scope. Other operations should define their investigation and escalation process through the applicable quality procedure.
Record a correction with its original value, corrected value, reason, responsible person, and actual correction time. Distinguish the event time from the later entry time when records arrive late. FDA’s data-integrity guidance discusses reconstructing changes to electronic records and preserving their context. A late correction should explain the history, not make an earlier review appear to have seen evidence that arrived afterward.
Stage 6: Separate production completion from authorized release
Owner: the reviewer and release authority designated by the quality procedure. Review required steps, input identities, results, reconciliation, and unresolved exceptions against the approved requirements. Retain the record version reviewed and the decision reference. The failure point is allowing a completed production order or a balanced total to change product status without the required review.
For the covered drug-product records, section 211.192 assigns review and approval to the quality control unit before release or distribution. In a general operations workflow, specify who can accept a completed record, who can authorize disposition, and which unresolved conditions prevent either decision. Use the authority your process requires rather than deriving it from a report’s green status.
Keep the approved packet retrievable with its underlying records. If an investigation changes the interpretation after approval, preserve the earlier decision and link the subsequent review. Set retention and access requirements with the responsible quality and records owners; an export saved on a supervisor’s computer is not a defined retrieval and retention process.
Where Permute fits in batch evidence review
Permute sells connected business data, custom applications, and governed analysis. We can bring permitted production extracts from SAP or NetSuite together with operation logs in Excel and supporting files in Google Drive. The review can retain source references for material additions, results, and output records instead of relying on a manually assembled total alone.
We can apply your declared batch identifiers, units, instruction mappings, and reconciliation boundaries across the evidence. Missing actual lot references stay visible even when quantities balance. An ambiguous record remains an exception for the owner who can establish its meaning, without substituting the planned material for actual consumption.
A production quality lead can ask which batches lack actual input identities or required result references and inspect the supporting records their permissions allow. We can supply that governed evidence to analysis in Claude, ChatGPT, or Copilot. The authorized reviewer still determines what the evidence supports and what action follows.
Keep regulated records and release controls in their approved systems
This workflow reads approved source data for analysis. We do not claim a validated GMP electronic batch-record system, compliant electronic signatures, regulatory certification, or batch-release authority. A connected record view does not establish those controls. Keep regulated record creation, signatures, retention, and release in the systems and procedures approved for that purpose.
This workflow also does not promise an ERP correction, material disposition, or external release through Permute. Any external action needs a supported provider/action scope, current permissions, and approval. An input lot that was never recorded remains an investigation task (even when the material total agrees), not a field that analysis can reconstruct without evidence.
A batch production record explains actual execution against the instruction version authorized for that batch. Preserve material identities, operation evidence, and the quantities behind each disposition so the reviewer can distinguish a balanced total from a complete history. Resolve the missing input-lot reference through supported records and retain any correction with its history. Production completion and the authorized release decision remain separate, documented events.
Assess the gaps in your batch evidence
Bring a completed batch, its instruction reference, and unresolved material or result links to a scoped review.
Questions about batch execution records
Does a closed work order replace the batch record?
A closed work order may link to much of the evidence, but its status alone does not establish actual input identities, required checks, or review decisions. Check what its underlying records retain and what your quality procedure requires. Preserve the batch-specific execution history even when the order serves as its main reference.
What if quantities balance but an input lot is missing?
Keep the quantity reconciliation and the identity exception as separate findings. The balance establishes the arithmetic under the stated boundary; it cannot identify the material consumed. Investigate the actual transaction or source record and route the unresolved condition under the applicable review procedure.
How should evidence received after review be handled?
Preserve the earlier record and decision, then link the new evidence and any authorized reassessment. Record when the event occurred and when the evidence became available. Replacing the earlier packet with the new one would obscure what supported the original decision.