Time Zones with the Scribe Insight CRM Adapter

Written By: Tyler Sand

from May 15, 2013

With the Scribe Adapter for Dynamics CRM, there is a feature that allows you to customize the time zone that should be used when migrating and integrating date/time fields. This feature is found within the Owner/User tab of the Adapter for Microsoft Dynamics CRM settings window, in the section labeled as Time zone to use for all date/time values.  The possible values for this setting are Time Zone of Run As User, Time Zone of Login User, and UTC/GMT.  If this value is not set correctly, it can result in date/time fields having incorrect values.  This is also just as applicable to date-only fields since CRM stores those just the same in the backend SQL database.  For example, if you have this value set to UTC/GMT and migrate a date of 5/9/2013, which is assumed to have a time of 00:00:00, into a date-only field and your users have a time zone of (GMT -06:00) Central Time (US & Canada), then it will appear as 5/8/2013 to those users within CRM since its value in the database is 5/8/2013 18:00:00.  It is very important to make sure that the time zone of the Run As or Login User is set properly before starting to migrate or integrate any data or this will cause similar problems.

When a new target connection is created to CRM, this setting defaults to Time Zone of Login User.  I have found that with the most current version of the Microsoft Dynamics GP to Microsoft Dynamics CRM integration template at the time of this writing (5.0) the default value on the target connections to CRM is UTC/GMT, which unless changed, will result in incorrect values unless the customer happens to live in London or another city within the GMT time zone.

To change or check this setting, follow these steps:

  1. Open the properties of the CRM target connection
  2. Navigate to the Connection tab
  3. Click the Adapter Settings… button
  4. Navigate to the User/Owner tab
  5. Verify and adjust the Time zone to use for all date/time values setting as necessary