|
Getting your Trinity Audio player ready...
|
Business Central Lot Expiration Tracking: A Practical Guide to Expiry, FEFO & Inventory Control
For a business selling products with a limited shelf life, inventory on hand is not always inventory you can sell.
A warehouse may show thousands of units available, but some of those units could expire before they reach the customer. If your ERP does not clearly connect lot numbers with expiration dates, your teams may discover the problem only when it is too late.
Microsoft Dynamics 365 Business Central provides item-tracking capabilities that can help businesses manage lot numbers, expiration dates, warehouse activities, and expiry-driven picking. When configured correctly, these capabilities can help organizations reduce avoidable waste, improve inventory visibility, and make warehouse decisions based on product shelf life rather than simply the date inventory arrived.
This guide explains how lot expiration works in Business Central, how to configure it, how FEFO picking fits into the process, and what businesses should consider before implementing it.
What Is Lot Expiration Tracking in Business Central?
Lot expiration tracking connects a product’s lot number with its expiration date.
Instead of looking at inventory as one large quantity, Business Central can distinguish between individual batches and their remaining shelf life.
For example, imagine a food distributor has three lots of the same product:
|
Lot |
Quantity |
Expiration |
|
LOT-101 |
2,000 |
September 15 |
|
LOT-102 |
3,000 |
October 10 |
|
LOT-103 |
2,500 |
November 5 |
A simple inventory report may tell the warehouse that it has 7,500 units.
Expiration-aware inventory management tells a very different story:
2,000 units need attention first.
That difference becomes extremely important when products have short shelf lives.
Business Central’s item-tracking functionality supports serial and lot tracking and includes configuration options for expiration dates. Microsoft also provides specific functionality for calculating expiration dates for tracked items.
Why Expiration Management Matters More Than an “On-Hand” Number
One of the most common inventory mistakes is assuming that every unit shown as available is equally usable.
It isn’t.
A product can be:
- physically available but already expired,
- available today but unsuitable for a future delivery date,
- technically sellable but too close to expiration for a customer’s requirements,
- sitting in the warehouse while another lot is approaching expiry,
- or difficult to trace because the lot information was not captured correctly.
For businesses handling food, beverages, pharmaceuticals, chemicals, cosmetics, nutraceuticals, or other shelf-life products, these situations can quickly turn into financial and operational problems.
- Reduce inventory waste
Products that remain unnoticed until their expiration date can become write-offs.
Earlier visibility gives purchasing, sales, warehouse, and operations teams more time to decide whether inventory should be:
- shipped,
- consumed in production,
- discounted,
- transferred,
- returned where appropriate,
- inspected,
- or disposed of.
- Improve traceability
Lot tracking gives organizations a clearer record of which batch entered inventory and where it moved.
This can be particularly important when businesses need to investigate a quality issue or identify affected inventory.
- Improve customer service
Some customers have minimum remaining-shelf-life requirements.
Shipping a product that expires shortly after delivery may result in rejected shipments, returns, or damaged customer relationships—even though the product technically wasn’t expired when shipped.
- Make inventory planning more realistic
Inventory planning becomes more useful when the organization understands not only how much stock exists, but also how long that stock remains usable.
How Business Central Handles Lot Expiration
The process starts with Item Tracking Codes.
Business Central lets organizations configure item tracking rules and specify whether expiration dates should be used for tracked items. Microsoft identifies fields including Use Expiration Dates, Require Expiration Date Entry, and Strict Expiration Posting as part of the expiration setup.
The basic process looks like this:
Item → Item Tracking Code → Lot Number → Expiration Date → Warehouse → Picking → Shipment
The quality of the final result depends heavily on what happens at the beginning.
If the expiration date is missing or incorrect when inventory enters the system, downstream processes such as FEFO picking and expiry reporting cannot provide reliable information.
Step 1: Configure the Item Tracking Code
Search for Item Tracking Codes in Business Central.
Create or modify the appropriate tracking code and review the expiration-related fields.
Use Expiration Dates
This tells Business Central that expiration dates should be used for the tracked item.
Require Expiration Date Entry
When enabled, users must provide an expiration date on the item tracking line when required by the transaction.
Strict Expiration Posting
This option provides stronger control over expired inventory.
Microsoft describes Strict Expiration Posting as a setting that respects the expiration date assigned when the item entered inventory when that inventory later exits the system.
This is particularly relevant when shipping or consuming expired material should not be permitted.
Important: Don’t automatically apply the strictest rule to every product.
A pharmaceutical product, perishable food item, and non-perishable industrial component may have very different business requirements.
Step 2: Assign the Tracking Code to the Item
After configuring the tracking code, assign it to the relevant item.
The item card is where you connect the item to its tracking rules.
This allows different categories of inventory to have different policies.
For example:
Finished food products
- Lot tracking
- Expiration dates
- Strict expiry control
- FEFO warehouse picking
Packaging materials
- Lot tracking may be sufficient
- Expiration tracking may not be necessary
Chemical products
- Lot tracking
- Expiration dates
- Controlled outbound transactions
The objective is not to make every item follow the same process.
The objective is to create the right control for the right inventory.
Step 3: Decide How Expiration Dates Should Be Calculated
Not every business receives expiration dates in the same way.
There are two common scenarios.
Supplier-provided expiration date
A supplier may deliver a batch with a predefined expiration date.
In this case, the receiving team records the actual expiration date associated with the lot.
System-calculated expiration date
Manufacturers may have predictable shelf-life rules.
For example:
Production date + 180 days = expiration date
Business Central supports expiration calculation as part of item tracking configuration. Microsoft specifically includes expiration calculation in its Business Central training and item-tracking functionality.
This can reduce manual data entry for products with consistent shelf lives.
Step 4: Capture the Lot and Expiration Date When Inventory Enters the System
This is one of the most important parts of the process.
The expiration date should be captured when the relevant inventory enters Business Central.
Depending on the business process, that may happen during:
- purchase receiving,
- production output,
- assembly,
- inventory adjustments,
- or other item-tracking transactions.
For purchased goods, the warehouse team can record the supplier’s lot and expiration information.
For manufactured products, the expiration date may be calculated according to the item’s shelf-life rules.
Why this matters
Consider a warehouse that receives 20,000 units but records the lot number without the expiration date.
The quantity is technically in the ERP.
The batch exists.
But the system has lost one of the most important pieces of information needed to manage that inventory.
Accurate tracking starts at receiving and production—not at the point when inventory is about to expire.
FEFO: The Inventory Strategy That Uses Expiration Dates
FIFO and FEFO are often confused.
FIFO
First In, First Out
The inventory received first is generally prioritized first.
FEFO
First Expired, First Out
The inventory with the earliest expiration date is prioritized first.
For shelf-life products, FEFO can be much more meaningful than simply looking at receipt dates.
Imagine:
- Lot A arrived on June 1 and expires December 1.
- Lot B arrived on June 20 and expires September 15.
FIFO may favor Lot A because it arrived first.
FEFO favors Lot B because it expires first.
That distinction can prevent perfectly usable inventory from sitting in the warehouse while a shorter-dated batch becomes obsolete.
Microsoft’s current documentation confirms that Business Central can sort item-tracked warehouse picks according to expiration date when FEFO is enabled.
How to Enable FEFO in Business Central
FEFO isn’t simply a checkbox that magically fixes inventory management.
Microsoft indicates that FEFO requires the item to have an appropriate item tracking setup, warehouse tracking, expiration information, and the Pick According to FEFO setting enabled on the location.
A typical setup therefore involves:
- Assigning an appropriate item tracking code.
- Enabling lot or relevant warehouse tracking.
- Ensuring inventory has expiration dates.
- Enabling Pick According to FEFO on the location.
- Testing warehouse picks with multiple lots and expiration dates.
Once configured, Business Central can prioritize items with the earliest expiration dates during applicable warehouse picking processes.
What Happens When Inventory Is About to Expire?
Expiration management shouldn’t begin on the expiration date.
The goal is to identify risk early.
Suppose a distributor has:
1,500 units expiring in 20 days.
The business might still have time to:
- prioritize those units for customer orders,
- contact customers,
- adjust pricing,
- move stock to another location,
- use the material in production,
- or investigate why the inventory has not moved.
That is much better than discovering 1,500 expired units after the expiration date.
Use the Item Expiration – Quantity Report
Business Central includes an Item Expiration – Quantity report designed specifically to show inventory for items that are tracked for expiration.
Microsoft’s current documentation says the report can highlight inventory that has already expired or is approaching expiration and can support corrective actions such as disposal or quality-control review.
This makes the report useful for more than warehouse teams.
Warehouse managers
Identify inventory approaching expiration.
Purchasing teams
Avoid buying more stock when existing inventory is already aging.
Quality teams
Identify products requiring inspection or corrective action.
Finance teams
Understand potential inventory write-off exposure.
Sales teams
Know when inventory needs to be prioritized before its shelf life becomes a problem.
A Better Way to Think About Expiring Inventory
Instead of asking:
“How much inventory do we have?”
Businesses should increasingly ask:
“How much usable inventory do we have, and how long will it remain usable?”
That shift can change purchasing, sales, warehouse, and production decisions.
For example:
|
Inventory Question |
Traditional View |
Expiration-Aware View |
|
How much stock exists? |
10,000 units |
10,000 units |
|
How much can ship today? |
10,000 units |
Depends on expiry |
|
What should ship first? |
Oldest receipt |
Earliest expiration |
|
What needs attention? |
Low stock |
Aging + low stock |
|
What may become waste? |
Hard to identify |
Expiring lots visible |
|
What should purchasing do? |
Reorder based on quantity |
Consider quantity + shelf life |
Can Business Central Prevent Expired Inventory From Being Shipped?
It can provide stronger control when expiration rules are configured appropriately.
For example, with Strict Expiration Posting enabled, expired item tracking numbers can be prevented from being posted out of inventory according to the configured rules. Microsoft’s FEFO documentation also notes that when Strict Expiration Posting is selected, expired items are excluded from FEFO picks.
But businesses should think carefully before enabling this setting.
A strict rule can protect against accidental shipment of expired products, but it can also create operational exceptions that warehouse and customer-service teams need to understand.
The right approach is to define the policy first and then configure Business Central to support it.
What About Warehouse Management?
Lot expiration becomes even more valuable when connected with warehouse processes.
If warehouse tracking isn’t configured correctly, the expiration information captured in inventory may not flow through the warehouse activities the way the business expects.
Microsoft notes that SN Warehouse Tracking and Lot Warehouse Tracking need to be enabled on the item tracking code when item tracking numbers are to be assigned in warehouse activities.
This is why an expiration project shouldn’t be treated as a simple field-setting exercise.
A successful implementation should consider:
Item setup → Tracking → Receiving → Storage → Picking → Shipment → Reporting
Every stage needs to work together.
What If the Expiration Date Was Entered Incorrectly?
Data-entry mistakes happen.
A receiving employee might enter the wrong expiration date, or a lot may need to be reclassified because the original information was incorrect.
Business Central supports reclassification of tracked inventory, including expiration-date changes, through item reclassification processes. Microsoft’s documentation also outlines specific rules around changing expiration dates when reclassifying lots.
However, this should be treated as a controlled inventory process—not an informal correction.
Businesses should define:
- who can make corrections,
- when approval is required,
- how supporting documentation is retained,
- and how warehouse teams are notified.
Industries That Benefit Most From Lot Expiration Tracking
Food & Beverage
Manufacturers and distributors often manage products with relatively short shelf lives.
Lot expiration tracking combined with FEFO can help teams prioritize the inventory that needs to move first.
Pharmaceuticals & Nutraceuticals
Expiration and lot traceability can become critical operational requirements.
Businesses need visibility into which batches are available, where they are located, and when they expire.
Chemicals
Products such as adhesives, coatings, resins, and other formulations may have defined usable lifetimes.
Expired material can affect product performance and customer outcomes.
Cosmetics & Personal Care
Many products have shelf-life considerations and batch-level traceability requirements.
Distribution & Wholesale
Distributors may not manufacture the products themselves, but they still carry the financial and customer-service risk associated with short-dated inventory.
7 Common Lot Expiration Mistakes
Even when Business Central is configured for item tracking, the process can fail if the surrounding business rules are weak.
- Tracking lots but not expiration dates
Lot tracking alone doesn’t provide complete shelf-life visibility.
- Entering expiration dates manually without validation
Incorrect dates can undermine every downstream process.
- Enabling FEFO without proper warehouse configuration
FEFO depends on the underlying tracking and warehouse setup being correct.
- Treating all inventory the same
Not every product requires strict expiration controls.
- Looking only at total inventory
10,000 units on hand doesn’t necessarily mean 10,000 usable units.
- Waiting until inventory has already expired
The objective should be proactive management, not post-expiration cleanup.
- Implementing the feature without testing real warehouse scenarios
A configuration can look correct on paper and still fail when multiple lots, locations, bins, and expiration dates are involved.
A Practical Implementation Approach
If you’re implementing lot expiration tracking in Business Central, don’t start by turning on every available setting.
Start with the business process.
Phase 1: Identify the products
Determine which items have:
- mandatory expiration requirements,
- commercial shelf-life requirements,
- customer-specific shelf-life rules,
- or no meaningful expiration risk.
Phase 2: Define tracking policies
Decide which items require:
- lot tracking,
- expiration dates,
- mandatory expiration entry,
- strict expiration posting,
- warehouse tracking,
Phase 3: Configure Business Central
Set up the appropriate item tracking codes and item-level expiration rules.
Phase 4: Configure warehouse processes
Test receiving, put-away, picking, movement, and shipping.
Phase 5: Test real scenarios
Don’t test only a single lot.
Use multiple lots with different expiration dates and simulate:
- normal sales,
- short-dated inventory,
- expired inventory,
- partial quantities,
- warehouse transfers,
- and customer orders with future delivery dates.
Phase 6: Establish monitoring
Create a recurring process for reviewing expiring inventory.
The ERP can provide the information, but people still need to act on it.
Business Central Lot Expiration Checklist
Before going live, review the following:
- Relevant items have the correct Item Tracking Code.
- Lot tracking is configured where required.
- Expiration dates are enabled for applicable items.
- Expiration date entry requirements are defined.
- Expiration calculation is configured where shelf life is predictable.
- Strict Expiration Posting is applied only where appropriate.
- Warehouse tracking is configured for relevant locations.
- FEFO is enabled where the warehouse process requires it.
- Receiving teams know how to capture supplier expiration dates.
- Production teams understand expiration calculation rules.
- Warehouse teams understand FEFO.
- Expiring inventory is reviewed regularly.
- The Item Expiration – Quantity report is incorporated into the review process.
- A controlled process exists for correcting tracking information.
- Real-world warehouse scenarios have been tested before go-live.
Final Takeaway: Expiration Management Is More Than a Date Field
Lot expiration tracking in Business Central isn’t simply about putting an expiration date against a lot number.
The real value comes from connecting that information to the way your business receives, stores, plans, picks, sells, and monitors inventory.
When configured correctly, Business Central can help teams move from reactive inventory management to a more proactive model:
Know the lot.
Know the expiration date.
Know where the inventory is.
Prioritize what expires first.
Act before inventory becomes waste.
For businesses dealing with shelf-life products, that can mean better inventory visibility, fewer avoidable write-offs, more controlled warehouse operations, and better customer service.
If your current Business Central environment tracks lots but still relies heavily on spreadsheets or manual checks to monitor expiration dates, it may be worth reviewing whether your item tracking and warehouse configuration is doing enough.
Frequently Asked Questions
- Does Business Central support expiration dates for lot numbers?
Yes. Business Central supports expiration-date tracking as part of its item-tracking functionality. Expiration rules can be configured through Item Tracking Codes.
2. What is FEFO in Business Central?
FEFO means First Expired, First Out. It prioritizes inventory with the earliest expiration date during applicable warehouse picking processes.
3. Is FEFO the same as FIFO?
No. FIFO prioritizes inventory based on when it entered inventory, while FEFO prioritizes inventory based on its expiration date.
4. Can Business Central calculate expiration dates automatically?
Yes, Business Central supports expiration calculation for tracked items. The exact setup depends on the item’s tracking configuration and business rules.
5. Can Business Central report on inventory that is about to expire?
Yes. The Item Expiration – Quantity report is designed to identify inventory that has expired or is approaching expiration.
5. Should every Business Central item use strict expiration posting?
No. Strict expiration controls should be applied according to the product’s risk, regulatory requirements, and business process.
6. Does expiration tracking work with warehouse management?
Yes, but the relevant warehouse tracking configuration needs to be in place. Microsoft specifically identifies warehouse tracking settings as part of the setup for item tracking in warehouse activities.
7. Can an expiration date be corrected after inventory has been posted?
Business Central supports reclassification processes for tracked inventory, including expiration-date changes, subject to the applicable reclassification rules.
8. Need Help Optimizing Business Central Inventory Management?
Lot expiration is only one part of a larger inventory-management strategy.
If your organization is struggling with lot tracking, warehouse visibility, FEFO, inventory planning, or Business Central configuration, a review of your current setup can help identify where manual processes and configuration gaps are creating unnecessary inventory risk.
Brightpoint Infotech helps organizations implement, customize, migrate, integrate, and support Microsoft Dynamics 365 Business Central and other Dynamics 365 solutions.
Want to get more value from your Business Central inventory system? Talk to our Dynamics 365 experts about your inventory, warehouse, and ERP requirements.