Suggested by Felix Franzbach – New
In different projects we are facing the requirement to pick items based on the receipt date without using batch tracked items or license plate controlled locations. An example for this could look like this:
Receipts:
Receipt of 5 pieces of item A on 11.03.2025 and put away to location 1
Receipt of 3 pieces of item A on 14.04.2025 and put away to location 1
Receipt of 10 pieces of item A on 05.04.2025 and put away to location 2
On-hand:
Location 1 8 pieces with "location-item aging date" 11.03.2025
Location 2 10 pieces with "location-item aging date" 05.04.2025
The on-hand (item on a location) should always contain the date and timestamp from the oldest / first receipt.
In addition to this further location directive action strategies would be required, similar to the already exisiting fifo/lifo picking strategies.
Why are the current functionalites for aging date based picking not sufficient?
Batch tracked items:
If a customer wants all of the inventory to be managed with this kind of receipt dates it would be required to have every single item batch tracked. This would lead to a high effort in every warehouse related process (batch confirmation, batch information registration during receiving etc.)
License plate tracking with aging dates:
This would require a single license plate for each item with a different receipt date and license plate tracking on every single location. Some of our customers are not tracking license plates on their picking locations at all.
Location aging dates:
This would require a lot of physical space in the warehouse since every receipt would need to be put to an empty location to be able to track the aging date per item per location.
Recently we even had one project where the decision was made to use an external wms over D365 wms based on the functionality to have receipt dates per item per location.
Obviously this will not guarantee to have the correct inventory to be picked physically since this will always be decided by the warehouse worker, but it would still be feature that would give some flexibility when it comes to managing inventory based on receipt dates and create work for the locations with the oldest inventory.