# Dynamics365 CRM and QuickBooks Online

### Introduction

DBSync for Dynamics365 CRM & QuickBooks Online Integration is an easy to use application. It integrates Dynamics365 CRM Products, and Transactions with QuickBooks Online Item, and Transactions like Invoice, Estimate, and Sales Receipt. DBSync provides integration with pre-built field-to-field mapping along with flexibility for more complex and dynamic mapping capability. DBSync's automatic online update enables its customers to enjoy all the product updates and features that come with every new release.

### Data Flow

Data flow integration between Dynamics365 CRM and QuickBooks Online Integration is shown in the table below.

| Dynamics365 CRM                  | QuickBooks Online                |
| -------------------------------- | -------------------------------- |
| Account                          | Customer                         |
| Product                          | Item                             |
| Opportunity, Invoice, SalesOrder | Invoice, Estimate, Sales Receipt |

### Process to Create an Integration

To utilize the pre-built template DBSync Dynamics365 CRM and QuickBooks Online follow the below steps:

1. Click **Add** **Template** > **Dynamics365 CRM and QuickBooks Online Integration** from the Template Library.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FvA3oRRu4TzVPzITrfka6%2FDynamics365CRM%20to%20QBO.png?alt=media&#x26;token=6e2890fa-f661-4472-938e-c486ed1b3b78" alt=""><figcaption></figcaption></figure>

2. Click **Import**. You can choose to provide a custome name for the template and click **Next**.&#x20;
3. Go to the **Task Screen** and click **Configure** to review pre-built workflows.

#### Configure  the template

4. In the **Connect** **tab**, connect your connectors and test the connection before customising the field mappings.

{% hint style="info" %}
For more information about connecting the Microsoft Dynamics CRM application, click [here](https://docs.mydbsync.com/cloud-workflow/connectors/microsoft-dynamics-crm-online).

For more informaiton about connecting the QuickBooks Online application, click [here](https://docs.mydbsync.com/cloud-workflow/connectors/quickbooks-online).&#x20;
{% endhint %}

#### **Configure Data Mapping**

5. In the **Setup** **tab**, customize the field mappings for entities that you want to map from **Dynamics365 CRM** to **QuickBooks Online** and click **Next.**&#x20;

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FvNseH4ph03OyeUWxWzVa%2FDynamics365CRM%20to%20QBO2.png?alt=media&#x26;token=74db7724-afae-4ae1-b1f3-af33b8975766" alt=""><figcaption></figcaption></figure>

#### Setup Variables

6. Definethe  values for variables based on your company's specific use case.

* For example, you can select how to create/update Transactions between Dynamics365 CRM and QuickBooks Online and select Transaction Type in Dynamics365 CRM or QuickBooks Online.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FsArjn930Qp50IjvqFbYf%2FDynamics365CRM%20to%20QBO3.png?alt=media&#x26;token=ca0925f3-c6a9-4fb5-af38-2b55e6dbba87" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2Fp7sE6e7E5gz6cFWWkGZ0%2FDynamics365CRM%20to%20QBO5.png?alt=media&#x26;token=9c3787a9-909f-40b7-adb9-bc889c3ecd05" alt=""><figcaption></figcaption></figure>

#### **Schedule Synchronization**

7. Navigate to the **Schedule tab** and define sync intervals (e.g., every 1 hour, daily).
8. Enable the scheduler to automate data synchronization.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FKfk9eud5q8mm67jdFuyY%2Flan%2012.PNG?alt=media&#x26;token=26661932-5271-4dd3-8760-8e6282465475" alt=""><figcaption><p>Scheduler</p></figcaption></figure>

#### **Run Synchronization**

9. Navigate to the **Run** **tab** and **c**lick **Run** to start manual synchronization or check logs for automated runs if the integration is scheduled.
10. Click **Configure** to access various workflows pre-built for the integration.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2Foa9A6OHTgWtWFUGpoOXN%2FDynamics365CRM%20to%20QBO4.png?alt=media&#x26;token=1548a9a4-f523-4f9c-90df-caee893972d3" alt=""><figcaption></figcaption></figure>

### Pre-built Template and Workflows

The template downloaded from the library contains various workflows which can be enabled to run the integration between Dynamics365 CRM and QuickBooks Online.

Make sure you ENABLE the required workflows before you run the integration.

Enable the Initial Setup and Run the integration to enable QuickBooks Accounts set up as displayed in the image. Also note, the following accounts are created in QuickBooks Online post Initial Setup Integration:

* Income Account

Ensure you TURN OFF the check box to 'Enable Flow' for the Initial Set up (After first Run) before you run the workflow to integrate Dynamics365 CRM Orders to QuickBooks Online using the other workflows. The first successful run is considered for the integration.