...
Note |
---|
We are connecting only with QuickBooks Desktop. |
DBSync for Salesforce Non Profit Success Pack (NPSP) & QuickBooks Desktop Integration is an easy to use application to integrate Non Profit Salesforce . It integrates Salesforce NPSP Accounts / Contacts, Opportunity with QuickBooks CustomersDesktop Customers, Items, Invoice & Sales Receipt. DBSync provides unidirectional sync with a pre-built field-to-field map mapping along with flexibility for more complex and dynamic mapping capability. DBSync also has an automatic online update, enabling . This enables DBSync customers to enjoy all the product updates and features with every new release.
Data flow of unidirectional integration between Salesforce Non Profit Salesforce Success Pack & QuickBooks Desktop is shown in the table below table. This The integration enables streamlines inserting a new record in QuickBooks Desktop. ![](/docs/download/attachments/11698563/DataFlow.jpg?version=3&modificationDate=1468873994000&api=v2)
...
Salesforce
...
QuickBooks Desktop
...
Accounts / Contacts
...
Customer / Contacts
...
Opportunity Name
...
Job Name
...
Opportunity & Product Name* *
...
Invoice & Line Item
...
Opportunity & Product Name
...
Sales Receipts & Line Item
...
DBSync Invoice
...
Payment on Invoice
...
Product Name
...
Items
Process Map of integration between Salesforce Non Profit Salesforce Success Pack & QuickBooks Desktop is shown in the image below image.
![](/docs/download/attachments/11698563/ProcessFlowSalesForce_QuickBooks.png?version=1&modificationDate=1468866927000&api=v2)
Panel |
---|
Pre-requisites for Integration: |
- Integration of Salesforce to QB QuickBooks Desktop transaction is invoked provided the ushered when the Generate field in Salesforce Opportunity is selected with the required transaction.
- It is mandatory that SF Opportunity (to be integrated with QB QuickBooks Desktop Invoice) is associated with the respective SF Account & . And, it should also should have Product Name in it, for DBSync to invoke integration.
Panel |
---|
DBSync package (QuickBooks Desktop Integration) Installation in Salesforce: |
- Get the following App from AppExchange for your Salesforce instance. https://login.salesforce.com/packaging/installPackage.apexp?p0=04t600000001j4f.
- Note: If you are installing into a sandbox organization , you must replace the initial portion of the URL with http://test.salesforce.com.
- It asks for Next, it will ask you for the username and password of the Salesforce instance where you would like to install DBSync. The Make sure that the username and password should have the belong to a person that has administrative privileges to install the app.
- You will see Package Installation Details of DBSync Package DBSync: QuickBooks QuickBooks Desktop Integration (version 1.24) along with Package Component. Click on Continue to proceed with installation. Follow the instructions to Approve Package API Access, Choose Security Level and complete the process of installation.
- Now, assign DBSync Page Layouts should be assigned for objects for Accounts, Contacts, Opportunity, Opportunity Products and Products objects. Following steps can be referred Refer the following steps to assign DBSync Page layout to Accounts Object. Existing Page Layout will be replaced by DBSync Page Layout. Any custom fields available in the existing page layout should be moved to DBSync Page Layout if required.
- Go to Salesforce Setup ? , Customize ? , Accounts ? , Page Layouts. This will show the list of available Page Layouts for Accounts Object. Click on Page Layout Assignment.
- You will find the list of default Page Layouts assigned for every Salesforce Profile.
- Click on Edit Assignment to proceed.
- Click on the Page Layout next to the required profile. Account Page Layout is assigned to the existing page layout for profile System Administrator and 's profile. As a result, System Administrator is the 's profile that should be assigned with to the DBSync Account page layout. In this case Account Layout should be selected next to System Administrator.
- Select DBSync Account Layout from Page Layout To Use picklist. Page Layout will be changed from Account Layout to DBSync Account Layout. Click on Save to save the new page layout assignment.
- Similarly assign DBSync Page Layout for the rest of the aforementioned Salesforce Objects - Contacts, Opportunity, Opportunity Products, and Products.
Panel |
---|
DBSync Profile Setup: |
- Go to www.mydbsync.com & and register for a Free Trial.
- Ensure that Source & and Target Adapters are Salesforce & QuickBooks Desktop respectively.
- When you have access to DBSync Account, ensure that Salesforce Non-Profit Salesforce Success Pack to QuickBooks Desktop: Unidirectional template is included from the template library.
Image Added
- Save Salesforce credentials and QuickBooks Desktop location should be saved in your DBSync profile and . Then, configure the QuickBooks web connector should be configured. Please refer to the below wiki link below for detailed detail steps. http://help.mydbsync.com/docs/display/dbsync/Configuring+DBSync+with+Quickbook+WebConnector|../../../../../../../../../display/dbsync/Configuring+DBSync+with+Quickbook+WebConnector|||||||||||||||||||||\
Panel |
---|
Run Integration from QuickBooks Web Connector |
- Before running the integration, carefully consider the below mentioned points should be considered carefully for following points for the Integration of Standard DBSync Salesforce QuickBooks BiDesktop Bi-directional.
- Integration of Salesforce to QuickBooks Desktop transaction is invoked provided ushered when the Generate field in Salesforce Opportunity is selected with the required transaction.
- It is mandatory that Salesforce Opportunity (to be integrated with QuickBooks Desktop Transaction) is associated with the respective Salesforce Account & . And, it should also should have Product name in it for DBSync to invoke integration.
- The Primary Contact updated in Salesforce Opportunity will sync with QuickBooks Desktop Contacts.
- Once you are done with the mappings, go to your QuickBooks Web Connector by Start ? Programs ? QuickBooks ? Web Connector and by clicking on Start > Programs > QuickBooks > Web Connector. Then, click on the password textbox text box for profile dbsync2-NonProfitSalesforceQuickBooks Desktop:UniDirectional.
- Enter your DBSync password in the in the text box and hit Enter on your keyboard. One Message Box will be displayed asking you "Do you want to save this password" - select Yes button. DBSync Password will be saved in the web connector.
- Check the dbsync2-NonProfitSalesforceQuickBooks Desktop: UniDirectional check box checkbox and click on Update Selected button and sync . This will start the sync and the process will complete automatically. Auto-Run can also be used in Web Connector to run integration in at regular intervals. For example, if you select 60 minutes, after every 60 minutes, integration will run by itself, provided Web Connector is open.
...
Copyright @ 2010, DBSync LLC and/or its affiliates. All rights reserved. This document is provided for information purpose only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor is it subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.
DBSync is a registered trademark of DBSync LLC and/or its affiliates. Other names may be trademarks of their respective owners.