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

Hotfix released for Microsoft Dynamics AX 2012 R3 that will allow changes to person name and sales order lines to be tracked with SQL change tracking

A hotfix has been released for Dynamics AX 2012 R3 that resolves the issue of changes to customer or contact names not forcing a synchronization to occur within Connector for Microsoft Dynamics.  This hotfix will also now allow changes to sales order lines to be tracked and force an update to occur within Connector.  The…

5

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

Lessons learned from a Partner when upgrading Connector for Microsoft Dynamics MSDI database

The MSDI database that Connector for Microsoft Dynamics uses for storing information about integrations is intended to be used ONLY for Connector for Microsoft Dynamics.  Recently I was working with a partner who was experiencing some issues when upgrading to the latest version of Connector for Microsoft Dynamics.  The partner was receiving error messages similar to the…

3

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

New feature in Connector for Microsoft Dynamics V3 CU2 allows for limited updating of Contact Info View items in Microsoft Dynamics AX 2012

The new field, “Allow Contact Info View Updates” is used to enable updates to existing Contact Info View items.  After generating Microsoft Dynamics AX 2012 object config files, this field will show up in any Complex Types that contain a ContactInfoView field.  Leveraging this new field will allow you to update your Contact Info View…

2

Upgrading to Microsoft Dynamics CRM 2013? Here's what you need to know if you are using Connector for Microsoft Dynamics

If you are scheduled to be upgraded to Microsoft Dynamics CRM 2013 online or are planning on upgrading your on-premises deployments once the upgrade is available there are a few things to take note of if you are using Connector for Microsoft Dynamics. Supported Microsoft Dynamics CRM solution Only version 1.0.1603.3 of the Connector solution…

10