You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Next »
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.
Accounts and Contacts as |
|
Customer |
Products as |
|
Items |
Opportunity as |
|
Jobs |
Invoice as |
|
Invoice |
Order as |
|
Sales Order |
Process Map
Microsoft CRM to QuickBooks.
Microsoft CRM |
QuickBooks |
Account/Contact |
Customer |
Opportunity |
Jobs |
Product |
ItemService,ItemInventory,ItemNonInventory |
Invoice |
Invoice |
Order |
Sales Order |
QuickBooks to Microsoft CRM
QuickBooks |
Microsoft CRM |
Customer |
Accounts |
Customer |
Contacts |
Jobs |
Opportunity |
ItemInventory |
Products |
ItemNonInventory |
Products |
Invoice |
Invoice |
Sales Order |
Order |
Microsoft CRM Setup:
- Download the DBSync Microsoft CRM-Quickbooks solution package from the following URL.
https://dbsync01.appmashups.com/appmanager/library/DBMSQB_1_0.zip
- The downloaded MS CRM-Quickbooks solution package will be in a .ZIP format.
- Upload the zipped "DBMSQB_X.zip" solution package to your Microsoft CRM Online instance as shown.
Settings — Customizations — Solutions — Import.
- Browse for the location on your hard drive where "DBMSQB_X.zip" was downloaded and click on Next as shown.
![](/docs/download/attachments/4522025/worddav3a7a77cdcd3bdf05db0784e2cf570146.png?version=1&modificationDate=1329311670000&api=v2)
- Once the Solution Package is uploaded to your MS Dynamics CRM Online instance, you should be able to see the same in the Solutions list as shown below. Click on Publish All Customizations button to commit all the changes done to your MS CRM instance.
![worddav349cd23a2d7467dd583f3da66f266553.png](/docs/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2)
- After a successful import of the solution package, you will find a section called "DBSync" within Account, Contact, Opportunity, Invoice and Order objects with custom fields that are essential for the Integration process.
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.
DBSync Setup
- Enter your DBSync User Name and Password and click on Login.
- Once logged in, click on "My home" tab from the menu and click on Launch button.
- You will be re-directed to DBSync profile page.
- Click on Quick Start button to navigate to the configuration window as shown.
![worddave1a027b5a93554d9b890d9bf86c61c2e.png](/docs/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2)
![worddavf0c80f3580e8d49950beff9836f2c731.png](/docs/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2)
- Select MSCRM adapter from the top left hand column of the Quickstart window.
- Enter your Microsoft CRM username and password. Make sure you modify the "endpoint" url according to the domain name provided to you by Microsoft at the time of registration for Microsoft Dynamics CRM Online application. A sample example is shown below.
Endpoint : https://*\* (https://**)<Your Microsoft CRM URL>/XRMServices/2011/Organization.svc
- In the above example, your Microsoft CRM URL should be prefixed in place of the default value.
- Scroll down to the bottom of the section and click on Validate button to validate your Microsoft CRM credentials.
Quickbooks Desktop Setup:
- Navigate to Quickstart window as described in the above section. Click on Quickbooks adapter on the top left hand side of the Quickstart window.
- Under your QuickBookAdapter section, enter Full path to your QuickBooks file on your desktop.
![worddav00513de041f1c0ad7a681dd24ff24185.png](/docs/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2)
- You can retrieve full path / location of your Quickbooks file by pressing 'F2' key on your keyboard when in Quickbooks 'Home' page as shown below.
- Open the .QWC file with QuickBooks Web Connector.
![worddav12abdb4d5094dbe2890c0b7ab95ac2b3.png](/docs/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2)
- Click on OK button on the Authorization window.
![worddavfb317bdd54fcdefb260ef327ce962bb9.png](/docs/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2)
- Select the option 'Yes, always; allow access even if QuickBooks is not running'and click on continue and Done button in the follow up screen.
![worddav63530b796a8a080ac3b7cedacfdddea2.png](/docs/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2)
![worddav05c863a87cb2e15419ce423dbb590252.png](/docs/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2)
- After clicking on Done, the web connector is launced with the selected integration profile. Select the integration profile/profileName, enter dbsync password and finally click on "Update Selected" to initiate the integration.
![worddav995a9422fd6fe7d2c0cf8e6d2c369e67.png](/docs/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2)
- This completes the configuration of your DBSync profile with your Microsoft Dynamics CRM Online instance and Quickbooks desktop.
Profile Setup
Microsoft CRM
Configuration |
Instructions |
Username |
<<Username>> |
Password |
<<Password>> |
EndPoint |
https:// (https://**)<Your Microsoft CRM URL>*/*XRMServices/2011/Organization.svc |
Transport.compression |
True/False |
sid |
As Applicable |
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>> |
acceptGzip |
As Applicable |
sendGzip |
As Applicable |
Advanced Properties
Configuration |
Instructions |
Log Level |
ALL (It is recommended to set the Log Level as "All") |
PDL : Process Definition Language
Configuration |
Instructions |
Process Name |
Name of the process definition file used for the integration |
Select Process File |
Uploading a process file from an appropriate location on your local drive. |