Microsoft Dynamics AX 2012 R3 Exchange rates not syncing properly

If you are troubleshooting why the exchange rates from Dynamics AX 2012 R3 are not syncing properly into Microsoft Dynamics CRM using Connector for Microsoft Dynamics, here is something for you to take a look at. In Dynamics AX 2012 the query that is used by the Connector’s AX 2012 adapter to retrieve the exchange…

0

Preserving leading zeroes in numerical constant value mappings

If you need to map a numerical value to a constant value and that constant value has leading zeroes, those zeroes will be parsed off.  For example, if want to map a numerical field to a constant value of 00000000115 and you enter a constant value in the mapping wizard, the transformation logic will truncate the leading…

0

Connector for Microsoft Dynamics configuration settings that can be used to control some of the default behaviors for logging and retries

There are some configuration settings that can be added or changed in the ConnectorServiceHost.exe.config to update default behavior with respect to retries and log cleanup; they are as follows:  Config Setting Behavior Remarks  HousekeepingCleanupLogs True: The Housekeeping task should run CleanupLog.proc.sql and CleanupRetryTask.proc.sql False: The Housekeeping task will run only run CleanupTaskDeletionTracking.proc.sql (not recommended) Caution: Log…

12

Refresh of Connector for Microsoft Dynamics V3 CU 3 version now available

It has been brought to our attention that in certain cases, the Connector for Microsoft Dynamics service may not re-start integration tasks properly after the Microsoft SQL Server hosting the MSDI database has been taken offline and then brought back online. Installing the refreshed version of Connector for Microsoft Dynamics V3 CU 3 (3.3.1007.1) will…

5

Connector for Microsoft Dynamics V3 CU 3 released

Better support for Microsoft Dynamics CRM 2013 SP 1 (6.1) and Microsoft Dynamics NAV 2013 multi-tenant deployments are the primary new features in Connector for Microsoft Dynamics V3 CU3 (3.3.514.1) which was posted today, June 18th 2014. Additional new features with this release include: Support for Microsoft Dynamics CRM 2013 SP 1, which requires the updated Microsoft Dynamics CRM…

18

Connector for Microsoft Dynamics solutions failing to upload to new Microsoft Dynamics CRM 2013 organizations after applying SP 1

Update 2 It has been brought to our attention that there could a be a situation in which the updated Connector for Microsoft Dynamics solutions will still fail to import into Microsoft Dynamics CRM 2013 SP 1.  If you have upgraded to Dynamics CRM 2013 SP1 RU 1 prior to importing the updated Connector for…

6

Connector for Microsoft Dynamics V3 released today

Connector for Microsoft Dynamics V3 (3.0.217.1) released today!  This release includes a major update to the MSDI database and Connector for Microsoft Dynamics service, designed to improve efficiency of the service as well as making it easier for customers and developers to interact with it. This release also addresses some of the key suggestions that…

18

Customizing a Microsoft Dynamics AX 2012 and Microsoft Dynamics CRM 2011 Integration

If you need to expose a custom table in Microsoft Dynamics AX 2012 for integration to a custom entity in Microsoft Dynamics CRM 2011, then this post is for you!  Let’s say that you will be creating a custom entity in Microsoft Dynamics CRM 2011 and that entity really doesn’t integrate to one of the…

37

Avoiding possible duplicate addresses in Microsoft Dynamics CRM 2011 when integrating with Microsoft Dynamics AX 2012

With the current mappings for addresses between Microsoft Dynamics CRM 2011 and Microsoft Dynamics AX 2012 there is a possibility that you can get duplicate addresses in Microsoft Dynamics CRM 2011 if the address originated in Microsoft Dynamics CRM 2011.  This is due to how we currently process address updates in the Microsoft Dynamics CRM…

0

Integrating Microsoft Dynamics GP Sales Order and Invoice serials / lots into Microsoft Dynamics CRM Order / Invoice lines

Integrating serial and lot numbers between Dynamics GP and Dynamics CRM can be valuable if you need visibility into the serial numbers or lots associated to a sales document line within Microsoft Dynamics CRM.    By default Serials / lots that are associated to Microsoft Dynamics GP Sales order or Invoice lines are NOT integrated…

4