2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents


Panel

Process

Microsoft Dynamics CRM Online to QuickBooks Bidirectional template provides integration between QuickBooks and Microsoft Dynamics CRM Online. The integration solution is defined as a process within the DBSync profile as follows. 

Microsoft CRM

QuickBooks

Accounts and Contacts as

Customer

Products as

Items

Opportunity as

Jobs

Invoice as

Invoice

Order as

Sales Order

...

QuickBooks

Microsoft CRM

Customer

Accounts

Customer

Contacts

Jobs

Opportunity

ItemInventory

Products

ItemNonInventory

Products

Invoice

Invoice

Sales Order

Order

Panel

Microsoft CRM Setup

  • Download the DBSync Microsoft CRM-Quickbooks solution package from the following URL.

...

Note:
Out of the box DBSync supports Products/Items in a flat structure and not in Hierarchy as Products in Microsoft CRM does not support a Hierarchical structure. Please look at our Knowledge base for steps for handling hierarchies in Items from QuickBooks.

Panel

DBSync Setup

...

  • Scroll down to the bottom of the section and click on Validate Connection button to validate your Microsoft CRM credentials & click on Save.
Panel

Intacct Setup:

...

  • At this point, you have configured your DBSync profile to connect with your MSCRM Online instance and Intacct account.
Panel

Running the Integration:

...

  • Schedule button can also be used to schedule the integration.
Panel

Profile Setup 


Microsoft CRM

Configuration

Instructions

Username

<<Username>>

Password

<<Password>>

MSCRM Soap URL

https://<<server_name>>/XRMServices/2011/Organization.svc 

Auth Type

Live ID

ProxyHost

If you use a proxy server then enter the <<proxy ip or host>>

ProxyPort

If you use a proxy server then enter the <<proxy port>>

ProxyUserName

If you use a proxy server then enter the <<proxy username>>

ProxyPassword

If you use a proxy server then ether the <<proxy password>>

Domain