web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Lot Number
Small and medium business | Business Central, N...
Answered

Lot Number

(2) ShareShare
ReportReport
Posted on by CU07101338-0 254
Hello everyone!

I hope you are going well!

I've set up Lot Numbers as shown in the image below. My goal is to use these Lot Numbers in both production and sales orders. In the production order, I've successfully assigned a Lot Number to the production order line. However, when I try to select the same Lot Number in a sales order, it doesn't appear in the list of available options.

Interestingly, if I manually enter the Lot Number, the expiration date is retrieved correctly.


What could be causing this issue? 

I would appreciate if you could help me!
thanks in advance!

 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Verified answer
    Alexander Drogin Profile Picture
    Alexander Drogin 262 on at
    Lot Number
    Is this item available on the same location which is selected in the sales line? And in the same variant if variants are used. Manual entry of the tracking number does not validate the availability by location and variant, just picks the first item ledger entry with the same lot no. and pulls the expiration date from it.
    "Select Entries" action, on the other hand, is based on reservation entries and filters the table on the location and variant, and also on the reservation status.
     
    If the location is correct and the item is available, I would check the reservation status for this lot. Does the item use reservation or planning (for example, the production order was created from planning worksheet)?
    Since item tracking, reservations, and inventory planning use the same table to track items for different purposes, this results in messed up reservation entries sometimes.
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 6,142 Super User 2025 Season 2 on at
    Lot Number
    Before you start using that Lot Tracking Code, you need to enable "Lot Specific Tracking".  Without that option checked the system will apply FIFO usage and your inventory will not consume from the Lot No you selected during consumption/shipping.  This means your inventory will reflect available Lots that have already been consumed.  This may be what you are experiencing.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,899 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,444

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,304

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans