Standard inventory management module does not support inventory status field property. It comes with WMS module's feature. Inventory status functionality is the best option for one of our clients' requirement. However, to activate this functionality we had to activate advanced warehouse management processes. As a result, we end up with having millions of inventdimids which we actually have no problem with. The issue's origin is WHSINVENTRESERVE. Since Microsoft, @Glen Turnbull, mentioned before that when there are more than 500 thousand records in this table, performance would dramatically decrease. This happened exactly. We are having really hard time expressing this issue to our client: Why having tens of millions of records in InventDim, InventTrans are no problem, but having more than 500 thousand records in that table will put a really serious pressure on environment's performance.
So that, we would like to use Invent Status functionality but, we are looking for a solution to use it without activating advanced warehouse management functionalities. For performance issues.
Comments
Hello, we have the same issue on one of our current project.
The goal is synchronize the ERP with the external WMS and having the Available/Not available on-hand feature. It improves a lot the way to be able to reserve/sell only available on-hand.
Category: Inventory
Hi, I would need the inventory status available without the WHS, as well.
Thanks
Category: Inventory
They made a clean-up job for that exact issue... Deleting currently unused dimensions. The simple warehouse solution would be to use other warehouses (like quarantine or another feature specific).
Category: Inventory
Administrator on 5/28/2019 11:06:14 AM
Thank you for your feedback. We need some more details to understand your suggestion better. Can you please help us by answering the following questions?
Currently to use the ‘Inventory status’ dimension an item must be enabled with a storage dimension group having the “Use warehouse management processes” = Yes.
Is the only concern by doing this related to the number of records in the InventDim table?
Is the ask to not use other entities to control the reservation?
What kind of processes related to the Inventory status dimension is needed?
Sincerely,
Per Lykke Lynnerup
PM, Microsoft