Skip to content
+1-888-319-3663

EONE BLOG

GUID’s and CRM,


If you are a CRM consultant you already understand all about GUIDS. If you are a GP consultant then GUID’s may be a mystery.

In Dynamics CRM all entity records are tracked by a unique identifier called a GUID. For GP folk this is very similar to the concept of a GL account number and an account index. To reference an account number in the GP tables you often need to know the index. This concept is fundamental to CRM, and pervasive across the product.

What this menas is that if you were to try and write data directly into the CRM tables you need to pass in the GUID’s into the table. The problem with this is that no source data file will contain GUID’s as they not something end users will know about or understand.

SmartConnect resolves this issue by providing the concept of an entity lookup. The entity lookup is defined during the building of a map and says “for each value in this field, go and lookup CRM to find the GUID, then pass the GUID value into the integration rather than the actual entity record. So whether you are dealing with a standard entity or a custom entity you can always use the entity lookup.

This is another way in which SmartConnect makes integrating CRM and GP easy for all consultants.

Leave a Comment





RECENT POSTS


Happy Thanksgiving from eOne! - US Office Closed November 25 & 26
Popdock: What is your Locale?
Q4 2021 Partner All Hands Call - Recording Now Available
An Announcement regarding SmartList Builder and SmartView from eOne Solutions
Join us for the Q4 2021 Partner All Hands Call!

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central 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 SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.