Within item coverage, one can easily specify multiple warehouses to transfer material from one warehouse. For example multiple stores transferring material from one DC. However, there is a need in some industries that have material stored in many warehouses, to look into each of those warehouses for available material, before suggesting a planned purchase order. In other words, one company looking at multiple DC's for material to transfer.
Comments
I have had this requirement from clients before. I could see this working quite nicely and think it would need to be enabled with one of a few methods for the system to determine how to select when there are multiple warehouses. These are the first ones that came to mind as I considered this;
- A preset allocation, similar to the new source from multiple vendors rule, where you can say pull X% from here and Y% from there on an ongoing basis.
- Add a priority field where the system tries to go through allowable warehouses based on priority and selects the first one where the quantity can be satisfied. If it cannot be satisfied from on hand, it defaults to the highest priority warehouse.
- System choses based on FEFO, wherever the oldest inventory is, that is where it plans the transfer. This would be the most complex, but really useful to process manufacturers in food & bev, life sciences, etc. The primary complication here (though somewhat of an edge case) is that you could possibly need to pull from multiple warehouses if there isn't enough stock to fulfill the demand at the warehouse with the oldest inventory. It would require additional logic I presume to split the planned transfer and may need to "fall back" on methods 1 or 2 to determine planning when there is no inventory at all.
Category: Planning
Beatriz Nebot Gracia (administrator) on 4/5/2024 11:26:23 AM
Thanks for your input! If it gets voted, we will consider adding it to our long term roadmap.
Sincerely,
Beatriz Nebot Gracia
Senior Product Manager, Microsoft