Dynamics Community Forum Thread Details

Raw material picking using Location ageing FIFO directive strategy

Hello,

Our requirement is to pick raw materials for production using the FIFO location directive strategy.

Background:
- Current stock costing model is FIFO
- D365 FO installed version is 10.0.33
- All stores locations are license plate controlled
- Production input location is not license plate controlled
- Location status and date are enabled on the locations being tested
- Raw materials are not batch or serial controlled
- In testing, the location directive strategy is set to /Location ageing FIFO/. The work order type is Raw material picking:

- Each action has a basic query to limit the locations that can be included.

Problem:

In testing, I have selected an item that has stock in 2 separate locations; each with a different license plate.

However, when creating warehouse work for a works order with this item on the BOM, the location with the oldest license plate is not selected for picking first. Instead the first location (alphabetically sorted) is used.
I've tried simplifying the test by removing the query and limiting to one action but the outcome is the same.

The documentation suggests that the LP ageing date is used in the strategy and in absence of a LP, the location date is used:

/When inventory is first received or created in the warehouse, the system updates the relevant license plate so that the current date is shown as the aging date. This date is then used by the location directive strategies to identify the oldest or newest inventory in the warehouse. If inventory is moved to a location that isn't tracked by license plate, the location itself is updated with aging information, and this information will then be used by the strategies./

Location directive inventory picking aging - Supply Chain Management | Dynamics 365 | Microsoft Learn

The test scenarios in the article are sales order picking. I was wondering if anyone has got this working for raw material picking for production? If yes, do you have any ideas of what I might be missing?

Thanks for your support!

Quick Links

Leaderboard