Auto-resolve Common Data Service conflicts

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
End users, automatically Aug 2020 Oct 2020

Business value

Data conflicts can easily occur when business applications exchange data on an ongoing basis. For example, someone might delete or change a record in one of the applications, or both. When resolving conflicts manually, users typically follow business rules that determine what to do. Business Central can now apply those rules automatically, allowing users to focus on more important tasks.

Feature details

Integration table mappings now include rules that control how synchronization jobs synchronize records in Business Central tables with entities in Common Data Service. On the Integration Table Mapping page, in the Resolve Deletion Conflicts and Resolve Update Conflicts columns, you can specify how Business Central will resolve conflicts that occur because records were deleted in tables in one or the other business application, or updated in both.

In the Resolve Deletion Conflicts column you can choose to have Business Central automatically restore deleted records, remove the coupling between the records, or do nothing. If you do nothing, you must manually resolve conflicts.

In the Resolve Update Conflicts column you can choose to have Business Central automatically send a data update to the integration table when sending data to Common Data Service, or to get a data update from the integration table when getting data from Common Data Service, or do nothing. If you do nothing, you must manually resolve conflicts.

After you specify the strategy, on the Coupled Data Synchronization Errors page you can choose the Retry all action to automatically resolve conflicts.

Integration Table Mapping page showing Resolve Deletion and Resolve Update Conflicts columns

Coupled Data Synchronization Errors page showing new Retry All action

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

Thank you for your idea

Thank you for submitting this idea. We listened to your idea, along with comments and votes, to help us decide what to add to our product roadmap.