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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Issues with FEFO and stock reservation

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Suggested answer
    ColbyGallagher Profile Picture
    3,668 on at
    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
  • CU27040937-1 Profile Picture
    2 on at
    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. 
  • simariani Profile Picture
    2 on at
     
    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

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 139 Super User 2026 Season 1

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 110 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 92 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans