Connector -- Integrating Dynamics ERP with Dynamics CRM

Connector for Microsoft Dynamics is an integration solution which is targeted specifically at the Microsoft Dynamics product family. Connector provides an out of the box integration between Dynamics CRM and Dynamics ERP solutions.

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

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

Rate This
  • Comments 1

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 might find that you are missing products in Microsoft Dynamics CRM after the map runs.  For many customers, the data sources for the AxdItem and AxdInventoryOnHand queries may sort by RecId.

By adding ItemId to the sorting option and then removing RecId from the sorting option (this order of operations is important) on those queries the Item to Product map should work as expected, as shown in the screenshot below:

Note: If you have other custom business logic that utilizes these queries, you will want to analyze if this change will affect that logic.

PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the link in the Related Links section (scroll up, on right hand side) to ask on the Dynamics Communities. If you ask on the Communities, others in the community can respond and the answers are available for everyone in the future.
Leave a Comment
  • Please add 6 and 3 and type the answer here:
  • Post
Page 1 of 1 (1 items)