All insights
GrowBusiness CentralHow-To Guide

Lot and serial tracking setup in Business Central (make the system enforce it)

Set up lot and serial number tracking in Business Central and configure it so the system blocks a post when tracking is missing, plus how to require expiration dates and run a full trace.

Wired CIOJune 17, 2026
The short version
  • Build a reusable item tracking code and turn on inbound, outbound, and assembly requirements.
  • Enforcement only counts if a post with no tracking is actually blocked; test that, do not assume it.
  • Require manual expiration-date entry (or an expiration calculation formula) for items with shelf life.
  • Use Item Tracing to follow a lot from receipt through assembly to shipment.
Bottom line: Tracking is only worth setting up if the system refuses to let a post through without it, so prove the block before you trust it.

Traceability only counts if it's complete. If your team can post a receipt or a shipment without entering the lot number, the one time they skip it is the time a customer calls about a bad batch and you can't tell where it went. This guide sets up lot and serial number tracking in Business Central, Microsoft's enterprise resource planning (ERP) system for small and mid-sized businesses, and, more importantly, configures it so the system refuses to let a transaction post without the tracking. By the end you'll have an item tracking code that's mandatory on purchase receipt, sales shipment, and assembly, optional expiration-date handling, and the ability to trace a lot from the day it arrived to the day it shipped.

Lot and serial tracking flow STEP 1 Create item tracking code STEP 2 Require at receipt & shipment STEP 5 Block post if missing STEP 6 Trace a lot end to end
Set it up, require it, enforce the block, then trace.

Before you start

  • You need permission to edit inventory setup and item cards, typically an admin or SUPER permission set.
  • Decide per item: do you need serial numbers (one unique number per single unit, for high-value or warranty items) or lot numbers (one number for a batch, for consumables, food, chemicals)? Some items need both.
  • Test this in a sandbox or test company first. Turning on mandatory tracking changes how every transaction for that item behaves.

Step 1: Create an item tracking code

The item tracking code is the reusable policy you'll attach to items. Build it once, attach it many times.

  1. Choose the search icon, type Item Tracking Codes, and open the page.
  2. Choose New. Give it a Code like LOTALL or SERIALALL and a Description.
  3. You'll see FastTabs for Serial No., Lot No., and Package. You'll configure the relevant one(s) in the next steps.

Step 2: Make lot or serial mandatory through the whole flow

This is the part that turns a suggestion into a rule. On the Lot No. FastTab (or Serial No. FastTab), turn on tracking at each point you care about.

  1. Set Lot Specific Tracking (or SN Specific Tracking) to Yes if you need to follow a specific lot or serial across its whole life. This is what makes a real trace possible.
  2. Turn on the inbound requirement: set Lot Purchase Inbound Tracking (and similarly the receipt-side options) so a lot must be entered when goods are received.
  3. Turn on the outbound requirement: set Lot Sales Outbound Tracking so a lot must be entered when goods ship.
  4. Turn on the same for any other flows you use, including transfers and assembly, so there's no side door where an item moves without a number.

Step 3: Require expiration dates (for items that expire)

If you handle food, pharma, chemicals, or anything with a shelf life, make the expiration date mandatory so it's captured when inventory is created.

  1. On the Lot No. FastTab of the item tracking code, turn on Man. Expir. Date Entry Reqd. (require manual expiration-date entry) so a date must be entered when you make a positive inventory adjustment, a purchase receipt, or a production/assembly output.
  2. If you want Business Central to calculate the expiration date instead, set an Expiration Calculation formula on the item card so the date auto-fills from the receipt date.

Step 4: Attach the tracking code to the item

  1. Search for Items, open the item you want to track, and find the Item Tracking Code field (on the Item Tracking FastTab).
  2. Set it to the code you built (LOTALL, SERIALALL, etc.).
  3. If you want Business Central to assign numbers for you, set the Serial Nos. or Lot Nos. field to a number series so new lots/serials get a number automatically instead of being keyed by hand.

Step 5: Confirm enforcement actually blocks a post

This is the test that matters. Do it before you trust the setup.

  1. Create a Purchase Order for the tracked item and try to Post the receipt without opening item tracking.
  2. Business Central should stop you with a message that item tracking is required and the assigned quantity doesn't match. That error is the control working.
  3. Open Item Tracking Lines (from the line, choose Lines, then Item Tracking Lines, or the Item Tracking action), enter the lot or serial number, confirm the quantity matches, and post again. It should go through.
A green light proves nothing

If a post goes through with no tracking entered, enforcement isn't on for that flow. Go back to the item tracking code and confirm the inbound/outbound/assembly toggles are set, then re-test. A green light on the first try means nothing; a blocked post you then clear is real proof.

Step 6: Run a full trace

The payoff. When you need to answer "where did this lot come from and where did it go," Business Central can show the whole chain.

  1. Search for Item Tracing and open it.
  2. Set the Trace Method (for example, Usage to follow a lot forward to where it shipped, or Origin to trace back to where it came from).
  3. Enter the Lot No. or Serial No., set any date filters, and choose Trace.
  4. The result shows each entry the lot touched, receipt, transfer, assembly, shipment, so you can see exactly which customers got units from a given batch.

Verify it

Receive a lot, assemble or ship it, then run Item Tracing on that lot number. You should see the full path from receipt to shipment. Separately, confirm that an attempted post with no tracking is blocked on a purchase receipt, a sales shipment, and an assembly output. If any of the three slips through, fix the corresponding toggle on the item tracking code.

What to do next

Roll the tracking code out to the rest of your tracked items, ideally in a batch with the Dimensions-Multiple style bulk approach where available, or one at a time for a small catalog. Decide whether to track everything or only the items where traceability genuinely matters, since mandatory tracking does add a step at every receipt and shipment. If you want help deciding which items to track, mapping it to a recall or audit requirement, or training the warehouse team, that's exactly the kind of setup we walk through with you.

Filed under
How-To Guide
Read more insights
Free strategy session

See where you stand. Then move forward.

Book a free intro call. We'll talk through where you are today and map a strategic plan for growth, protection, automation, and alignment.

A 30-minute discovery call, no obligationA full team of specialists at a fraction of in-house costA clear next step before you spend a dollar
Loading scheduler…