A delivery can increase inventory and still leave the business unable to answer a basic question: which supplier lot is this material?
Quantity-on-hand tells you how much exists. Raw material lot tracking tells you which specific receipt was used, whether it was approved, where it is stored, and which production batches could be affected if a problem appears later.
The best time to create that record is at receipt, while the label, packing slip, container, and condition are still in front of you.
Track more than the material name
“Coconut oil,” “red pigment,” or “eight-ounce jar” identifies a type of item, not a received lot. Two deliveries of the same material may come from different supplier lots, dates, plants, specifications, or conditions.
Keep three identities separate:
- Material identity: your stable item name or code.
- Supplier lot: the lot, batch, or production code printed by the supplier.
- Internal receipt ID: your identifier for the delivery event or lot record.
A supplier lot may arrive in several containers, and one delivery may contain multiple lots. The internal receipt ID organizes what arrived together but should not replace the supplier’s identifier. Keep ingredient lot numbers and internal IDs in clearly named fields.
Capture receipt facts before labels disappear
Create the material receipt record before the item is shelved, divided, relabeled, or moved into production. Record:
- material name and internal item code;
- supplier and, when useful, manufacturer;
- purchase order or receiving-document reference;
- supplier lot or batch code exactly as shown;
- internal receipt ID;
- quantity received and unit;
- number and type of containers;
- received date;
- manufacture, expiration, retest, or best-by date when provided and relevant;
- person who received the material.
Photographs can support a hard-to-read code, but enter the identifier as searchable text too. Preserve zeros, letters, dashes, and spaces exactly; changing `O` to `0` can create a different identifier.
Record condition, status, and checks
A lot record should show whether the material may be used, not merely that it exists. A simple status might be:
- Held: received but not yet reviewed;
- Approved: available for production;
- Rejected: not permitted for use;
- Expired or blocked: physically present but unavailable;
- Depleted: no usable quantity remains.
Define who can change the status and what evidence is required. Depending on product and risk, that could include package condition, seal integrity, count, weight, certificate review, appearance, odor, or dimensions. Record the result and exceptions; “checked” is less useful than a specific observation tied to the lot and reviewer.
Legal and quality requirements differ by industry. The FDA’s food traceability rule applies defined requirements to certain foods, while dietary-supplement batch records have separate federal requirements. Confirm what applies to your products instead of treating this checklist as regulatory advice.
Make storage location part of the record
A perfect identifier is not useful if nobody can find the material. Record the storage location and place a clear identifier on each container. Update the location when a lot moves, and keep status visible so held stock is not mistaken for approved stock.
If you use first-in, first-out or first-expire, first-out, the rule should select among eligible lots. It should never override a hold, rejection, or product-specific restriction.
Protect the identity when containers are split
Traceability often breaks after receiving. A bag is divided into bins. A drum is poured into smaller jugs. A roll of labels is moved to the workbench. The original supplier label stays behind.
Every secondary container needs enough information to reconnect it to the source record. Usually that means the material identity, supplier lot, internal lot or receipt ID, status, and relevant expiration or retest date.
Do not combine two lots in one working container unless the operation intentionally permits it and records the relationship. Otherwise, the next production record may show one material name while the physical container holds an unknown mixture of lots.
Connect actual usage to the production batch
Receiving creates the lot record. Production completes the traceability link.
When material is weighed, dispensed, or issued, record the actual lot used. Do not assume the oldest approved lot was used because that was the plan. If a run switches lots, record both and, when needed, the quantities or point of change. That link creates usable batch traceability.
For the rest of the run record, use a before-during-after production record checklist. If the material change also requires a recipe revision, keep the material event separate from the approved formula version record.
Use one compact incoming-lot checklist
| Field | Question it should answer |
|---|---|
| Material and item code | What did we receive? |
| Supplier and manufacturer | Who supplied or made it? |
| Supplier lot | Which source lot is on the container? |
| Internal receipt ID | Which receiving event created this record? |
| Quantity and containers | How much arrived and in what form? |
| Dates | When did it arrive, and when does it expire or need review? |
| Condition and checks | What was inspected, and what was the result? |
| Status and approver | May production use it? Who decided? |
| Storage location | Where is it now? |
| Usage links | Which batches consumed it? |
Keep supplier records such as packing slips, certificates, specifications, and communications linked to the same record when they support identity or approval. Do not bury the lot code in an attachment that cannot be searched.
Test traceability in both directions
Run two short tests:
- Backward: Pick one finished batch. Can you identify every relevant material and packaging lot actually used?
- Forward: Pick one supplier lot. Can you find every production batch and finished lot that received it?
A pigment-to-finished-product example is mapped in this ink and coatings record-flow guide. The same relationship becomes important during a real investigation; this pet-product complaint traceability walkthrough shows how finished-lot details connect back to materials and production records.
If either test depends on memory, the missing connection is the next field or workflow to fix.
Kerno is being built to help product businesses connect material inventory, lots, formulas, production records, and quality information without turning every investigation into a search across separate files. The business still needs clear receiving rules and consistent entries at the moment work happens.
Practical takeaway
Choose one raw material received this week. Build its incoming-lot record, label any secondary containers, then trace it forward to every batch that used it. A useful system should let another person complete that test without asking who remembers what happened.
Frequently asked questions
Is a supplier lot number the same as an internal lot number?
Not necessarily. The supplier lot identifies the source lot assigned by the supplier or manufacturer. An internal identifier may organize your receipt, storage, or usage. Keep the relationship between both.
What if a supplier does not provide a lot number?
Do not invent a supplier code. Record that none was provided, preserve the purchase and receipt evidence, assign a clearly labeled internal receipt ID, and decide whether the missing traceability is acceptable for that material and product.
Should packaging components receive lot records too?
Track packaging when variation or failure could affect product identity, protection, labeling, use, or an investigation. Caps, pumps, labels, liners, and containers may need more detail than ordinary shipping supplies.
How should partial containers be tracked after opening?
Keep the source lot identity on every secondary container, record relevant open or transfer dates, preserve status, and update remaining quantity through the normal inventory process.
How long should raw material lot records be kept?
Retention depends on the product, shelf life, contracts, insurance, and applicable regulations. Set a written policy with qualified guidance; do not use one generic period for every category.
