Quickbooky

Accounting News

QuickBooks

Lot Tracking in QuickBooks Enterprise: What It Can and Cannot Do

A practical look at lot tracking in QuickBooks Enterprise, including what the feature covers, where it falls short, and what to check before you rely on it.

Lot Tracking in QuickBooks Enterprise: What It Can and Cannot Do

QuickBooks Enterprise includes lot tracking among its advanced inventory features, and for many small businesses it covers the basics well. It is not a full lot-management system, though. Knowing the limits before you build your workflow around them saves real pain later.

What lot tracking in Enterprise covers

With the Advanced Inventory add-on enabled, Enterprise lets you assign a lot number when you receive inventory. Each lot is then tracked through sales, so you can see which lot a shipped item came from. The software supports FIFO costing for lots, and reports can show which customers received a given lot.

That is enough for many resellers and light manufacturers. If your need is traceability, so you can answer “which lot went to which customer,” the feature generally handles it.

Where the limits show up

The constraints matter more than the feature list. Lot numbers in Enterprise apply to inventory items bought and sold as inventory parts. Items that are not inventory items, such as non-inventory parts or services, do not carry lot numbers.

Assembly work is another gap. Building an assembly does not automatically pass a lot number from components into the finished assembly. If you need full genealogy, meaning the lots inside a finished good traced back to their receipts, you will need workarounds or a third-party add-on.

Expiration dates are also limited. Enterprise records them, but it does not do full lot-expiry-driven picking, where the system directs a picker to the oldest expiring lot automatically at the moment of fulfillment.

What we suggest checking first

Before committing, test your actual workflow in a sample file. Receive a lot, sell part of it, build an assembly if you use them, and run the lot reports. That one exercise tells you more than any feature list.

If you need component-to-assembly traceability or expiry-directed picking, evaluate a dedicated inventory add-on that integrates with QuickBooks. Deciding that early is far cheaper than discovering it after a recall.

← Back to News