Page History

Overview 
Data Flow
Process Map
Pre-requisites for Integration 
DBSync Profile Setup
Run Integration from QuickBooks Web Connector

Standard Integration from DBSync for Salesforce & QuickBooks Desktop is an easy to use application to integrate . It integrates Salesforce Accounts/Contacts, Products, Opportunity with QuickBooks Customers, Items, Sales Order & Invoice. DBSync provides sync with pre-built field-to-field map mapping along with flexibility for more complex and dynamic mapping capability. DBSync also has an 's automatic online update , enabling DBSync enables its customers to enjoy all the product updates and features that come with every new release.

Integration data flow between Salesforce & QuickBooks Desktop is shown in the table below table.

Process Map of Standard integration between Salesforce & QuickBooks Desktop is shown in the image below image.

• Integration of Salesforce to QB QuickBooks Sales Order is invoked provided if the Generate field in Salesforce Opportunity is selected as Sales Order.

• Integration of Salesforce to QB QuickBooks Invoice is invoked provided if the Generate field in Salesforce Opportunity is selected as Invoice.

• It is mandatory that SF Opportunity (to be integrated with QB QuickBooks Invoice) is associated with the respective SF Account & . It should also should have Products with Standard Price Book attached to it for DBSync to invoke integration.

• Salesforce Products should also have QuickBooks Item Type.

• Go to www.mydbsync.com & and register for Free Trial. Ensure that Source & and Target Adapters are Salesforce & QuickBooks Desktop respectively. Choose the standard package during registration.

...

1. Consider the following points carefully before integrating Standard DBSync Salesforce QuickBooks Bi-directional.
2. Integration of Salesforce to QuickBooks transaction is invoked

...

1. if the Generate field in Salesforce Opportunity is selected with the required transaction.
2. It is mandatory that Salesforce Opportunity (to be integrated with QuickBooks Transaction) is associated with the respective Salesforce Account

...

1. . It should also

...

1. have Products with Standard Price Book attached to the Salesforce Opportunity for DBSync to invoke integration. Products should also have QuickBooks Item Type.
2. The Primary Contact updated in Salesforce Opportunity will sync with QuickBooks Contacts.
3. QuickBooks to Salesforce

...

1. integration works on time stamp. Payment applied on QuickBooks Invoice will be synced with DBSync custom object Invoice

...

1. . This will be related to the corresponding Salesforce Opportunity.
2. Once you setup

...

1. integration, go to your QuickBooks Web Connector

...

1. by clicking on Start > Programs > QuickBooks > Web Connector

...

1. . Then, click on the

...

Image Removed

1. Password text box for profile 

...

1. DBSync3-CRM_QuickBooks_dt.
2. Enter your DBSync 

...

1. Password in the

...

1. text box and

...

1. click Enter

...

1. .

...

1. A Message Box display will

...

1. ask "Do you want to save this

...

1. Password"

...

1. . Select the Yes button. DBSync Password will be saved in the

...

1. Web Connector.

Image Removed

1. Check the 

...

1. DBSync3-CRM_QuickBooks_dt check box and click on Update Selected button

...

1. . This will start the sync and the process will complete automatically. Auto-Run can also be used in Web Connector to run integration

...

1. at regular intervals. For example, if you select 60 minutes interval, after every 60 minutes integration will run by itself

...

1. provided Web Connector is open.

...

Image Removed