2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

After you had installed install our Salesforce & and QuickBooks package from Salesforce's AppExchange of Salesforce, You you need to select DBSync: QuickBooks Integration from the Force.com App Menu which will . This will launch the DBSync QuickBooks Integration appApp. NowNext, You you will need to navigate to the Setup tab to setup set up your Salesforce and QuickBooks connectors that Connectors. This will open connections with the respective applications.


Setup

...

  

As shown in the image above image, Navigate navigate through a Setup wizard which . The process is self-explanatory for an - a user to can finish his/her connections with Salesforce and QuickBooks Instances with ease

Salesforce: For the ease of setup, we support OAUTH authentication with Salesforce, . Click on Connect to Salesforce which . This will open up an a pop up to validate your instance credentials. After a successful connection, As as shown in the image, you will see notice that the button is changed from "Connect to Salesforce" to "Would you like to re-connect". Now click on Click Next button to proceed with the QuickBooks setup.

QuickBooks: From the QuickBooks menu, you will have the option to toggle between QuickBooks desktop Desktop and QuickBooks onlineOnline. If you choose QuickBooks desktop, Connection connection parameters pertaining to desktop loads up on the page. Make sure to input your QuickBooks file location, QuickBooks version.

If you had chosen choose QuickBooks online - from the QuickBooks type drop-down , We support OAUTH authentication even for QuickBooks online but you need to authenticate with additional security check from intuit. 

...

- then, you should key in QuickBooks Online username and password to authenticate and connect with your QuickBooks Online instance (OAUTH Authentication for QuickBooks Online). Next, you will be prompted to enter a 6 digit code as an added security check from Intuit. The code will be sent to your registered Email id.

Setup Processes 

In order to trigger the Integration, you will have to check the "Generate Customer & Invoice From Opportunity" button and . Then, click on save buttonSave. From the Setup Processes menu, the User also has an option to upgrade his/her plan from the Free to, either Standard or Enterprise, depending on his/her integration needs. Before you actually pay for the plan, you also have an option to take a Free Trial of the plan if you wish to subscribe to it.

Checklist Before Triggering Integration

you will have to change the page layout for the Accounts, Contacts, Opportunity, Product Salesforce 

Integrations:

Keep in mind these few things before initiating the integration - using either Free or Standard version - between Salesforce and QuickBooks. 

  1. You will have to change the Page Layout of Accounts, Contacts, Opportunity, Opportunity product and Product in Salesforce. This is explained, in detail, in a latter section.
  2. You should mark Opportunity as an Invoice from the DBSync section of the "Generate" field.
  3. If you are using QuickBooks desktop, you can initiate the sync only from QuickBooks web-connector. Make sure to Setup QuickBooks Web-connector by following the link.
  4. If you are using QuickBooks online, you can Initiate the sync from the Account\Product\Opportunity by clicking the DBSync button.

                 For Eg: When you want to sync SF Account To QuickBooks online customers then, click on the "SF Account>> QuickBooks Online Customer" button.  

 

Image Added

Following steps explain how to change Page Layout of an Account - and other objects - in Salesforce:

  1. Navigate to Salesforce Setup page by clicking on the Setup located on the top right section of the page - the button is next to the Help menu.
  2. From the Quick Search area - located on the extreme left section of the page - search for "Page Layout" and scroll down to find the Account/ Page-Layout menu options to the left of the page.
  3. Open the Account Page Layout page. Click on "Page Layout Assignment". Then, click on Edit Assignment.
  4. Select all the user roles, for which, want to change the Page Layout. From 'Page Layout To Use', choose DBSync Account Layout. Save your changes.
  5. Open any Account from the Account page. Here, you will find the information as shown in the image above.

Asynchronous Call 

With the package versioned 1.27, we started supporting Asynchronous call. As a result, if a user updates any columns an Opportunity record in Salesforce then, just by clicking Save, the changes will be posted to QuickBooks online. 

Free Vs Standard

Free VersionStandard Version
Opportunity To Invoice
  • Pre-Defined Setup, just select the flow.
  • Opportunity to Invoice or Sales Order.
  • Create Jobs.
  • Move Payment to Salesforce.
  • Product to Items.

10 Records per day

500 records per day only.

QuickBooks Desktop: Invoice
QuickBooks Online: Invoice

QuickBooks Desktop: Invoice & SalesOrder.
QuickBooks Online: Invoice & Estimate.

Useful References

Salesforce Connector

QuickBooks Desktop Connector

QuickBooks Online REST Connector

Configuring DBSync with QuickBooks Desktop Web Connector

Installing QuickBooks Web Connector

Starting QuickBooks Web Connector