Lot Expiration in Business Central: How to Set It Up and Manage Inventory Before It Expires

Every business that sells food, pharmaceuticals, chemicals, or any item with a shelf life eventually faces the same costly problem: stock that expires before it ships. Lot expiration tracking in Business Central solves this by attaching an expiration date to every lot number and using that date to guide picking, block expired stock, and flag inventory before it becomes waste. This guide walks through the full setup process, the rules that govern strict versus standard expiration, FEFO picking, monitoring tools, and the mistakes that quietly cost businesses money.

What Is Lot Expiration Tracking in Business Central?

Lot expiration tracking is a Business Central inventory feature that attaches an expiration date to each lot number, then uses that date to control picking, availability, and reporting. It ensures the system always knows which batches are closest to expiring, prevents expired stock from being sold or consumed, and gives warehouse teams a clear view of what needs to move first.

The feature sits inside Business Central's broader item tracking system, alongside serial numbers and package numbers. Where serial tracking follows a single unit through its lifecycle, lot tracking follows a batch, and expiration tracking adds a time dimension to that batch. A lot of raw flour, a batch of pharmaceutical tablets, or a container of industrial adhesive can all carry an expiration date that Business Central checks automatically during purchasing, production, sales, and warehouse activities.

This matters because inventory value on a report doesn't tell you the whole story. A warehouse can show 10,000 units on hand and still be unable to fulfill an order, because a portion of that quantity belongs to a lot that will expire before the shipment date. Expiration tracking closes that gap, and it's one piece of a much broader inventory management toolkit inside Business Central.

Why Lot Expiration Management Matters for Your Business?

Businesses that skip proper expiration tracking absorb three costs repeatedly: inventory write-offs, regulatory exposure, and customer complaints tied to short-dated products. Lot expiration tracking in Business Central directly reduces all three by automating what most companies still do manually with spreadsheets or physical date checks.

A few concrete reasons this capability earns its place in an ERP rollout:

• Waste reduction. Perishable and shelf-life items that go untracked tend to sit at the back of a shelf until they expire. Automated expiration visibility surfaces aging stock while it can still be sold, discounted, or used.
• Regulatory compliance. Food, beverage, pharmaceutical, and chemical companies are frequently required to prove lot traceability and expiration control during audits. FDA, USDA, and industry-specific regulations often mandate documented expiration handling.
• Customer trust. Shipping product with minimal remaining shelf life damages relationships with distributors and retailers, some of whom enforce minimum shelf life requirements on incoming shipments.
• Financial accuracy. Expired inventory that isn't written off on time overstates asset value on the balance sheet.

Industries where this feature is close to mandatory include food and beverage manufacturing, pharmaceutical and nutraceutical production, chemical and industrial supply, and cosmetics and personal care manufacturing.

How to Set Up Lot Expiration Tracking in Business Central?

Setting up lot expiration in Business Central involves creating or editing an Item Tracking Code with expiration rules enabled, then assigning that tracking code to the relevant items. Once assigned, Business Central requires an expiration date every time the item is received, produced, or moved, and uses that date automatically in picking and availability logic.

Here is the step-by-step process:

1. Open Item Tracking Codes: Use the search icon (Alt+Q), type "Item Tracking Codes," and open the page. You can edit an existing code or create a new one specifically for expiration-managed items.
2. Go to the Misc. FastTab: This is where the expiration-related fields live on the Item Tracking Code Card.
3. Enable "Use Expiration Dates:" This tells Business Central to calculate and store an expiration date for every lot or serial number under this tracking code.
4. Enable "Require Expiration Date Entry" if the date should be mandatory: With this on, users cannot post an inbound transaction for the item without entering an expiration date.
5. Decide whether to enable "Strict Expiration Posting:" With this turned on, Business Central blocks users from posting an outbound transaction for a lot that has already expired. Without it, the system allows the posting but still shows the expiration data for reference.
6. Enable SN/Lot Warehouse Tracking if you use advanced warehousing: This makes sure lot and expiration data carries through to warehouse activities like pick and put-away, not just item ledger entries.
7. Assign the Item Tracking Code to your items: On the item card, open the Item Tracking FastTab and select the tracking code you configured. Items using different rules can use different tracking codes, so you're not forced into a single policy across your whole catalog.
8. Set the Expiration Calculation field on the Item Card (optional, recommended for manufacturers): This is a separate field from the tracking code, also on the Item Tracking FastTab. Enter a date formula such as 90D (90 days) or 1Y (one year), and Business Central will calculate the expiration date automatically from the posting date instead of requiring a manual entry every time.
9. Test with a purchase or production transaction: Post a receipt or output and confirm that Business Central prompts for a lot number and expiration date, or calculates the date automatically if you set the Expiration Calculation formula.

Golden rule for implementation teams: don't assign strict expiration handling to every item by default. Reserve it for items where shipping expired stock creates real regulatory or safety risk. For lower-risk items, standard tracking with reporting visibility is often enough and avoids unnecessary transaction friction for warehouse staff.

Strict vs. Standard Expiration: Which Rule Fits Your Item

Business Central offers two practical approaches to expiration enforcement, and choosing the wrong one for a given item either creates unnecessary friction or leaves a compliance gap. The table below compares them directly.

Recording Expiration Dates During Purchase, Production, and Assembly

Business Central captures expiration dates at the point items enter inventory, whether through a purchase order, a production order output, an assembly order, or an item journal line. If the assigned item tracking code requires an expiration date, the system will not let the transaction post until one is entered or calculated.

For purchased items, the expiration date is entered on the Item Tracking Lines page while receiving the purchase order. If your supplier prints a "best by" or "use by" date on the packaging, that value goes directly into this field. For manufactured items, the expiration date is typically entered (or auto-calculated via the Expiration Calculation formula on the item card) when posting production order output, since that's the moment the finished good actually enters inventory.

A practical detail many teams miss: the expiration date is never suggested by Business Central unless you configure the Expiration Calculation field on the item card. Without it, the field stays blank until someone types a value, which means data quality depends entirely on how disciplined your receiving and production teams are at entering it correctly.

FEFO Picking: How Business Central Prioritizes Expiring Stock First

FEFO stands for First Expired, First Out, and it's the picking logic Business Central uses to select inventory closest to its expiration date before older or newer stock with a later date. This differs from FIFO (First In, First Out), which picks based on receipt date rather than expiration date, and matters most for items where shelf life, not warehouse age, determines usability.

When FEFO is active and a sales order or production order calls for a pick, Business Central evaluates the available lots for that item and suggests the one expiring soonest, even if it arrived in the warehouse more recently than another lot. If a bin holds multiple lots of the same item with different expiration dates, the system will split the pick line so the batch expiring first goes out the door before others.

FEFO logic depends on expiration dates being accurately captured in the first place. If expiration data is missing or inconsistent, the picking suggestions become unreliable, which is one more reason accurate data entry at receipt matters more than it might seem.

Monitoring Expiring and Expired Inventory

Business Central gives inventory managers two primary tools for staying ahead of expiration risk: the Item Expiration - Quantity report and the graphical inventory profile with expiration date handling enabled. Together, they answer the two questions that matter most: what has already expired, and what will expire soon enough to require action.

Item Expiration - Quantity report: This standard report shows current on-hand inventory for items with expiration tracking, letting you specify an ending date and a period length. Run it weekly or monthly to identify stock that has expired or is approaching its expiration window, then take action such as disposal, discounting, or scheduling a quality control check.

Graphical inventory profile: With expiration date handling enabled in the profile setup (a single checkmark), the graphical view factors expiration into projected availability. This surfaces a scenario that a plain on-hand quantity report misses entirely: total stock looks sufficient, but a portion of it belongs to a lot that will expire before a scheduled sales order ships, meaning the order may not actually be fulfillable as planned.

Reviewing both regularly, rather than relying on total quantity on hand, is what actually prevents expired stock from reaching a customer.

Don't Let Expiring Lots Hide in Your Availability Numbers

By default, Business Central's standard item availability check counts all on-hand inventory toward what can be reserved or sold, including batches that will expire before the delivery date. This creates a false sense of coverage unless you enable the "Show Items That Expire" field in the reserved quantity setup, which tells the system to reserve only stock that will still be usable on the delivery date.

To turn this on: open the Item Availability setup, go to the general setup list, find the reserved quantity line, open its setup card, and enable "Show Items That Expire." Once active, Business Central excludes batches that will have expired by the promised delivery date from what it offers up for reservation, giving sales teams an accurate picture before they commit to a customer.

Changing a Lot Number or Expiration Date After Posting

Business Central does not allow most posted transaction details to be edited directly, but lot numbers and expiration dates are an exception, handled through the Item Reclassification Journal rather than a direct field edit. This is useful when a data entry error is discovered after the fact, or when a partial quantity within a lot needs to be reclassified with a corrected date.

To make the correction, open the Item Reclassification Journal, select the item and existing lot, and enter the new lot number or expiration date on the line. You are not required to reclassify the entire quantity; a partial quantity can be split off and corrected while the rest of the lot remains untouched. This keeps your item ledger entries accurate without requiring a full inventory adjustment out and back in.

Common Mistakes to Avoid When Managing Lot Expiration

Even well-implemented Business Central environments run into avoidable expiration-tracking issues. The most frequent ones worth checking for:

• Applying strict expiration to every item: This adds transaction friction to low-risk items and slows down warehouse operations without a real compliance benefit.
• Skipping the Expiration Calculation field for manufactured goods: Manual entry invites inconsistent or missing dates, especially during high-volume production runs.
• Leaving "Show Items That Expire" disabled: Sales teams end up promising inventory that technically exists but won't be usable by the delivery date.
• Not training warehouse staff on why the date matters: If receiving staff treat the expiration date field as an afterthought, every downstream FEFO and reporting benefit breaks down.
• Never reviewing the Item Expiration - Quantity report on a schedule: The report only helps if someone actually runs it and acts on what it shows.
• Ignoring item tracking code differences across item categories: Not every item needs the same rules; a one-size-fits-all tracking code setup usually under-serves some products and over-complicates others.

Industry Use Cases for Lot Expiration Tracking

Food and beverage manufacturers rely on lot expiration tracking combined with FEFO picking to meet retailer minimum shelf life requirements and reduce spoilage-related write-offs, which is often one of the largest hidden costs in the category.

Pharmaceutical and nutraceutical companies use strict expiration posting to satisfy regulatory documentation requirements and prevent expired product from being dispensed or shipped, which carries direct legal exposure if it happens. These industries typically fall under process manufacturing in Business Central, where formula-based production adds another layer of traceability on top of lot expiration.

Chemical and industrial suppliers track expiration on products with defined shelf lives, such as adhesives, coatings, and reagents, where using expired material can affect product performance or safety on a customer's site.

Distributors managing third-party brands often need expiration visibility purely for inventory accuracy and customer service, even without a regulatory mandate, since shipping short-dated stock to a retail customer creates returns and relationship friction.

Lot Expiration Setup Checklist

Use this as a quick reference before going live:

• Item Tracking Code created with "Use Expiration Dates" enabled
• Strict Expiration Posting applied only to items where it's genuinely needed
• Expiration Calculation field (on the item card) configured for manufactured items with predictable shelf life
• SN/Lot Warehouse Tracking enabled if using advanced warehousing
• Item Tracking Code assigned to all relevant items
• "Show Items That Expire" enabled in reserved quantity setup
• Item Expiration - Quantity report scheduled for regular review
• Graphical inventory profile expiration handling enabled
• Warehouse and receiving staff trained on accurate date entry
• Item Reclassification Journal process documented for corrections

Why Choose Dynamics Square for Business Central Implementation?

Getting lot expiration tracking right is a configuration detail, but getting the entire inventory setup right, tracking codes, warehouse rules, reporting, and reservation logic working together, takes implementation experience. Dynamics Square has spent 15+ years as a Microsoft Solutions Partner helping food, pharmaceutical, chemical, and distribution businesses across the USA configure Business Central inventory management the right way the first time.

Our certified consultants handle end-to-end Business Central implementation, customization, integration, data migration, and upgrades, along with ongoing support once you're live. Whether you're setting up expiration tracking for the first time or fixing gaps in an existing deployment, our team has done it across multiple industries and can help you avoid the common mistakes that create write-offs and compliance risk down the line. If you're budgeting a new rollout, our ERP implementation cost calculator gives you a starting estimate before you talk to a consultant.

Dynamics Square supports businesses across the USA, UK, Canada, and other global regions. Reach our USA offices directly:

• California:+1 213 784 0845
• Texas: +1 281 899 0865
• Illinois:+1 312 488 1043

Ready to stop losing inventory value to expired stock? Connect with a Dynamics Square Business Central consultant for a free assessment of your current item tracking setup.