Views:

Applies to Product - Dynamics 365 Supply Chain Management

What’s happening?
Customers are experiencing performance issues when loading transfer order forms on mobile devices and while running inventory transaction consolidation jobs. The performance degradation is often attributed to duplicated work IDs in query previews and inefficient delete statements during the consolidation process.


Reason:

  • The performance issue when loading the transfer order form is caused by duplicated work IDs in the query preview.
  • The inventory transaction consolidation job is negatively impacted by an expensive DELETE query when processing a large number of records, leading to slow performance.
     
Resolution:
  1. For the transfer order form loading issue:
  2. Investigate and address the presence of duplicated work IDs in the query preview.
  3. Consider testing in a clean environment to determine if the issue persists without custom code.
  4. For the inventory transaction consolidation job:
  5. It is recommended to pause the archive process if it is causing performance issues.
  6. The product team has raised a bug for the DELETE query performance issue, which is being addressed in version 10.0.42. Customers should monitor updates and apply the fix once available.
  7. Customers are advised to limit the number of records processed in a single DELETE statement to improve performance, potentially by using a TOP condition to restrict the number of records affected.
  8. If the issue persists after applying the above steps, customers should reach out for further assistance and provide detailed information regarding the performance issues encountered.