...

Contents
Overview:
Data Flow:
Process Map:
Pre-requisites for Integration:
DBSync package (QuickBooks Integration) Installation in Salesforce:
DBSync Profile Setup:
Running the Integration:

Overview:

DBSync for Salesforce & QuickBooks Online Integration is an easy to use application to integrate Salesforce Accounts / Contacts, Products, Opportunity with QuickBooks Online Customers, Items, Invoice, Sales Receipt & Credit Memo. This is also useful to migrate historical QuickBooks Online data into Salesforce or vice versa.
DBSync provides Bi-directional sync with 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.

...

Data flow of Bi-directional integration between Salesforce & QuickBooks Online is shown in the below table.

AnchorOLE_LINK7OLE_LINK7 AnchorOLE_LINK8OLE_LINK8 Anchor_Image Added

Process Map of Bi-directional integration between Salesforce & QuickBooks Online is shown in the below image.

Image Modified

• Integration of Salesforce to QBOE transaction is invoked provided the Generate field in Salesforce Opportunity is selected with the required transaction.

...

• DBSync Package Installation Details will be displayed in your Salesforce instance. Click on 'Continue'.

Image Modified

• Approve Package API Access and then click on 'Next'.

Image Modified

• Choose Security Level to Grant Access and then click on 'Next'.

Image Modified

• Package is ready to be installed. Click Install to 'install'.

Image Modified

• Install complete message will be displayed which confirms that DBSync Package is installed.

Image Modified

• Go to setup  Image Modified  Customize  Image Modified  Account  Image Modified  'Page Layout'  Image Modified  Edit the Page Layout. Under the Page Layout drag the fields specified below to add it in Page Layout and Save.
  • Fields: "Quickbooks Id", "QB Error"
  • Button: " Update Account To QBOE"

Image Modified

• Go to setup  Image Modified  Customize  Image Modified  Contact  Image Modified  'Page Layout  Image Modified  Edit the Page Layout.

• Under the Page Layout drag the fields and buttons specified below to add it in Page Layout and Save.
  • Fields: "Quickbooks Id", "QB Error", "QBName"
  • Button: " Update Contact To QBOE"

Image Modified

• New Buttons "Update Opportunity To QBOE_New" and "Update Invoice from QBOE_New" should be created in Salesforce Opportunity by referring the below steps.

Go to setup  Image Modified  Customize  Image Modified  Opportunity  Image Modified  'Buttons, Links and Actions'  Image Modified New Button or Link.
Enter the below mentioned details and save to create two buttons.

...

OnClick JavaScript: var URL="{!$User.AVSFQB_QBOE_DBSync_Serverc}/qboe.m?sfUrl={!$Api.Partner_Server_URL_140}&qboeCT={!$User.AVSFQBQBOE_Connection_Ticketc}&pdl=processdefinition_SFQB_OpportunityTo{!Opportunity.AVSFQBGenerate_Objectc}.xml&recordId={!Opportunity.Id}&dbsyncId={!$User.AVSFQBDBSync_Idc}&profileName={!$User.AVSFQBDBSync_Profilec}&sessionId={!$Api.Session_ID}&dbsyncPasswd={!$User.AVSFQBDBSync_Passwd_c}"; window.open(URL,"DBSync","menubar=0,resizable=0,width=650,height=300");

Image Modified

Label: Update Invoice from QBOE_New

...

OnClick JavaScript: var URL="{!$User.AVSFQB_QBOE_DBSync_Serverc}/qboe.m?sfUrl={!$Api.Partner_Server_URL_140}&qboeCT={!$User.AVSFQBQBOE_Connection_Ticketc}&pdl=processdefinition_QBSF_InvoiceToInvoice.xml&recordId={!Opportunity.Id}&dbsyncId={!$User.AVSFQBDBSync_Idc}&profileName={!$User.AVSFQBDBSync_Profilec}&sessionId={!$Api.Session_ID}&dbsyncPasswd={!$User.AVSFQBDBSync_Passwd_c}"; window.open(URL,"DBSync","menubar=0,resizable=0,width=650,height=300");

Image Modified

• These new buttons along with the other required fields should be included in the page layout by following the below steps.

Go to setup  Image Modified  Customize  Image Modified  Opportunity  Image Modified  'Page Layout'  Image Modified  Edit the Page Layout.

• Under the Page Layout drag the fields specified below to add it in Page Layout.
  • Fields: "Quickbooks Id", "Primary Contact", "Generate", "QB Error"
  • Buttons: "Update Opportunity To QBOE_New", "Update Invoice from QBOE_New"

Image Modified

• Move Invoices from the Opportunity Related List to the page layout.

• Click on Invoices in the Related List Section and hit "edit properties" button. Select columns as Invoices, Invoice number, Total Invoice Amount, Payments, Balance, Days Outstanding, and Transaction Date. Save the opportunity 'page layout'.

Image Modified

• Go to Setup  Image Modified  Customize  Image Modified  Opportunity  Image Modified  Opportunity Products  Image Modified  Edit Page Layout to move 'QuickBooksID' field to the page layout.

Image Modified

• New Button "Update Product To QBOE_New" should be created in Salesforce Product by referring the below steps.

• Go to setup  Image Modified  Customize  Image Modified Product  Image Modified  'Buttons and Links'  Image Modified New Button or Link.

• Enter the below mentioned details and save to create two buttons.

...

OnClick JavaScript: var URL ="{!$User.AVSFQB_QBOE_DBSync_Serverc}/qboe.m?sessionId={!$Api.Session_ID}&sfUrl={!$Api.Partner_Server_URL_140}&qboeCT={!$User.AVSFQBQBOE_Connection_Ticketc}&pdl=processdefinition_SFQB_Item.xml&recordId={!Product2.Id}&dbsyncId={!$User.AVSFQBDBSync_Idc}&profileName={!$User.AVSFQBDBSync_Profilec}&dbsyncPasswd={!$User.AVSFQBDBSync_Passwd_c}"; window.open(URL,"DBSync","menubar=0,resizable=0,width=650,height=300");

Image Modified

• Go to Setup  Image Modified  Customize  Image Modified  Product  Image Modified 'Page Layout' fields to add is "QuickBooks Item type" , "QuickBooks Id" , "QB Error", "COGS" and "OnHand'" and Buttons "Update Product To QBOE_New" to the page layout.

Image Modified

• Go to setup Image Modified Customize Image Modified  Users  Image Modified 'Page Layout' Image Modified Edit the Page Layout. Under the Page Layout drag the fields and buttons specified below to add it in Page Layout and Save.
  • Field "DBSync Id"
  • Field "DBSync Passwd"
  • Field "DBSync Server URL"
  • Field "DBSync Profile"

...

• Login using to dbsync account, go to Company tab, click on edit to view DBSync Org Properties. Click on edit and replace the existing URL with https://dbsync01.appmashups.com/qboev3/login.m

Image Modified
Image Modified
Image Modified

• Go to Process Template tab in DBSync home page and click on SalesforceQuickBooksOnline:BiDirectional to include process template for Bi-directional Integration of Salesforce & QuickBooks Online.

...

Configure Salesforce Adapter:
Enter Salesforce Username, Password & Security Token. Click on Save Properties to save the settings. Click on Validate to confirm the Salesforce connections settings are valid.

Image Modified

Configure QuickBooks Online Adapter:
Go to QuickBooks Online Connection properties, click on Configuration link, which will take you to new tab to authorize Intuit to securely share your data to DBSync QBRv3.

Image Modified

Click on Authorize to continue. Confirmation email will be displayed as "Your QuickBooks Online is now connected with the Profile. Please close this window now".

Image Modified

Go to DBSync Quick Start, all the QuickBooks Online Adapter Connection properties fields will be auto populated. Click on Save Properties of to save the settings. Click on Validate to confirm the QuickBooks Online connections settings are valid.

Image Modified

Running the Integration:

DBSync Integration of Salesforce & QuickBooks Online can be initiated by the following three methods.

...

Salesforce custom buttons in Salesforce Accounts, Contacts and Opportunity can be used to update these specific records into QuickBooks as and when required. To set Auto run of integration, one of the next methods should be used.
Salesforce Custom Button Update Account to QBOE in Accounts Object is shown below.

Image Modified

Salesforce Custom Button Update Contact to QBOE in Contacts Object is shown below.

Image Modified

Salesforce Custom Button Update Opportunity to QBOE and Update Invoice from QBOE in Opportunities Object is shown below.

Image Modified

Using DBSync Scheduler:

Scheduler available in DBSync Account can be used to schedule the integration.
Login to DBSync account, click on Launch to go to DBSync profile page and click on Scheduler on the top right corner.

Image Modified

Select the integration profile and required process to auto run. Edit the Cron Settings to set the frequency of Auto run and Save Cron Job.

Image Modified