Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I am facing one major issue in Connector to retrieving the Master tables data from AX to CRM.
In AX we have 5 Master tables like
1. Country Table
here in the Country table am having Country data so that am a able to retrieve the data from AX to CRM
2. State Table
here in the state table am having Country and state data so that am a able to retrieve the data from AX to CRM
here in the County table am having Country ,state and County data so that am a able to retrieve the data from AX to CRM.
4. City Table
here in the Tehsil table am having Country ,state ,County and tehsil data so that am a able to retrieve the data from AX to CRM.
4. Disrict Table
here in the District table am not able to retrieve the District table data from AX to CRM by using Connector.
in the connector there am able to find the bellow attributes from AX table
in AX server in those columns(Country,State,County..etc) i do not have any data.
can any one tell me is there any way to fetch the country , state ,county , tehsil data in connector means like data should be there in Country , state , county columns in AX server or can we get the data from other table.
can any help me on this.
thanks in advance
If you want to transfer only LogisticsAddressDistrict master data from Ax to CRM, then use as state in the image select Name (is nothing but District ID) and Description (is nothing but District name). By assiging these you can move the master data.
If you want to transfer Customer data with Address, use ConnCustomerOrgService. By using this service we can able to get the Country, state, City and District from PostalAddressView to map CRM fields.
Pls let me know if you have any doubt.
i wanted to Integrate the Master data only but here the problem is in CRM am not directly Mapping to Address Entity. in CRM Country, state, District and City's are Entities so want to have the relationship for every Entity then only i can i can have the related Records in Parent and child.
can i have your Email please
Hi Uma Shankar,
Please follow the below steps to resolve your issue,
Create and activate the connector mapping in the below order
1) LogisticsAddressCountryRegion -> Country entity
2) LogisticsAddressState -> State entity
3) LogisticsAddressCounty -> County entity
4) LogisticsAddresssCity -> City entity
5) LogisticsAddressDistrict -> District entity
6) LogisticsAddressStreet_RU -> Street entity
7) LogisticsAddressZipCode -> ZipCode entity
Thank you for your replay abbas
i was able to find the solution for this.
i have integrated City Master data into city Entity with integration key which was lookup of tehsil generally in AX Table.
i have integrated Tehsil Master data in to tehsil entity in CRM with RecId which the ref for city table in AX.
now from the CRM i have taken tehsil(District , state , country) data and updated in City Entity
Business Applications communities