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 hotfix can be found in the Life Cycle Services tool using the following link:

The associated Dynamics AX 2012 R3 KB is 3026356.

After applying the hotfix you will need to compile the ConnectorHelper class and then run that class again.

This hotfix only applies to Microsoft Dynamics AX 2012 R3.

Comments (5)

  1. Siu Chon says:

    Dear thehetz,
    I am mapping firstname and lastname from CRM to AX 2012. But firstname and lastname in AX are empty, only searchname that filled with the fullname at AX. I tried to figure out, it turns that ‘effective to’ must be set to never (i did it in AX database with a script). If I want to set the ‘effective to’ from the UI Connector Mapping, what function must i use? Please suggest. Thank you very much.

    1. thehetz says:

      I believe that you will want to use the Default() function. This provides the default value for a given attribute’s type.

      1. siuchon says:

        Hi thehetz,
        If I use Default() function then following error occurred: “The value ‘0001-01-01T00:00:00’ is not a valid ‘UtcDateTime’ type.”

        1. thehetz says:

          Try supplying the minimum date for Dynamics AX. 1-1-1900. Something along the lines of CreateDate(‘1900’, ‘1’, ‘1’)

          1. siuchon says:

            Hi thehetz,
            It works with ‘Valid From’ = =UtcNow() and ‘Valid To’ = GetUtcTime(Date(2154, 12, 31)). Thanks alot for your guidance.

Skip to main content