Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Dynamics Connector Does Not Handle Null Strings and Dates Correctly For Dynamics CRM and Dynamics GP Adapters

Dynamics Connector Does Not Handle Null Strings and Dates Correctly For Dynamics CRM and Dynamics GP Adapters

View products that this article applies to.

Symptoms

When you use the Microsoft Dynamics Connector with the Dynamics CRM and Dynamics GP adapters you experience that nullified values in Dynamics CRM for integrated records will result in the value not being nullified in Dynamics GP.

↑ Back to the top

Cause

The following default maps do not contain logic to handle nullified values

  • Microsoft Dynamics CRM Account to Microsoft Dynamics GP Customer (Account to Customer)
  • Microsoft Dynamics CRM Contact to Microsoft Dynamics GP Customer (Contact to Customer)
 In Microsoft Dynamics CRM a nullified value will not be provided when requesting data through the Microsoft Dynamics CRM Web Services. Since no value is provided for a mapped field, this in turn results in null value being passed to Microsoft Dynamics GP. Microsoft Dynamics GP treats null as not provided so the associated field in Microsoft Dynamics GP will not be changed.

↑ Back to the top

Resolution

In order to resolve this problem you must update the affected maps. You must update each mapped string and datetime field so that it handles the scenario where a mapped field no longer contains data in CRM. This can be accomplished by introducing a function in the mapped field. The format of the function would look like the following if the field in question in CRM was All Addresses\Customer Address\Line 3. For other string fields, you would simply replace the defined field name with your field name.

=If(IsDefaultValue(All Addresses\Customer Address\Line 3),"", All Addresses\Customer Address\Line 3)


For datetime fields the format would look like the following

=If(IsDefaultValue(Some Date Field), Date(1900, 1, 1), Some Date Field)




↑ Back to the top

More Information

This problem is being considered for resolution in a future release of the Microsoft Dynamics Connector.

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2562687
Revision : 1
Created on : 1/7/2017
Published on : 6/11/2012
Exists online : False
Views : 194