Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Dataverse -> BC Integration

(0) ShareShare
ReportReport
Posted on by 15

Hello to All,

I have setup the integration between D365 Sales and Business Central successfully.  Creation and updates of accounts is working fine between the two systems however when i deactivate an account in D365 Sales this does not update the Customer in Business Central.  I am using the OOTB functionality.  

I was just wondering what should happen to teh Customer record through the integration when we deactivate/reactivate an account in D365 Sales.

Please accept my apologies if i have posted this on the wrong forum.

Look forward to hearing from you all. 

Kind Regards

Gurnek

  • Suggested answer
    Greg Enns Profile Picture
    Greg Enns 1,102 on at
    RE: Dataverse -> BC Integration

    First thing you need to decide is what you want the system to do in BC with an Inactive account. The only OOB method is the Blocked field as Marco mentioned. Set this to "Blocked::All" and you essentially block any documents from being posted against the Customer.

    Then to make the integration do this, you'll need to do some customization on either the D365 Sales side or the BC side.

    Customize the BC Side:  You can write code to subscribe to an event during the sync process and then if the account is inactive, mark the Customer as blocked.

    OR

    Customize the Sales Side: You could create an option field called "Blocked" in the Account table with values that match the BC side. Use a Workflow to update this field during any Status changes. Then in the BC Field Mapping, map this new field to the BC "Blocked" field.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Dataverse -> BC Integration

    Hello,

    Is there a way to deactivate a customer in Dynamics 365 Business Central apart from setting the status to Blocked. I assume you do not want to synch inactive customers to Dynamics 365 Business Central. Out of the box it will synch via full synchronization. But you can maybe setup a filtering:

    community.dynamics.com/.../757150

    Thanks.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans