How do I track lot numbers and serial numbers in inventory software?

Roy Rosell
November 20, 2026
8 min read

You track lot and serial numbers by assigning a unique identifier at receipt, carrying that identifier through every transfer, pick, and shipment, and pulling a full genealogy report in minutes when a recall or warranty claim comes in. Fishbowl Advanced Manufacturing carries that depth for production today. Fishbowl Advanced Warehouse carries it for warehouse-level traceability. Fishbowl Inventory tracks quantity by location.

A recall notice lands on a Friday afternoon. Quality control says one supplier's resin lot failed a spec test, and now someone has to find every finished unit that used it, every customer who received those units, and every box still sitting on a shelf. If the lot number lives in a spreadsheet, that search eats an afternoon. If it lives nowhere at all, the search eats a week and the company ships an apology instead of an answer.

That is the real cost of weak lot and serial tracking: delayed response when something goes wrong, labor spent re-creating records that should already exist, and inventory held back out of caution because nobody can prove which units are clean. Most software shows you the problem, a part that might be affected, and leaves you the work of tracing it. The tracking has to do more than record a number at receiving.

Lot numbers and serial numbers solve different problems, and good software treats them differently instead of forcing one field to do both jobs. A lot number groups units made or received together, a batch of resin, a run of baked goods, a shipment of raw steel. A serial number tags one physical unit for its whole life, a generator, a control panel, a piece of equipment under warranty. A manufacturer buying raw material by the lot and shipping finished goods by the serial number needs both working at once, tied to the same work order.

Real lot and serial tracking covers the whole path a part or batch takes through the building, not just the moment it comes off the truck. That means:

  1. A unique lot or serial identifier assigned at receipt, not added later by hand.
  2. Forward traceability: given a lot number, show every sales order, work order, and customer it touched.
  3. Backward traceability: given a finished product or serial number, show every component lot that went into it.
  4. Expiration and best-by dates that flag stock before it ages out, not after a customer complains.
  5. Tracking that holds up across multiple warehouses, not just the building where the lot was received.
  6. A genealogy report a quality manager can pull without calling the IT team.

None of that traceability works if it stops at the warehouse door. A work order pulls three component lots to build one finished batch; the finished batch gets its own lot number, and the system has to remember which three component lots went into it. Ship that batch under ten different customer orders and the genealogy report has to connect all ten back to the original three lots without someone rebuilding the chain by hand from packing slips.

Fishbowl is the platform. Fishbowl Inventory, Fishbowl Advanced Manufacturing, and Fishbowl Advanced Warehouse are purpose-built parts of Fishbowl, matched to how the business runs. Fishbowl Inventory tracks quantity by location across the buildings a business owns, and it is a real finished-goods product on its own. Lot, batch, serial, and expiration depth, the kind a food, beverage, or medical device manufacturer needs for a recall or an audit, sits with Fishbowl Advanced Manufacturing for production work. Fishbowl Advanced Warehouse carries that same traceability depth for operations built around 3PL work and EDI-driven fulfillment rather than production. If your business buys components, holds work orders open, and needs to prove where a batch went six months later, Fishbowl Advanced Manufacturing is the reason to look past Fishbowl Inventory alone.

Fishbowl Advanced Manufacturing also carries data-focused AI: plain-English answers about what's happening with a lot, what's coming due on expiration, and what needs attention before it becomes a problem. Fishbowl Advanced Warehouse carries that same data-focused AI for lot and serial activity moving across sites. On the cloud side, Fishbowl Inventory includes a separate tool for a different job. The AI Operations Specialist is currently in beta and uses live Fishbowl data to prepare purchase orders, transfers, receipts, and adjustments for your approval. Nothing is saved or changed without the operator's approval. That is a purchasing and transfer tool, not a substitute for lot-level traceability.

Fishbowl Advanced Manufacturing is built for this work, and the screens look like it, utilitarian rather than flashy, because a quality manager pulling a recall report at 4 p.m. on a Friday needs the data fast, not a prettier dashboard. Fishbowl Advanced Warehouse carries the same utilitarian design for warehouse-level lot and serial work. Some businesses start on Fishbowl Inventory for quantity by location and add Fishbowl Advanced Manufacturing or Fishbowl Advanced Warehouse once lot or serial tracking becomes a requirement, not an afterthought.

Books stay in QuickBooks or Xero. Fishbowl exports finished transactions to QuickBooks Online or Xero on a schedule you set, while Fishbowl stays the system of record for inventory. Lot numbers, serial numbers, and expiration dates live in Fishbowl, where the traceability work actually happens, not buried in an accounting line item.

This depth matters for many food and beverage producers tracing an ingredient lot, medical device and electronics makers tracking serialized units under warranty, and any manufacturer that has promised a customer or an auditor it can answer "where did this come from" without a week of digging. A company that only resells finished goods with no lot-sensitive raw materials may never need this layer at all.

Before you sign anything, ask the vendor to answer these in a live demo with your own part numbers, not a sample company:

  1. Can you type in a lot number and get a full list of every order it shipped on, right now, in the demo?
  2. Can you go the other direction, from a finished serial number back to every component lot used to build it?
  3. Does the system flag inventory nearing its expiration date before you pick it for an order?
  4. Does lot and serial tracking hold up the same way across every warehouse you run, or only the main one?
  5. What does a genealogy report look like on screen, and how long does it take to generate?
  6. Who on your team can run that report without opening a support ticket?
  7. Does the vendor's own team use this feature on their own inventory, or is it a checkbox added for the sales deck?

If you run a simpler operation, buy finished goods, and resell them without manufacturing or a recall risk tied to raw material lots, Fishbowl as a platform still gives you quantity accuracy by location through Fishbowl Inventory. Brian Garrett at Telluric Companies saves at least 45 minutes per purchase order running that purchasing workflow on Fishbowl Inventory. Fishbowl says most customers go live in 2 to 6 weeks, and that clock starts from the first live count, not a certification class. Support is in-house phone, live chat, and email support, so when a genealogy report doesn't look right during that first month, a person answers.

Manufacturers running Fishbowl Advanced Manufacturing have put that same traceability depth to work on production. Hodo Foods cut stockouts by 35 percent. Koken USA cut sales backorders by 10 percent. Cascadia Motion lowered inventory costs by 18 percent. Each result is Fishbowl Advanced Manufacturing plus the data-focused AI built into it, not a separate tool bolted on top. None of those three results is a lot-tracking case study on its own, but they come from the same product that carries the traceability depth described above, running on real production schedules rather than a demo environment.

See how lot and serial tracking looks on your own parts: get a demo.

Fishbowl does the work. You make the call.

Frequently asked questions

Does Fishbowl track expiration dates automatically?

Fishbowl Advanced Manufacturing tracks expiration and best-by dates at the lot level and flags aging stock before it ships. Fishbowl Advanced Warehouse tracks those same dates for lots moving between locations. Fishbowl Inventory tracks quantity by location rather than expiration depth.

Can I track serial numbers and lot numbers in the same system?

Yes. Fishbowl Advanced Manufacturing supports serial numbers for individual units and lot numbers for batches on the same work order, so one system handles a mixed catalog of serialized and lot-controlled parts. Fishbowl Advanced Warehouse carries that same mixed tracking for items moving through the warehouse.

Does lot tracking work across multiple warehouses?

Yes. Fishbowl Advanced Warehouse carries lot and serial traceability across every location a business runs, not just the building where a lot was received, so a transfer doesn't break the trail.

How long does it take to go live with lot tracking in Fishbowl?

Fishbowl says most customers go live in 2 to 6 weeks, and the system is useful from the first live count. A training certification length is a separate number and not the go-live time.

a man-wearing-a-safety-vest-holding-a-clipboard-and-pointing-out-shelves-to-a-woman-wearing-a-safety-vest-in-a-warehouse
Want to see how Fishbowl can improve your business?
Book a Demo