Small and medium business | Business Central, N...

Lot no. & Expiration date not populating in warehouse pick in business central.

(7) Share

Report

Posted on by Test user

289

Hi guys,

Lot no. & Expiration date not populating automatically on warehouse pick lines.

when we create pick from warehouse shipment,on that time lot no & expiration date not allocated automatically.

On location we already enable the fifo expiration date boolean, but still facing query.

Our sandbox is in 26.5 version.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (5)

Report

If it's not populating automatically it can mean one of two things: something wrong with your set up, or the item is not available to be picked.

Regarding the setup, can you post screenshots of your location card and item tracking code?

Regarding the item being available to be picked, are you using bins? If so go to the bin content page and check the qty. available to pick field for your lot no. If you're not using bins, check if this lot no. is already added on other documents or journal lines.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,395 Super User 2025 Season 2 on at

Like (4)

Report

Hi, Hopefully, the following discussion will give you some hints.

https://community.dynamics.com/forums/thread/details/?threadid=1af628c8-5ae1-4a74-b644-b9a3a5242ff2

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,378 Super User 2025 Season 2 on at

Like (4)

Report

Hope this helps: https://www.dynamicsuser.net/t/lot-no-expiration-date-in-warehouse/14128

https://learn.microsoft.com/en-us/answers/questions/1326542/business-central-lot-no-info-screen-expiration-dat

https://www.dynamicsuser.net/t/lot-no-expiration-date-in-picking/14136

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 5,789 on at

Like (2)

Report

Hello,

Lot and expiration dates won’t auto-fill unless FEFO and item tracking are fully set up. Check that:

The item tracking code has lot + expiration enabled.

The location has “Pick According to FEFO” on.

Items were received with expiration dates.

Otherwise, you must assign lots manually.

Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

If Lot No. and Expiration Date are not auto-populating on warehouse pick lines in Business Central 26.5, despite enabling FIFO and expiration tracking at the location level, it's likely due to missing or misconfigured item tracking settings, unavailable or blocked lot quantities in bins, or potential customizations interfering with standard behavior.

Ensure the item tracking code requires lot and expiration tracking, the correct lot is available in the expected bin, and that the location setup includes Directed Put-away and Pick with FIFO logic.

If all settings are correct, test in a clean environment to rule out custom code or consider checking for version-specific issues.

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (2)

Report
Hi,

This is a pretty common issue when working with warehouse picks in BC, especially if you're using lot tracking and expiration dates. Even if FIFO is turned on for the location, the system won’t auto-fill lot numbers unless a few things are set up correctly.

Here’s what to check:

Item Tracking Setup

Go to the item’s tracking code and make sure:

Lot Specific Tracking is turned on

Expiration Date Tracking is enabled

Warehouse Tracking is set to Pick

Location Setup

On the Location Card, confirm:

Directed Put-away and Pick is enabled

Use Expiration Dates is turned on

FIFO is selected as the pick method

Warehouse Pick Behavior

When you create a pick from a warehouse shipment, the system looks for inventory with valid lot numbers.

If the inventory is expired, blocked, or doesn’t match the filters, the pick lines will be blank.

You can manually assign lot numbers or use the Assign Lot Numbers function if it’s available.

Bin Contents

Check the Bin Contents page to make sure there’s inventory with valid lot numbers and expiration dates.

If the bins don’t have eligible items, the system won’t auto-fill anything.

Custom Code or Extensions

If you’ve got any customizations that change how picks work, they might be interfering.

Review any custom codeunits or page extensions that touch warehouse picks.

Helpful Reference
Design Details – Warehouse Entries – Microsoft Learn
Set Up Item Tracking – Microsoft Learn

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

2 people found this reply helpful.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,217 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.

The Complete Guide to Lot Numbers

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,148 on at

Like (3)

Report

Hi,

Have you confirmed that the Item Tracking Code for the item requires Lot No. and Expiration Date, and that these values were assigned during receipt or before creating the pick? Also, are you using the Whse. Item Tracking page to verify tracking lines before pick creation?

Thanks

Rishabh

Was this reply helpful? Yes No
Suggested answer

Gregory Mavrogeorgis 763 on at

Like (2)

Report
Hi,

Totally—this is almost always a setup alignment issue. Turning on FEFO at the Location isn’t enough by itself.
Quick checklist (most common miss is #1):

Item Tracking Code (for the item):

Lot Specific Tracking = ✔️

Lot Warehouse Tracking = ✔️ (required for lots to be assigned on warehouse docs)

Use Expiration Dates = ✔️

Location:

Directed Put-away and Pick = ✔️

Require Pick + Bin Mandatory = ✔️

Pick According to FEFO = ✔️

Inventory on hand: In the same Location/bin, with Lot No. + Expiration filled, not blocked, Allow Pick = ✔️

Source doc behavior: Don’t pre-assign item tracking/reservations on the Warehouse Shipment if you want auto-allocation. Create the pick via Warehouse Shipment → Actions → Create Pick (not Inventory Pick).

Fast sanity test: On the Warehouse Shipment line, open Item Tracking Lines → Select Entries. If FEFO suggests a lot there, but the Create Pick didn’t fill it, your Lot Warehouse Tracking is likely off.
Workarounds (today):

Preselect lots on the Warehouse Shipment (Select Entries), then Create Pick—the pick inherits them.

Tiny extension: on pick creation, call the standard FEFO selector to auto-assign.

If you can share the item’s Item Tracking Code settings and the Location card toggles, I’ll pinpoint exactly which switch is blocking the auto Lot/Expiration on your picks.

If you found this helpful please mark it as verifed

Was this reply helpful? Yes No