Skip to main content

Notifications

Announcements

No record found.

Business Central forum

Deleting Coupling for Deleted Records

Posted on by 407

Hi, 

We deleted some customers in Business Central which were coupled to Account records in Dynamics CRM. When we run the sync to try to reimport the Accounts, we get an error saying the sync failed because the Account records are coupled to records which have been deleted in Business Central. 

Is there a way to delete the coupling in bulk? We can see from the "Accounts - Dynamics 365 for Sales" list (5341) that the records are still "coupled". Is there a table which stores this?

Thanks!

Stephen

Categories:
  • VVlasov Profile Picture
    VVlasov 10 on at
    RE: Deleting Coupling for Deleted Records

    Hello Ivan,

    Thank you for the answer.

    Is there any way to load more than 100 records in the "Synchronisation Error" page as the records I am working with are around 35,000.

    Regards,

    Vasil

  • Lissa Profile Picture
    Lissa 120 on at
    RE: Deleting Coupling for Deleted Records

    Hello Ivan,

    I am also facing the same issue. I am trying to couple and sync Customer records from BC to CE. I have deleted duplicates records in CE and trying to couple again but getting the same error message. As you suggested above, I have checked in Skipped records but didn't see any customers records.

    Could you please help how can i can i delete bulk couples records and couple them again with CE.

    Thanks much in advance.

  • Fabfab Profile Picture
    Fabfab 85 on at
    RE: Deleting Coupling for Deleted Records

    Thank you for your clarification.

    Regards, 

  • Stephen Pryke Profile Picture
    Stephen Pryke 407 on at
    RE: Deleting Coupling for Deleted Records

    No - if you delete a record in one system it doesn't get deleted in the other. This was exactly the cause of the problem we had.

    We deleted customers in BC and couldn't sync again because the record in CRM still existed and still thought it was connected to this deleted record.

    The solution Ivan suggested is a way to remove (delete) this connection, so we're left with just the record in CRM and we could sync again.

  • Fabfab Profile Picture
    Fabfab 85 on at
    RE: Deleting Coupling for Deleted Records

    Hi,

    does the deletion actually happen in both services?

    I mean if a delete a customer in Business Central that is coupled with an account in Sales, the deletion will have effect in both places ?

    Thank you very much.

    Regards,

    .fd

  • Stephen Pryke Profile Picture
    Stephen Pryke 407 on at
    RE: Deleting Coupling for Deleted Records

    Thanks. Looks like exactly what we need!

  • Verified answer
    ikoletic Profile Picture
    ikoletic 2,202 on at
    RE: Deleting Coupling for Deleted Records

    Hi Stephen,

    Simply search for Coupled Data Synchronization Errors page or open D365 Sales Connection Setup-> Synchronization-> Skipped records and there you'll find full list of records that are skipped due to conflicts, records coupled/deleted. 

    You can select multiple by record type (table) and for example sort by error message and select one of resolution options either removing coupling, restoring records, synchronize one way or another. 

    Let me know if there are any other questions.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans