Disassociate a CRM Record

If you have a lookup field on a record in CRM that you want cleared so it is blank you can use this process. SmartConnect will utilize the CRM SDK to remove the link between the two records.


In this example I am going to remove the primary contact from an Account record. As part of the process you will need to have the unique identifier (GUID) from both records. I have setup my data source as a CRM query to give me both guids. If your source does not have the guids already, you can use an entity lookup in your destination to find them.

In the destination, you will select the parent entity, in my case that is Account. Then check the box for ‘Include advanced messages’. This will add several new nodes to be mapped. The one we are interested in is ‘Account – Disassociate Record’

Related Entities: An entity lookup or entity reference to the child entity record that you no longer want.

Relationship: A relationship additional column. This defines which relationship is being removed and will be selected from the parent entity.

Target: An entity lookup or entity reference to the parent containing the lookup field.

If you have any further questions, feel free to contact our support team at


Global Variables in
SmartConnect Setup for Office 365 E-Mail with TLS
Excel data sources work intermittently or give blank error message.
How to set up automatic payments on eOne's website portal
"Info 1625. This installation is forbidden by system policy", when attempting to install the SmartConnect Excel Add-In


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site
Shortcuts Template for Extender



open all | close all


Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce scripting SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartView SQL Support Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.