...
- Accounts and Contactsas Customer
- Products as Items
- Opportunity as Estimates & Invoices
Sales Receipt & Sales Order
Credit Memos
KEY BENEFITS
...
Salesforce | QuickBooks |
Account/Contact | Customer |
Opportunity/OpportunityLineItem | Job(Invoice,SalesOrder,SalesReceipts,Estimate) |
Product/PriceBook | ItemService,ItemInventory,ItemNonInventory |
...
QuickBooks | Salesforce.com |
Customer | Accounts |
Customer | Contacts |
ItemInventory | Products |
ItemNonInventory | Products |
Invoice | Opportunity |
Estimate | Opportunity |
Sales Order | Opportunity |
Sales Receipt | Opportunity |
Credit Memos | Opportunity |
...
- Get the following App from AppExchange https://login.salesforce.com/?startURL=%2Fpackaging%2FinstallPackage.apexp%3Fp0%3D04t600000001g1f&crc=1
- It asks for username and password of the Salesforce.com instance where you would like to install DBSync. The username and password should have the administrative privileges to install.
- Next you should see the contents of the package in your Salesforce.com instance. Click on Next and then click on Install and then Click on "Deploy Now" button.
- Go to setup ? Build ? 'Custom Objects' menu to see whether "Invoice" object has "deployed" status. If not, click edit adjacent Invoice object, check on "Deployed", and Save.
- Go to setup ? Customize ? Account ? 'Page Layout' menu to add the "Quickbooks Id" field on the page layout. Save the Account 'page layout.'
- Go to setup ? Customize ? Contact ? 'Page Layout' menu to add the "Quickbooks Id" field on the page layout. Save the Contact 'page layout.'
...
- Go to setup ? Customize ? Opportunity ? 'Page Layout' menu to move "Generate", "Quickbooks Id" on the Page Layout.
In case you are using Professional version then move "Product Name" and "QuickBooks Item Type" to the layout.
For Professional Version's not having products can use "Product Name" as a single quantity product line item in Invoice, estimate or sales order instead of having Products as in Enterprise edition
Note:
In case your salesforce.com instance uses Record Types, the "Generate" drop down might be disabled. To enable the "Generate" drop down, the page layout needs to have the right permissions setup. Contact your Salesforce.com admin if you need further assistance in enabling the "Generate" button.
- 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. See the picture below for the column sequence:
Image Removed
Save the opportunity 'page layout'.
- Go to Setup ? Customize ? Product ? 'Page Layout' to move 'QuickBooks Item type', 'QuickBooks Id', 'COGS' and 'OnHand' field to the page layout.
...
- Open QuickBooks and go to Customer Center
- Edit or create a new Customer
- Go to Edit Customer -> Additional Info -> Define Fields and create a new label as – OpportunityId (this is case-sensitive)
...
- Login into dbsync by following the http://dbsync01.appmashups.com/dbsync2/login.m
...
- Once logged in, you go to Library. The Library contains a set of pre-configured setup. Select the one that suites your requirements. For example, you can select the process "Salesforce QuickBooks: Bidirectional" ad Click on "Add".
...
- Select the Salesforce Tab
- Enter Username and password
- Make sure you enter your Salesforce Security Token at the end of the password.
...
- Once "Add" is selected, click on the select the QuickBooks Tab
- Enter Full path to your QuickBooks file
- If the PDL section is empty, then enter the first file in the process list below which would be in the form of "processdefinition_XXX.xml"
- Log Level should be "OFF" unless you want to debug your integration. If Log Level is "ALL" and an email address is provided, then all the logs will go to that email address after each run of the integration.
- Click on "Save". You have now setup dbsync to connect.
...
- Now we have to connect to the QuickBooks WebConnector.
- Start QuickBooks WebConnect by going to Windows Start->All Programs->QuickBooks->WebConnector
- On the above DBSync – QuickBooks Setup screen click on the "Configuration Link"
- "Configuration Link" will download a QWC file specific for this integration and will install itself in the QuickBooks WebConnector.
- Open the QuickBooks file entered so that we can start the process of connecting the QBW file with dbsync.
...
- Click Open with "QuickBooks Web Connector"
Image Removed
- Click OK to Authorize the New Web Service to connect to QuickBooks
...
- Enter password. Note – this is password for DBSync, the one you used to login into DBSync site and not salesforce.com.
- Click on the Status, and QuickBooks WebConnector will ask you to save the password. Click Yes.
- Now your WebConnector is connected to DBSync and Salesforce.
...
- Login to Salesforce.com
- Select the Opportunity which you want to create an Invoice
Image Removed
- Add Products to the Opportunity
- Set the Close Date. The Close Date is mapped to the Invoice date
- Set the Contact in the Contact Lookup. It mapped to the Bill Contact Name.
- Select Generate="Invoice"
- Save the Opportunity.
...
- Go to your QuickBooks WebConnector.
- Select the Integration profile that you just connected.
- Click on Update.
- You should now see the invoices created in QuickBooks.
...
If you have problems setting up, please go to
- Salesforce setup - http://www.appmashups.com/dbsyncwk/index.php?title=Dbsync:Adapter_Salesforce
- QuickBooks setup - http://www.appmashups.com/dbsyncwk/index.php?title=Dbsync:Adapter_QuickBooks
...
Configuration | Instructions |
Username | <<Username>> |
Password | <<Password>> |
EndPoint | https://www.salesforce.com/services/Soap/u/14.0 |
Transport.compression | True/False |
sid | As Applicable |
ProxyHost | If you use a proxy server then put <<proxy ip or host>> |
ProxyPort | If you use a proxy server then put <<proxy ip or host>> |
ProxyUserName | If you use a proxy server then put <<proxy ip or host>> |
ProxyPassword | If you use a proxy server then put <<proxy ip or host>> |
acceptGzip | As Applicable |
sendGzip | As Applicable |
...
Configuration | Instructions |
Filename | Point to the complete path to the location of your QuickBooks File. If its empty, the default open QuickBooks will be used in the integration. |
Pdl | Full Processdefinition file name used for Integration. |
Configuration Link | Link to download the file to connect to your QB web Connector. |
DBSync LLC
750 Old Hickory Blvd.
Bldg 2, Suite 150
Brentwood TN 37027
U.S.A
Email
sales@avankia.com
Phone/Fax
1-877-739-2818
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.There are multiple templates, available in our Solutions library, to integrate Salesforce and QuickBooks. Login to your DBSync Account. Click on Process Template tab to find a complete list of Solutions library. Click on view more - on each process template - to find integration details.
Some of the Salesforce and QuickBooks integration templates include:
- Salesforce to QuickBooks (Unidirectional)
- QuickBooks to Salesforce (Unidirectional)
- Salesforce to QuickBooks (Bi-directional)
- Salesforce to QuickBooks Online (Bi-directional)