7 Sep’16

Dynamics AXIntegrating Data to Multiple Dynamics AX7 Legal Entities using Scribe Online

Introduction:

A single Microsoft Dynamics AX7 database can contain multiple individual company accounts. Each company account in an application uses the same application logic, but has its own set of data for tables. Data that is stored in one company account cannot be accessed from other companies. So, for Integrating data into these multiple individual company accounts, some procedures need to be followed.

In this article, we will integrate Customers from Microsoft Dynamics CRM Online to multiple legal entities (companies) in Dynamics AX7, using the SCRIBE ONLINE as an integration tool.

Prerequisite:

  1. Microsoft Dynamics CRM Online.
  2. Dynamics AX7.
  3. Scribe Online Subscription.

Purpose of the Setup:

Our goal is to integrate Data from Microsoft Dynamics CRM Online to Multiple Companies which are setup in Dynamics AX7 through Batched Process. (It can be done in Real time as well).

Steps:

  1. Configure a connection for your Microsoft Dynamics CRM Online by providing the required information.
  2. Configure a connection for your Dynamics AX7 by providing the required information. In the Company Name field of the connector:
    1. You can specify any legal entity name which is present in Dynamics AX7.
    2. Or You can specify your company name.
  3. We will consider two scenarios:
    1. Steps for creating records in multiple companies in Dynamics AX7:

      Scenario 1: We will create a Customer in CRM Online and integrate it to “DAT” Company of Dynamics AX7.

      1. Create a new Solution and specify the Solution name and the Agent.
        Note: Here, we are using a Cloud Agent.
      2. Now create an Advance Map for integrating Customers from CRM Online to Dynamics AX7.
        1. Source: Microsoft Dynamics CRM Online
        2. Target: Dynamics AX7
        3. While mapping the fields, in dataAreaId field of Dynamics AX specify the legal entity name of AX7 for which the customers should be integrated.

          Note: In Dynamics AX7 table, the legal entity name for each record is stored in dataAreaId field.

        4. Test the Map by creating a Customer in CRM Online and then run the above Solution in Scribe Online.
        5. Now go into Dynamics AX7(DAT Company), you can see the customer has been integrated from CRM.
          Conclusion:

        1. If a dataAreaId field is specified, then records will be created in AX7 for that company (irrelevant to the company name specified in the Scribe Online AX Connector)
        2. If a dataAreaId field of AX is not specified, then the records will be created in AX for the company specified in the Scribe Online AX Connector.
        3. If company name in Scribe Online AX Connector is not present in Dynamics AX7, no records will be created and Scribe will give the following error:

    1. Steps for fetching records from multiple companies in Dynamics AX7:

      Scenario: We will create two Customers in Dynamics AX7 for two different companies (DAT and USMF) and integrate it to CRM Online.

      1. Create a new Advance Maps and specify Source and Target Connection.
        1. Source: Dynamics AX7.
        2. Target: Microsoft Dynamics CRM Online.

        In the Query block, mention filter criteria as:

        dataAreaId = “dat “
        or dataAreaId =” usmf”
        

      2. Create Customers in Dynamics AX7; one customer in “DAT” company and another in “USMF”.
      3. Run the above Map from Scribe.
      4. Now go into CRM, you can see the customer has been integrated from Dynamics AX7.
        Conclusion:

      1. If a dataAreaId is not specified, records are fetched from AX7 of the company which is specified in the Scribe Online AX Connector.
      2. If a dataAreaId is specified, records are fetched from AX7 of the company which is specified in dataAreaId field. (irrelevant to the company name specified in the Scribe Online AX Connector or User Company Name)

 

Written by

Team Member

CloudFronts

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more