Salesforce FieldService & QuickBooks Integration (Uni-directional)

DBSync for Salesforce FieldService & QuickBooks is an easy to use application to integrate Salesforce FieldService Accounts, Contacts, Work Orders & Work Details with Customers, Jobs, Invoice & Line Items of QuickBooks Desktop.
DBSync provides pre-built field to field map along with flexibility for more complex and dynamic mapping capability. DBSync also has an automatic online update, enabling DBSync customers to enjoy all the product updates and features with every new release.
This user guide explains basics of integration like

• Data Flow & Process Map
• Salesforce to QuickBooks Field Mapping
• Steps to get started with DBSync

Salesforce FieldService to QuickBooks Desktop (Unidirectional)

Integration dataflow is invoked provided the following fields in Salesforce are selected as mentioned in the below table.

It is mandatory that SF Work Order (to be integrated with QB Invoice) is associated with the respective SF Account & also should have work details attached to it for DBSync to invoke integration.

1. Register for Free Trial of Salesforce & QuickBooks: Go to www.mydbsync.com, click on Register for Free Trial to register for DBSync Account. 
2. Include Salesforce FieldService Process Template to DBSync Account:* *Login to your DBSync Account, go to process template tab, click on SalesforceFieldServiceQuickBooks:UniDirectional to include the template to your account. Go to My home tab & click on Launch, you will find the new Salesforce FieldService process template.
3. Install DBSync Package into Salesforce FieldService instance: This topic is explained in detail at the end.
4. Configure DBSync with QuickBooks Web connector: Steps involved in configuration is available in the below wiki link http://help2.mydbsync.com/docs1/display/dbsync/Configuring+DBSync+with+Quickbook+WebConnector
5. Run Integration using QuickBooks Web Connector: Use QuickBooks Web connector to run integration by selecting the right application in Web Connector. Update Selected helps to initiate sync manually where as Auto-Run is used to schedule integration.

Package "Salesforce Field Service", Version 14.10000 or later must be installed in Salesforce Instance.

1. Click on the below link to install DBSync Package from AppExchange
2. Enter your Salesforce Username and Password to install DBSync Package in that Salesforce instance. Salesforce instance must have the administrative privileges to install App.
3. DBSync Package Installation Details will be displayed in your Salesforce instance. Click on 'Continue'.
4. Approve Package API Access and then click on 'Next'.
5. Package is ready to be installed. Click Install to 'install'.
6. Install complete message will be displayed which confirms that DBSync Package is installed. 

   QuickBooks Id:
   Accounting Id is the unique Id for a record in QuickBooks. After successful integration, Accounting Id is updated in Salesforce for every record that has been synced. 
   Generate:
   Generate field is a picklist field to flag Service either SalesOrder / Invoice or None. By default the value of Generate field will be blank. It is necessary that Generate field is selected SalesOrder/Invoice for successful generation of SalesOrder/Invoice in QuickBooks during DBSync Integration. 
   QB Error:
   Sync Error is an error from QuickBooks which gets updated in Salesforce for every record that has failed to sync. Sync Error briefly describes the reason for failure of sync. 

7. Once the DBSync Package SF Field Service Integration is installed the below fields should be included in Page Layout as explained below.
8. Go to setup > Customize > Account > 'Page Layout' > Edit the Page Layout. Under the Page Layout drag the fields "QuickBooks Id"  to add it under the section "System Information" in Page Layout and save.
9. Go to setup > Create > Objects > Work Order > Page Layout > Edit the required Page Layout.
10. Under the Page Layout create a new section "DBSync Information" & drag the fields "QuickBooks Id", "Generate", "QB Error" to add it in Page Layout under "DBSync Information".