2

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.

Category: Inventory
STATUS DETAILS
Needs Votes
Ideas Administrator

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

Comments

O

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

O

Hi, I would need the inventory status available without the WHS, as well.
Thanks

Category: Inventory

O

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