Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Lot Number
Small and medium business | Business Central, N...
Suggested answer

Lot Number

(1) ShareShare
ReportReport
Posted on by CU07101338-0 112
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
  • Alexander Drogin Profile Picture
    Alexander Drogin 62 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 4,996 Super User 2024 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

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,587 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,614 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans