web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Automatic item lot number sales order

(0) ShareShare
ReportReport
Posted on by 67

Hello everyone,

 

My client will use lot tracking in the future. That is why I have enabled item tracking for the items.

 

My location setup is the following: (They only have 1 location)

pastedimage1607700077697v1.png

pastedimage1607700100736v2.png

My Item tracing code:

pastedimage1607700154849v3.png

pastedimage1607700170000v4.png

When I enter a sales order I can select the lot numbers at the item tracking lines by selecting entries.

pastedimage1607700386835v5.png

But this is the problem! My customer does not want to sellect the correct lot number for every line / item.

They want this to be automatically selected. 

So they don't have to assign it themselves.

Is this possible? And how do I do this?

Or should this be programmed?

I hope someone can help me.

Thanks in advance.

 

Kind regards Melissa

I have the same question (0)
  • Community Member Profile Picture
    on at

    Melissa,

    Out-of-the-Box auto-application of the Lot Number is not possible. Even if I use Reservations, the Lot Number is not auto-reserved and selected. The Warehouse or Shipper has to record the Lot Number pulled from the shelf/bin. Now this does not mean you cannot add this functionality by talking to your Partner. If you are doing Warehouse Shipment/Picking then I would leave this blank and let the Warehouse process input the value. Without knowing the exact reason you want to pre-enter the Lot number before picking and shipping, if you need this talk to your Partner.  Also, not sure if you use Expiration Date processing, which could play into this as well for available selection.

    Hope this answers your question, but if you want to chat more feel free to email me steven.chinsky@wipfli.com

    Thanks and Stay Safe,

    Steve

  • Tymay Profile Picture
    297 on at

    Hi, would like to follow up on this post as i do have customer who also require the lot number to be auto assigned based on expiry date FEFO. They cannot allow warehouse to auto assign as the warehouse may not be able to easily identify the FEFO option. Is there a way we can have this automated in Business Central Sales Order processing? If standard out of the box is not available, are there any 3rd party add on App that has this feature or how easy can we customize this option?

    Hope to get advise from all expert out there.

    Thanks

    May

  • Community member Profile Picture
    2 on at
    Hi, I would like to follow up as well and see if anyone can make any suggestions on how to accomplish this.  We also have a requirement in D365 BC to automatically select the lot numbers for a client when they create a Sales Order.  We are going to start working on programming this however wondering if anyone was able to accomplish this and if they would share any success they had.  
    Thank you, 
    Judy DeLello
    judy@isisupport.com

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,117 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,026 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans