Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Need Issue Items on LO...
Small and medium business | Business Central, N...
Suggested answer

Need Issue Items on LOT by Expiration Date not Old LOT Creation

(2) ShareShare
ReportReport
Posted on by CU11010701-1 10
Dear All
We are going to deploy LOT tracking with expiration date in some items.
But I face an issue that if I need system automaticly detuct quantities from lots on posting (for example on production time) , system will take old lot that was created instead of lot with oldest expiry date.
Any setup can do to take lot with oldest expiry date (not need manual selection).
 
Thanks
Categories:
Dynamics 365 Business Central
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 6,798 Moderator on at
    Need Issue Items on LOT by Expiration Date not Old LOT Creation
  • Alexander Drogin Profile Picture
    Alexander Drogin 170 on at
    Need Issue Items on LOT by Expiration Date not Old LOT Creation
    I think the key point here is what exactly you mean by "by default system take the oldest lot".
    So you open the consumption journal and add lot numbers in the Item Tracking Lines page. Is this correct? In this page, you should see the list of lots sorted by the expiration date.
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 1,702 Super User 2024 Season 2 on at
    Need Issue Items on LOT by Expiration Date not Old LOT Creation
    Hello,
     
     
    "Pick According to FEFO" can be turned on when the location is using advanced warehouse with Directed Put-away and Pick.
     
    The best bet is to sort the expiration date when selecting the lot no.
  • CU11010701-1 Profile Picture
    CU11010701-1 10 on at
    Need Issue Items on LOT by Expiration Date not Old LOT Creation
    Also
    Need to mention I didn't use Bin on my location
    Thanks
  • CU11010701-1 Profile Picture
    CU11010701-1 10 on at
    Need Issue Items on LOT by Expiration Date not Old LOT Creation
    Hello All
    Thanks for your reply.
    My case actually related to food and bevarage process.
    I defined one item as menu item (defined as recipe on item card) and another 2 items as ingredient.
    In recipe list I added that 2 ingredient items to the menu item with (explode at posting as BOM method).
    In posting and when tracking ingredient items by lot with expiration, by default system take oldest lot no by creation not by expiration.
    Need to take lot by expiration instead of creation.
    Thanks
  • gdrenteria Profile Picture
    gdrenteria 13,235 Most Valuable Professional on at
    Need Issue Items on LOT by Expiration Date not Old LOT Creation

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

    FEFO picking in Business Central

    Best Regards
    Gerardo

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,388 Super User 2024 Season 2 on at
    Need Issue Items on LOT by Expiration Date not Old LOT Creation
    The system will only do that if you use FEFO, more information here - How to enable picking by FEFO - Business Central | Microsoft Learn. But I agree with Alexander, I think we need more details on your process.
     
  • Suggested answer
    Alexander Drogin Profile Picture
    Alexander Drogin 170 on at
    Need Issue Items on LOT by Expiration Date not Old LOT Creation
    Can you share the steps you follow to consume the item? I understand it is a component in a production BOM?
    If the item is consumed from a simple location that does not require picking, then you will be requested to enter the lot No. either in the components list, or in the production journal when posting the consumption. Either way, it is a semi-manual task, and Item Tracking Lines -> Select Entries prioritizes lots by the expiration date suggesting the oldest ones first.
     
    If picking is required for the location, then oldest lots can be picked fully automatically, but this requires advanced warehouse functionality (location with directed put-aways and picks enabled). In a location card you can enable the "Pick according to FEFO" option in this case.
  • CU26091412-0 Profile Picture
    CU26091412-0 4 on at
    Need Issue Items on LOT by Expiration Date not Old LOT Creation
    To address the issue of tracking items by expiration date rather than by the creation date of the lot, you can follow these steps to ensure that your inventory management system or process is aligned with your needs. Here’s a structured approach to help you manage this effectively:
  • CU11010701-1 Profile Picture
    CU11010701-1 10 on at
    Need Issue Items on LOT by Expiration Date not Old LOT Creation
    Thanks Mr. Khushbu Rajvi.  for your reply
    Actually I defined all required setup and it working normally (Lot & Expiry).
    But my issue now need to take old expiry on any consumption process (for Examble, in food and beverage, I detuct ingrediant of items on posting time put this by default will take the oldest lot number regarding to creation date not expiry date).
    I need use old expiry date on default consuption process.
    Thanks

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! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans