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

Mapping the full product name from Microsoft Dynamics AX to Microsoft Dynamics CRM

A new post has been authored on the Dynamics AX support blog on mapping the full product name from Dynamics AX into Dynamics CRM using Connector for Microsoft Dynamics. The description of the post is as follows: This blog post comes from a question in the Microsoft Dynamics AX community board at https://community.dynamics.com/ax/f/33/t/120425.aspx. The question was…

0

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…

38

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

Updated Mappings for Microsoft Dynamics NAV and Microsoft Dynamics AX in Connector for Microsoft Dynamics RU 2

Several of you have asked what changed in the Microsoft Dynamics NAV and Microsoft Dynamics AX maps in RU2.  They were updated to take advantage of new functions that were created which allow for much better support of Microsoft Dynamics CRM duplicate detection rules.  If you do not want to delete and re-import maps in…

3

Mapping Microsoft Dynamics NAV OptionStrings and Microsoft Dynamics CRM OptionSets

Have you found yourself needing to map custom OptionString fields from Dynamics NAV into custom OptionSets in Dynamics CRM?  And have you found that if you have blank or unassigned values in either system that this can be difficult to do?  If so, then this post is intended to help you out.  One of our…

6

Enabling Additional Fields in the Microsoft Dynamics GP Web Service for use with Connector for Microsoft Dynamics

At Convergence 2012, a customer came to the Connector for Microsoft Dynamics booth asking how they could map Microsoft Dynamics GP 2010 Sales Tracking Numbers into CRM 2011 using Connector for Microsoft Dynamics, since these number were not exposed by default on the Sales Order to Order map.  I was not at the booth at that…

8

Changing the Default Behavior of a Connector Integration

This post is intended to show you how to use Connector for Microsoft Dynamics to change a business rule based on a business example. It uses Dynamics GP 2010 integrated to Dynamics CRM 2011, however the basic concepts apply across Dynamics ERP’s. When creating the default maps for any integration, the maps in Connector include…

3

Mapping Functions: What are they and where can I find out more about them?

When integrating data between Microsoft Dynamics CRM and the Microsoft Dynamics ERPs, there is always going to be a need to adjust the “shape” of the data so that it can be successfully integrated between the two systems. You may need to change the format of the data or possibly aggregate multiple source fields to…

14