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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.