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…


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…


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…


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…


Sorting in Microsoft Dynamics AX 2009 AxdItem and AxdInventoryOnhand data sources can effect paging in the Microsoft Dynamics AX 2009 adapter

Paging is implemented in the Microsoft Dynamics AX 2009 adapter and relies on the AIF services to return the keys to the Items to be integrated in ascending order by ItemID.  If the AIF services that the Item to Product map relies on do not sort the returned item keys in the proper order, you…


Connector for Microsoft Dynamics V3 Refresh available

Connector for Microsoft Dynamics V3 (3.0.430.1) refresh is available.  This refresh addresses some issues that you may have encountered with the initial release of Connector for Microsoft Dynamics V3. Refresh Highlights: This refresh addresses the issue of custom fields not being available for mapping on existing maps after the configuration utilities have been run against…


Microsoft Dynamics AX and Microsoft Dynamics CRM integration case study published

Needing to be able to grow and change, Heritage Bag, a leading manufacturer of institutional/industrial trash bags and can liners, decided to replace its homegrown business management system with an end-to-end ERP system and chose Microsoft Dynamics AX. Years later, the company then deployed Microsoft Dynamics CRM to tackle additional requirements and integrated the two…


Restricting Access for Integrations to Microsoft Dynamics CRM Online Using the Non-Interactive Access Level

A partner has posted a fantastic article on restricting access to Microsoft Dynamics CRM online using non-interactive access levels.  The entire post can be read here:


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…


Relive Convergence 2013 Content on Connector —Online!

If you attended Convergence and are looking for refreshers on the Connector content, be sure to check out “Convergence 2013 – Online!” From this site, you’ll e able to view content from Convergence breakout sessions, keynotes, general sessions, concurrents and deep dives sessions. The  ‘My Convergence’ site will be available for 12 months following the…