Posts Tagged ‘CRM’

Datetime field in SmartConnect different than in Dynamics 365 Sales/CRM

How to resolve the datetime field in SmartConnect displaying a different value than in the  Dynamics 365 Sales/CRM User Interface.CauseSmartConnect uses the D365 web services to pull your data source. The web services return datetime fields exactly as they are stored in the D365 SQL tables. There are four ways datetime fields are stored.User Local:…

[Read More]

Dynamics 365 Sales Notes and Attachments

Dynamics 365 Sales/CRM allow notes to include attachments. SmartConnect can import and export many different file types that are used with notes. Below I’ll go into detail about the steps required to use different file types with CRM notes.CRM notes are stored in the entity “Annotation”. You will be required to give your note a…

[Read More]

How to delete a record from Dynamics 365 Sales

SmartConnect makes deleting records from Dynamics 365/CRM simple.1. create a map with a data source containing all records to be deleted.2. Map a unique identifier. We generally recommend using an entity lookup as your mapping, and setting the grouping on the lookup.3. Check the box in the top right “For Delete”*You cannot do create/update with…

[Read More]

SmartConnect Compatibility with the Latest Dynamics 365/CRM Online Update

Microsoft released an announcement earlier this month that there is a mandatory update for all of their customers who are on Dynamics 365/CRM Online v8.1. Read the full announcement here.This update will occur on or before July 31, 2018, and customers will be updated to the latest version of Dynamics 365 which is 9.0.2.SmartConnect users…

[Read More]

Entity doesn’t contain attribute with Name = ‘eones_customeraddress_trackingid’

When trying to setup a changes only map on the CRM customeraddress entity you will receive the following error message.‘eones_ch_customeraddress’ entity doesn’t contain attribute with Name = ‘eones_customeraddress_trackingid’.CauseThe Address entity does not allow lookups to it, other than the ones available “out of the box”. When the SmartConnect plug-in creates the custom tracking entity to…

[Read More]

Plugin processing Failed : The given key was not preset in the dictionary

Receiving the following error in CRM/D365 Sales ‘System Jobs’Plugin processing Failed : The given key was not preset in the dictionaryThere are two known causes for this error.Blank Primary FieldThis error message can occur when the record that the change plugin was triggered on does not have a value in the primary field.SmartConnect change tracking…

[Read More]

Metadata contains a reference that cannot be resolved

The full error message is:Metadata contains a reference that cannot be resolved: ‘’Microsoft changed CRM to use TLS 1.2 starting with the release of version 9. SmartConnect has been updated to use TLS 1.2 as of version of If you are on version, and still receiving this error, then the registry will need…

[Read More]

Microsoft Dynamics 365 Sales – Dynamics GP Integration using SmartConnect

Microsoft Dynamics 365 Sales – Dynamics GP Integration is one of the most popular scenarios we see for customers using SmartConnect. Oftentimes we are asked whether eOne offers pre-configured integration templates. The good news is that yes, we do offer great starting points for integrations between Microsoft Dynamics 365 Sales (CRM) and Dynamics GP. The…

[Read More]

Using IP address in the SmartConnect web service URL

If you are connecting to a sandbox environment of CRM you can’t use an IP in the web address. You need to have a named server that is resolvable via DNS resolution.  Don’t use: is a link to Microsoft’s article about using a web address with CRM.

[Read More]

Using Restrictions in the CRM Query Builder

The CRM query builder won’t allow you to do everything you can do in SQL, but you can get close.Here are some of the common issues encountered when creating a CRM Query.How do I say not equal to, ‘<>’ will not work?This is correct, the CRM FetchXML won’t accept  <>. It will accept !=  so…

[Read More]


Failed to connect to the CRM server : Failed to get CRM Organizations : Access is denied
Connection could not be validated when using Excel data source
Assigning Default Dimensions
Failed to create record.: Property "Editable" for Ship-to Address is invalid!
WinSCP.SessionRemoteException: Network error: Connection to XXXX refused


Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
Manufacturing Serial Trace SmartList Builder Template
SSL Security error using OLEDB Connection
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



open all | close all


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