WDF 2500006 - Master Data Mapping Tool for Microsoft Dynamics 365 Sales Connector is available in Integration Hub

WDF 2500006 - Master Data Mapping Tool for Microsoft Dynamics 365 Sales Connector is available in Integration Hub

This tool allows the user to map the already existing Account, Contact, Lead, and product data in Microsoft Dynamics 365 Sales and SAP Business One. This is needed in case the same Account or Contact or Lead or product master already exists in both applications and you would like to map their internal code to prevent data duplicity between the applications.

To display the Master Data Mapping Tool window, choose Administration-->Integration Hub-->Master Data Mapping Tool.



Use the following steps to import the mapping data using the master data mapping tool:
1. Select a template from the Template dropdown list.
2. Select the Account, Contact, Lead, or Product from the Master Data Type dropdown list.
3. Choose the Download from App button to download the data from Microsoft Dynamics 365 Sales.
4. To check the data download status, choose the Status button.
5. Once the data download is complete, choose the Prepare Template button to generate the Microsoft Excel-based template for the selected master i.e. Account or Contact or Lead or product. The application downloads the data from Microsoft Dynamics 365 Sales.
6. Open the template and provide the relevant information:
o For the Customer template, you need to provide the SAP B1 Card Code (Customer Code)
o For the Lead template, you need to provide the SAP B1 Card Code (Lead Code)
o For Contact, you need to provide the SAP B1 Card Code and SAP B1 Contact ID (Customer Code and Contact ID)
o For the Product template, you need to provide the SAP B1 Item Code
7. Choose the Browse button to navigate to the template path.
8. Choose the Validate button to check the correctness and completeness of the data in the selected template. 
9. Choose the Upload button to import the data.

Solution

The enhancement described above has been incorporated in the Intercompany integration solutions version 50 and higher versions.

Product
Product or Product Version
B1 INTERCOMPANY INTEGRATION 2.0
SAP B1 10.0 FOR SAP HANA
SAP B1 9.3 FOR SAP HANA
SAP BUSINESS ONE 10.0
SAP BUSINESS ONE 9.3

This document refers to : 
WDF 2500001 - Overview Note for Intercompany integration solution 2.0 Version 50 for SAP Business One