CODERS Solutions
ERP Solutions

One Bad Batch: Lot Tracking, Expiry Dates and Recalls in Business Central

Nov 14, 2026 5 min read

Why traceability matters for food, pharma and FMCG

Food producers, pharmaceutical distributors, supermarkets and FMCG wholesalers in Lebanon and Ghana face the same pressure. Regulators, retail chains and export buyers expect proof of where every unit came from and where it went. A company that cannot isolate one batch often has to pull far more stock than necessary, losing product, margin and customer trust.

Expiry is the daily version of the same problem. Shipping older stock first sounds simple until three warehouses, two vans and a promotion get involved.

How lot tracking works in Business Central

Business Central lets you assign serial numbers, lot numbers and package numbers on inbound and outbound documents. Once posted, the tracking details sit on the related item ledger entries (Microsoft Learn). That ledger history is what makes tracing possible later.

Building blockWhat it does
Item tracking codeDefines whether an item uses serial, lot or package numbers, and when numbers must be recorded
Expiration rulesTrack when specific lots or serial numbers expire
Item tracking linesCapture lot numbers, expiration and warranty dates on purchase, sales, production and transfer documents
Item Tracing pageFollows a lot backwards to its origin or forwards to every use
Find EntriesLists every current record that holds a traced lot or serial number

Sources: Microsoft Learn: set up item tracking, Microsoft Learn: trace item-tracked items.

For large receipts, users can fill tracking lines through Edit in Excel, including columns for serial number, lot number, package number, expiration date and warranty date, then publish them back to Business Central (Microsoft Learn).

Running a recall: the three traces

Microsoft’s own walkthrough describes three tasks a quality controller performs during a defect investigation (Microsoft Learn):

  1. Usage to origin. Start from a customer complaint or returned unit and trace back to the supplier lot and purchase receipt.
  2. Origin to usage. Start from the suspect supplier lot and trace forward to every production output, transfer and sales shipment that used it.
  3. Current stock. Use Find Entries to list every record that still holds the lot, so you can block and quarantine it.

On the Item Tracing page, you trace forwards and backwards through posted inventory transactions for that serial or lot number (Microsoft Learn). One caution from Microsoft: only applied transactions are shown, so if the same lot was received on several transactions, the page may not show all of them. Clean posting discipline makes your traces complete.

Expiry control with FEFO picking

First-Expired-First-Out (FEFO) makes sure the items with the earliest expiration dates are picked first (Microsoft Learn). In Business Central, FEFO works when:

  • The item’s tracking code has lot, serial or package warehouse tracking switched on
  • Stock was posted with an expiration date
  • The location has Require Pick and Pick According to FEFO turned on, plus Bin Mandatory for warehouse picks

When those conditions are met, tracked items in picks and movements are sorted oldest expiry first. If two lots share an expiry date, Business Central picks the one with the lowest lot number (Microsoft Learn).

There is also a hard stop. With Strict Expiration Posting selected on the item tracking code, only items that have not expired are included in the pick (Microsoft Learn). For pharma companies, that setting is a core reason to run a pharma ERP on Business Central: it stops an expired lot from leaving the warehouse by mistake.

Getting the setup right

Traceability is only as good as the data captured at each step. A practical rollout looks like this:

  1. Choose which items need tracking. Track lots for anything perishable, regulated or high value. Not every packaging item needs it.
  2. Design tracking codes. Decide whether numbers are required on receipt, on production output, on shipment, or on all three.
  3. Capture lots at receipt. The purchase order is often the central document, since tracking from the moment goods arrive gives a complete history (Microsoft Learn).
  4. Use handheld scanning in the warehouse. Typing lot numbers by hand is where most errors start.
  5. Run a mock recall every quarter. Pick a real lot, trace it both ways and time how long it takes.

Microsoft also offers a free learning path on serial and lot numbers covering setup, inbound and outbound tracking, adjustments and tracing (Microsoft Learn training). It is a useful onboarding resource for warehouse and quality staff.

Frequently asked questions

Is lot tracking included in standard Business Central?

Yes. Item tracking with serial, lot and package numbers is part of standard inventory functionality.

Can I trace lots through production?

Yes. Lot numbers can be assigned to production and assembly output, so traces follow raw materials into finished goods. That makes Business Central a practical ERP for manufacturing companies, not only distributors.

What is the difference between FIFO and FEFO?

FIFO ships the oldest received stock first. FEFO ships the stock that expires first, which matters when shelf lives differ between batches.

How long should a recall trace take?

Aim for minutes. A quarterly mock recall shows where your data has gaps.

CODERS implements Business Central for food, pharmaceutical and FMCG businesses in Lebanon and Ghana, alongside industry solutions such as Pharma365, our pharma ERP, and Distribution360. Ask us for a traceability review.

Sources