We are currently working on the integration between Dynamics AX to Dynamics CRM and viceversa.
In the direction of Ax to CRM, we have SQL queries which joins multiple AX tables and using the result of the JOINS query we are able to map all fields to CRM from AX.
While working on the other direction CRM to AX, we have to update multiple tables on AX based on single entity for example Account on CRM. But the Dynamics AX Destination component is showing only one table to update.
Can some has some idea how to deal this other way integration from CRM to AX when we have to update multiple tables in the AX system?