As the value in the “Available Qty To Move” column on the Inventory Part in Stock screen increases, we are seeing a noticeable performance hit. We have a few inventory parts that regularly get reserved out to thousands of orders. This appears to create a significant performance hit as IFS attempts to sum up the value for the Available Qty To Move. This appears to be populated from Inv_Part_Stock_Reservation_API.Get_Available_Qty_To_Move, and potentially from the Shop_Material_Assign_Res view underneath that. Are there any plans for optimizing or improving the performance related to this field (and the underlying queries it’s making.) We currently have specific part numbers that it is taking 70 seconds to return results for.
Userlevel 6
+13
Performance drops can be due to many contributing factors. If your current level of UPD is significantly lower than the recent level of UPD 22, it's advisable to acquire the latest UPD. It may prove beneficial.
However as you explained, if this impacts the business regularly and critically, consider raising a support ticket to Unified Support for further assistance and investigations.
Hope this helps !
Userlevel 6
+20
As the value in the “Available Qty To Move” column on the Inventory Part in Stock screen increases, we are seeing a noticeable performance hit. We have a few inventory parts that regularly get reserved out to thousands of orders. This appears to create a significant performance hit as IFS attempts to sum up the value for the Available Qty To Move. This appears to be populated from Inv_Part_Stock_Reservation_API.Get_Available_Qty_To_Move, and potentially from the Shop_Material_Assign_Res view underneath that. Are there any plans for optimizing or improving the performance related to this field (and the underlying queries it’s making.) We currently have specific part numbers that it is taking 70 seconds to return results for.
Available Qty To Move is a custom field, correct?
+2
Available Qty To Move is a custom field, correct?
I do not believe so.
Userlevel 6
+13
Available Qty To Move is a standard column connected to method Inv_Part_Stock_Reservation_API.Get_Available_Qty_To_Move
It is not a custom field.
Userlevel 6
+20
Available Qty To Move is a standard column connected to method Inv_Part_Stock_Reservation_API.Get_Available_Qty_To_Move
It is not a custom field.
But it is not a field one can make visible via Column Chooser as it is not in the list of available columns.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.