Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Issues with FEFO and s...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Issues with FEFO and stock reservation

(0) ShareShare
ReportReport
Posted on by simariani 2

Hello Community,

we are facing some issues with the FEFO batch reservation combined with the Batch Above reservation hierarchy.
We have configured the batch-tracked items in our system with the following features:
- Item model group with the flag FEFO date-controlled enabled
- Reservation hierarchy /BatchAbove/, with the batch above location

With the previous configuration, we are facing two main issues:
1) The system is reserving batches in the inbound location (still not put-away yet) and for this reason we are having many Replenishment work with blank picking location
2) When a worker performs a short pick, both using automatic or manual reallocation, the system is not able to propose a new location with the same item but a different batch

We were trying to find an alternative solution to fix these issues. We have created a new Reservation hierarchy /BatchBelow/, which has the batch dimension under the Location.
Thanks to this reservation hierarchy, we should be able to solve both the issues, but we are losing the FEFO logic: the system is indeed allocating locations where we have a batch that expires after then another stored in a different location.

We have tried to use the location directive action strategies /FEFO batch reservation/ or /Round up to the full LP and FEFO batch/ but it still seems to allocate a non-FEFO batch.

Do you have any suggestion on how to get around these issues?
Are we correctly using the setups?

Thanks and Regards,

Simone

  • simariani Profile Picture
    simariani 2 on at
    Issues with FEFO and stock reservation
     
    many thanks for your suggestions.
    Unfortunately, even if we exclude the Inbound location from location directives, it stills reserve the batch from there with Batch Above hierarchy, thus leaving the picking location for replenishment as blank.
    Anyway, we are trying to proceed with Batch Below in order to avoid this issue, and for the items that are not batch-tracked, we will suggest the "unavailable" stock status + the stock status change batch job.
     
     
    We are still facing issues with FEFO and Replenishment: the location directive strategy "FEFO batch reservation" is not working for Replenishment picking directives, even if I create a sorting on batch expiry date as you have suggested. Could you clarify better on how you created this sorting (e.g. which table you have used in the Joins, how you set up the sorting)?
     
    I've also found this Idea on "FEFO batch reservation" for Replenishment that was posted on 2017:
    https://experience.dynamics.com/ideas/idea/?ideaid=91b35519-b293-e711-80c0-00155d7cd0b4#
    but from my experience, the strategy seems not working.
     
    Thanks again for your help.
    Simone
  • Community member Profile Picture
    Community member 2 on at
    Issues with FEFO and stock reservation
    Agree with the suggestions Colby have made.
     
    In addition to the reservation suggestion I would advise to check whether you might want to update the inventory status upon receipt to for instance unavailable (possible via mobile device config). After the putaway towards the storage locations have been performed you can subsequently run the change inventory status batch job to update the status to available. By means of this you will prevent the system will see the stock in your receiving location as available/reservable. Besides this you of course also need to ensure you specify the correct location queries via your location directives. 
  • Suggested answer
    ColbyGallagher Profile Picture
    ColbyGallagher 3,664 on at
    Issues with FEFO and stock reservation
    Hi Simone, 
     
      For #1, your location directives for sales picking need to exclude the inbound locations.  For #2 with batch above, it will not reallocate to a different batch.  
     
    For your other scenario of batch below reservation hierarchy, on your location directive action query that has FEFO strategy, set your sorting on batch expiry date.  
     
    Colby

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

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans