🚀 CRM ↔ ERP Real-Time Integration Framework

By

 

🚀 CRM ↔ ERP Real-Time Integration Framework


Sharing a simple and reliable pattern to implement bi-directional synchronization between Microsoft Dynamics CRM and an ERP system using Azure Service Bus.




CRM ↔ ERP architecture diagram



Note: This approach is majorly for integrating dynamics CRM with non-Microsoft ERP system as we have OOB dual write approach to integrate with Microsoft ERP system.


✅ CRM → ERP

  • Whenever a real CRM user updates an Account or Contact, a plugin sends the change as a JSON payload to Azure Service Bus.
  • A corresponding Integration Log entry is also created in CRM, capturing the status, source, and payload.
  • The ERP system reads the message, updates its records, and then calls Dynamics via API to mark the Integration Log entry as Success.


✅ ERP → CRM

  • Any time the ERP updates an Account or Contact, it pushes a JSON payload to the ERP-CRM queue.
  • Dynamics picks up the message, creates Integration Log record with a Pending status, updates the CRM record, and then marks the Integration Log as Success.


✅ Preventing Infinite Loops


To avoid circular updates, both systems check who made the change.

If the update originates from the integration user, the system does not send the message to the queue ensuring a clean, loop-free sync. this is because, integration user will be the user used in azure functions to update CRM-ERP bidirectional updates



Comments

Post a Comment

Popular posts from this blog

Accessing Fields on QuickView Form through javaScript

By
QuickView form is template to view information about related entity record within a form for another entity record. Sometimes you need to access data from QuickView form for performing business logic. In order to get QuickView form in js you can use following syntax :  Syntax :  formContext.ui.quickForms.get(arg); Following is the example how you can access field from QuickView Form :  getAttributeValueFromQuickViewForm: function(executionContext) { var formContext = executionContext.getFormContext(); var quickViewControl = formContext.ui.quickForms.get("quickFormName"); if (quickViewControl != undefined) { if (quickViewControl.isLoaded()) { //not necessary to use this condition quickViewControl.getControl("new_name").getAttribute().setValue("Abhishek Dhandare"); //to get value used below syntax quickViewControl.getControl("new_type").getAttribute().getValue(); //perform your ...
Read more

Custom Subgrid Using HTML Web resource

By
Sometimes you will get requirement to show records in subgrid without any proper relationship. In such scenario you can go with custom subgrid and show all those related records in HTML table that won't be possible with OOB way of ms crm Below is the sample code for HTML web resource for creating sample custom subgrid Here we are showing all accounts in Case entity where matching criteria is Case Number = Account number(that too without any relationship between Case and account) html><head><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta><meta...
Read more

Check Dirty Fields or Forms in Dynamics 365

By
 In Dynamics 365, sometimes there is requirement to check if field value/form is changed or not. In that case we can use getIsDirty Client API reference which will return value true if field or form value is changed. Syntax: formContext.data.entitygetIsDirty();   //Form is dirty formContext.data.entity.attributes.get(arg).getIsDirty();  //field is Dirty To get the list of attributes that have been modified in this session, you can check the IsDirty of the attribute :  getListOfDirtyAttributesOnForm: function(executionContext) { var formContext = executionContext.getFormContext(); var AccountAttribute = formContext.data.entity.attributes.get(); if (AccountAttribute != null) { for (var i in AccountAttribute) { if (AccountAttribute[i].getIsDirty()) { listOfAttributes += AccountAttribute[0].getName() + ", "; } } } }
Read more