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: ‘https://yourinstance.api.crm.dynamics.com/XRMServices/2011/Organization.svc?wsdl&sdkversion=9’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 20.18.0.9. If you are on version 20.18.0.9, 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:http://216.3.128.12:5557/SmartConnect.svc/Use:http://eone.com:5557/SmartConnect.svc/Here is a link to Microsoft’s article about using a web address with CRM. https://msdn.microsoft.com/en-us/library/gg334752.aspx

[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]

RECENT POSTS


Business Central error- Key "XXX" is not well formed! - when trying to delete a record
SalesForce update map returning the message ‘No record was found to update.’
Connecting to the Microsoft Dynamics 365 Business Central Odata Web Services
How to add Company ID or Company Name to a SmartList report.
HTTP Error 403.14 - Forbidden when browsing the SmartConnect web client

POPULAR POSTS


Manufacturing Serial Trace SmartList Builder Template
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
The server process could not be started because the configured identity is incorrect.
How to update SmartConnect from 10.0.0.51 to SmartConnect 2014
Running a map in SmartConnect and receiving an error that says "The source was not found, but some or all event logs could not be searched."

CATEGORIES

ARCHIVES

open all | close all

TAGS

CRM Demo Dynamics Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration integration manager Meet the Team Microsoft Microsoft dynamics crm Microsoft Dynamics GP MSDYNGP Office Relationships partners release SalesForce SalesForce.com scripting SmartConnect SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk