Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

WMS does not reserve according to FEFO

Posted on by 45

It was noticed that when releasing the load to the Warehouse (i.e. create sales work and its replenishment), the system does not look at the location where the oldest batch(s) is found, instead looks at the nearest location containing on hand and allocates it as the picking location for the replenishment work. Although all the setup made for FEFO batch reservation is made and checked on numerous times.

P.S. Standard reservation hierarchy and reservation at the location level is done once I release to Warehouse.

I made all revisions on the setup made for FEFO reservation with no hope. I even tried to investigate if this problem persists on CU10 (our current version).

Can someone help? Did anybody encountered this issue before?

I can email the word document I made upon request.

*This post is locked for comments

  • WMS does not reserve according to FEFO
    Hello Isalm,
     
    Can you please tell us what changes you made in the query? we are having same problem but in d365.

    I hope your solution might resolve this problem with d365 as well. 
     
    Thanks, 
  • Suggested answer
    Heart Jammer Profile Picture
    Heart Jammer 10 on at
    RE: WMS does not reserve according to FEFO

    Please Check Inventory Model Group, Physical Negative Checkbox is Marked or Not, if Marked than unchecked it.

  • Islam Ayman Emam Profile Picture
    Islam Ayman Emam 45 on at
    RE: WMS does not reserve according to FEFO

    Thank you all for your help and sorry for replying all late. Solved the issue with the query and closed the case with them. I identified to my customers the problem and the workaround.

  • Verified answer
    Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: WMS does not reserve according to FEFO

    Hi Islam,

    'FEFO Batch Reservation' is not supported as a strategy on the Location directive of type 'Replenishment'. If you want, you can vote up this Idea to have this functionality added:

    ideas.dynamics.com/.../ID0002633

    Thanks for the document. It is excellent. I think you would get the behaviour you want if you it the 'Edit query' button (on the Location Directive Action for your 'Pick' replenishment location directive) and set some sorting on one of the Batch date fields. If you already tried, I am interested to hear why the 'workaround' is not suitable, if you have time to share.

    Alternatively, you might be able to do away with Replenishments altogether (to get your inventory from the warehouse locations to the loading dock). You could use Sales order work with two Pick/Put pairs on the Work tempalte (and a different Work class for each pair). In this way, you could use the 'FEFO batch reservation' logic on the Sales order location directive to find your storing locations.

  • Verified answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: WMS does not reserve according to FEFO

    read guy's comment and the white paper.

    With batch below you still have some options so I think the answer you got was misinformed.

    In the location directive on the location directive action -  mark the line as batch enabled, and then select strategy = FEFO batch reservation.

    When work is generated, Ax will determine which batches to pick and guide the work user to pick from those locations. The initial work will be created exactly based on FEFO, but the work user will also be able to when necessary to pick a different batch number (potentially from another location).

    You also have a setting on the mobile device menu item to Force the user to pick oldest batch from a location.

    Alternatively organize your locations in a way that you don't have batches with different expiration dates (there's a setting about mixing batches on the warehouse management parameters for this).

    Batch below sorting: Set up the location directive action query to sort based on expiration date. This way, it will suggest you the location with the oldest batch.

    For true FEFO this requires that you organize your locations correctly, and  do not allow mixed batches. .

    The down-side of using batch below is that some of the features like same batch reservation, batch attributes and customer sellable days do not apply when it comes to batch below.

  • Islam Ayman Emam Profile Picture
    Islam Ayman Emam 45 on at
    RE: WMS does not reserve according to FEFO

    After opening up a case with Microsoft, they stated that the FEFO reservation is not supported on R3 CU10 (and don't know for the newer CUs). And she gave me @Fatih solution as a "workaround". So I set the Batch expiration date sorted in Ascending order. However, neither me or the Customer is settling for this workaround.

    Thanks my friends.

  • Islam Ayman Emam Profile Picture
    Islam Ayman Emam 45 on at
    RE: WMS does not reserve according to FEFO

    Here is the DL link

    https://we.tl/Q5D1D3MqkA

  • Islam Ayman Emam Profile Picture
    Islam Ayman Emam 45 on at
    RE: WMS does not reserve according to FEFO

    Hi Fatih,

    Not at all, but on R3 CU 10 that does not happen

  • Islam Ayman Emam Profile Picture
    Islam Ayman Emam 45 on at
    RE: WMS does not reserve according to FEFO

    Hi Guy,

    Sorry for replying late, will do so.

  • fatihgork Profile Picture
    fatihgork 3,815 on at
    RE: WMS does not reserve according to FEFO

    Hi,

    I have tried this in my 365 environment as below: 

    • Created 2 batches with same expiration date of their BatchID: 2018-02-28 and 2018-03-31.
    • Created inventory of 10 pieces for BatchID 03-31 in both in Location1 and Location2.
    • Created inventory of 10 pieces for BatchID 02-28 in Location3.

    When I set strategy to None, in location directive action, work is created against Location1.

    When it is set to "FEFO batch reservation" then, application selects Location3.

    Am I missing some setup of yours? It seems to be working fine in my environment. Do you have any sorting or additional criteria in your location directive actions query?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans