Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Performances hotfixes for the new Warehouse Management module

Several partners and customers have raised support requests related to performances of the new WMS module. In addition to this, some code defects have been logged and addressed by Development.

In the past months, several fixes and enhancements related to WHS performances were developed and released; these hotfixes were included in latest cumulative updates (CU9, CU10).

A list of some of the available hotfixes is provided below, with KB number and link to download them from Lifecycle Services.

Table 1 – Sample list of WHS performances fixes

Title

KB number

Link to download the hotfix from LCS

Performance problem when opening Physical On Hand Inventory form in WMS

3034785

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3034786&bugId=3249169&qc=9e48d82e31b9cbbbae33c128a06c237b4775374f0fea02252d64edfa62e96969
WHS Replenishment performance- Address regression from 3393286

3051622

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3051622&bugId=3612779&qc=e32d5b83a806e8af11a9119de7979c8fc85ceeb943068449c27ef10111695799
WHS Replenishment performance

3051622

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3051622&bugId=3612779&qc=e32d5b83a806e8af11a9119de7979c8fc85ceeb943068449c27ef10111695799
Performance gain in Load Planning Workbench

3062188

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3062188&bugId=3611246&qc=77455aeea2d5ba94c0e35dfb49b9e31de731a89398c9a35971265c93ee1f979c
Improve performance of ship confirm for loads for entire transfer orders

3019832

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3019832&bugId=3189842&qc=91db24b1ea8b8fe2e83d0bdb2ef33c6b63587277ad77766aef9b7aa94f02f2eb
Improve performance of manual work completion for work created by located license plate

3019834

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3019834&bugId=3189840&qc=b7320cc6511def68231f874521310f1a0bc2c2ebb394b8321363b1cee27a243d
Perf: Load planning workbench is unusable on a system with any latency

2988304

https://fix.lcs.dynamics.com/Issue/Resolved?kb=2988304&bugId=1711093&qc=89612992cff54c9ca46a96332687db66384e0c72a25dbcf6d0023bb8f9494f4f
Improve the performance of the Release to warehouse process for larger order scenarios

3020975

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3020975&bugId=3209569&qc=88cc084d1b480cd7c035f63b7c6016b38149dacd147f6ab219f9ac18c3e56e38
Performance: Cannot run with more than 7-8 WMDP sessions – WMDP service client objects require explicit recycling

3010993

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3010993&bugId=2892401&qc=24b1f39b2de9945ce6d1a00051081348fd39a1b036b1b4564d298c1c4ce2b0b6
Performance problem when opening On Hand By Location form in WMS

3034786

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3034786&bugId=3249169&qc=9e48d82e31b9cbbbae33c128a06c237b4775374f0fea02252d64edfa62e96969
Performance of the location stocking limit check can be improved by optimizing the stocking limit retreival logic and unit of measure conversion logic

3072510

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3072510&bugId=3638492&qc=ad0f29b1cf3d6f898aaa14dd03d81f398d1bc0b1b39bba67b4f7cfd3da2c0122
Perf: The pack operation should be improved by avoiding client/server calls and utilizing the Financial Lite update which was done for Work

3073529

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3073529&bugId=3638991&qc=932dba5b4ed557d9058ecb898a81ed416263794653e8d080e6f13b50bf787170
Intermittent performance issue with Inventory onhand inquiry for AX2012 R3 with queries in sp_WHSOnHand stored procedure

3073717

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3073717&bugId=3611313&qc=5c18fd97190bac6452dd28dd25c9a49c89bb643fdf06bb0f42a803dec1d03591
InventSum and WHSInventReserve clean up

3063513

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3063513&bugId=3601375&qc=6fb02c3461d1ef56a53eca07567a63daa0e27b122bc30c5cb884f76ecadd5ad6
Load Planning Workbench has performance problems, takes too long to load

3051069

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3051069&bugId=3231430&qc=6fb35610e343d00532f7e9fd37db78b4015110bd5e2f8d3aebb82870afa32fc5
Perf: Containerization process can be improved 50%

3073177

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3073177&bugId=3637360&qc=8ce0709fc285b26f9d95258dd706bec091ccafffbe3a4e38c0e6c77ebf85a9d0
perf: WHSWorkCreateHistory table has incorrect setting of clustered index which leads to very expensive queries during processing of larger waves with many allocation errors

3071893

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3071893&bugId=3638496&qc=cb30d9a00ab8e406ba49b802fd34e900509df5c4f639ae83718110a9d09ffbb1
Perf: We should not track WMSLocationLoad records on WHS location since they cannot be used and the maximums cannot be configured.

3074073

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3074073&bugId=3643913&qc=fe61aa98c92702c647b9ec484c4a5a9b683151a55365e26c8d476217956fe33a
perf: The number of full locations that fit the location directive query should not affect the time it takes to find a putaway location when using Volumetrics

3073602

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3073602&bugId=3638553&qc=cd6483285548fa40d82b1cf4512a7b2245e623611a663245381cd958412fc195
Perf – Work creation (after the allocation step) Optimization – avoid re-evaluation of empty locations

3104480

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3104480&bugId=3679983&qc=1616a755c0d38452521750f1852e05dde7da817231d5203f9274343b088e4826
Perf – Work creation (after the allocation step) Optimization

3099718

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3099718&bugId=3671768&qc=641c41b8e94ec1682dbff0b6b32a8f7178ea783167702f459abe5a22604ebda6
perf: Min/Max replenishment can be optimized with +20 % by avoiding to do laborstandards calculations for each work one by one but for all the works created as part of the replenishment

3073600

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3073600&bugId=3673156&qc=b1f56f8204851eb275c895df8688c5b0094c3e55af14f6e51204927b029a9023
Performance improvement for KB3073717

3112873

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3112873&bugId=3691967&qc=f23b52f1b34c5e60ed2b68c9a614bd815311067b829d1dafd5e9c44d8d8eb28f

 

Comments and tips

Depending on the situation, you may choose one of the following options:

  • Download a specific hotfix individually if an issue has been reported in the environment
  • Upgrade to the latest CU
  • Create a package of hotfixes via the Update Installer in LCS.