Identity and source
Internal lot, supplier lot, item, supplier, purchase or receipt reference and received date.
Start with the fields needed to identify, release, locate and trace a lot—then see how the same register works as a connected App.
The example is already populated with released, pending, held, expiring and consumed lots plus related receipts, production records and shipments.
Free for up to five users. No credit card required.
Adapt fields, workflows, and dashboards without code. Explore 1,000+ app templates and use cases
The gallery shows populated sample data in the Jodoo App. Open any view to inspect the records and decisions, then install a copy to adapt the fields and workflow.
The template separates identity, availability and history so a row can answer more than “how many?”
Internal lot, supplier lot, item, supplier, purchase or receipt reference and received date.
Original, remaining, held and available quantity with the correct unit of measure.
Inspection state, lot status, manufacture date, expiry or retest date and final disposition.
Current location plus links to receipt, production consumption, output, movement and shipment records.
Sample states make the template easier to test and expose which fields are missing.
Received quantity is approved, remaining quantity is known and the lot can be selected for production.
The stock exists physically but remains unavailable until the inspection and decision are complete.
The row names the hold reason, affected quantity, owner and investigation rather than only changing color.
Remaining quantity reaches zero and the linked production run explains which output was created.
Do not add complexity without a reason, but do not let the file hide operational risk.
| Need | Template can work | Connected App helps when |
|---|---|---|
| Lot register | One owner and limited volume | Several roles capture and use the data |
| Release decision | Simple documented convention | Tasks, evidence and permissions matter |
| Movement history | Few manual transfers | Locations and quantities change frequently |
| Genealogy | Little or no transformation | Inputs split, merge or become outputs |
| Recall trace | Rare, simple lookup | Destinations, actions and verification must coordinate |
A spreadsheet is useful for a small register; several warning signs show that connected records and workflow are needed.
Permissions, simultaneous work and reliable history become more important than a shared file convention.
Receipts, production, movements and shipments should reference the same lot instead of repeating text.
Release and hold should come from an assigned review with evidence, not an editable dropdown alone.
If every investigation requires filters across exports, a connected genealogy view provides more value.
Jodoo can reproduce the useful parts of the template while separating related receipts, genealogy, movements and shipments into clearer records.
A useful lot template can become an operational multi-user App in hours without discarding the structure your team understands.Use the same identifiers and status logic, then validate duplicates, required fields and relationships at entry.
Receiving, quality and warehouse users do not have to work in the same wide spreadsheet.
Route release, return and closeout decisions and adjust the forms as your operating rules change.
Jodoo is designed for teams that need connected records, human decisions and adaptable workflow. It does not pretend to replace every specialist execution system.
Operational teams that can identify lots, batches or serials and need to connect receiving, production, movement, shipment and follow-up without commissioning custom software.
Connect ERP, MES, WMS, label printing or machine data when those systems remain the system of record for transactions or automated capture.
The example is not a validated pharmaceutical eBR, a certified regulatory solution or automatic proof of compliance. Your controls, validation and governance still matter.
Include item, internal and supplier lot, supplier, dates, quantity, unit, location, status and disposition. Add references to inspections, production, movements and shipments when tracing matters.
The page provides the field structure and a populated Jodoo App you can inspect. It is designed to help you build a reliable lot process instead of leaving you with an isolated file.
Yes, subject to data preparation and the import method you choose. Normalize identifiers, units and statuses before import so duplicates and ambiguous rows do not become permanent.
Consider an App when several people update the register, approvals or permissions matter, lots connect to many records, or trace investigations require repeated manual reconciliation.
Open the populated App, compare it with the field structure and adapt the records and workflow without code.
Use this lot tracking template