The current change tracking mechanism in Dynamics 365 Finance & Operations, particularly the use of DELETE triggers across hundreds of tables, has proven to be a bottleneck in scenarios involving high-volume deletions, such as the Master Planning (MRP) operations. These triggers, designed to log deletions for synchronization purposes, cause significant blocking in the source F&O environment when multiple triggers fire simultaneously.

To address this, we propose an architectural enhancement that allows for non-blocking, asynchronous deletion tracking.

This change would significantly improve system stability and performance during planning cycles, enabling business users to maintain operational efficiency without compromising data synchronization. Given the strategic importance of MRP and similar workloads, we believe this optimization is essential to ensure Dynamics 365 can scale effectively with enterprise-level decision-making processes.