SIMPLIFY SALEFORCE AND QUICKBOOKS INTEGRATION: Salesforce.com to GreatPlains Bidirectional
...
- Accounts and Contacts as Customer
- Products as Items
- Opportunity as Receivables Transactions ,
...
KEY BENEFITS
- Seamless transfer.
- Ability to implement automated workflows
- Reduced turn-around time.Use case
- DBSync for Salesforce.com & GreatPlains provides an easy to use application to synchronize Accounts, Contacts, Products and Opportunities to GreatPlains Customer, Products and Transactions .
- The application provides a pre-built field map along with a flexible advance mapping capability and configuration capability. The application also has an automatic online update so you never have to manually upgrade your application.
Process Map
...
Salesforce
...
s
...
Account
...
Customer
...
Opportunity(Without Opportunity Line Item)
...
Receivable Transactions(Sales/Invoices,services/Repairs,CreditMemo)
...
SOP Transactions(Quote/Order/Invoice)
...
Product/PriceBook
...
Sales Inventory/ Services/Discontinued/Kit/Flat Fee/Disc Charges
...
GreatPlains | Salesforce.com |
Customer | Accounts |
Customer | Contacts |
SalesInventory | Products |
Services | Products |
Flat Fee | Products |
Discontinued | Products |
Kit | Products |
Misc Charges | Products |
Receivable Transaction(Without Line Item) | Opportunity |
SOP Transactions(With Line Item) | Opportunity/LineItem |
Business Process Flow
...
Salesforce
- Get the following App from AppExchange .
https://login.salesforce.com/?startURL=%2Fpackaging%2FinstallPackage.apexp%3Fp0%3D04t9000000094vw&crc=1
...
- Go to Setup ? Customize ? Product ? 'Page Layout' to move 'GPProductID, 'Location Code, 'Product Type' and 'Unit Of Measurement','PriceLevel', 'Class ID' and 'Currency ID' field to the Product layout.
At this point, you have successfully completed your Salesforce.com instance setup.
...
Install and setup Microsoft Dynamics GP 10.0
Install and setup SQl Server Management Studio.
Install and setup eConnect SDK.
Dbsync Installation and Setup
- Download the DBSync exe file from the link of your email from DBSync Team and Install it.
...
DBSync Installation and Setup
- Download the DBSync .Exe file from email which you have received at the time of registration and also the .Exe is available in DBSync home page as shown below.
Image Added
2. Follow the steps for installation which are self explanatory in nature.
If you have selected the option 'Set DBSync as Service' during installation, then DBSync would be running as a Windows Service in the background. If you have not opted to select this, then you can start DBSync from your Start Up ? Program Files ? DBSync > Program Files > DBSync Integration Suite.Dbsync
DBSync Configuration
- Login into dbsync by following the httphttps://localhost:8080/dbsync2dbsync05.appmashups.com/appcenter/login.m in your internet browser. You can provide the username and password which is been provided to you.
- Go to Library Section and add the template SalesforceGreatPlains:BiDirectional.
...
- has been emailed during registration with us.
DBSync as Windows Service
- Go to Windows Startup
- Click on "DBSync Integration Suite"
- Click on "Set as Service"
Alternatively you can follow the following article to configure installed Tomcat as a Windows service
•http://tomcat.apache.org/tomcat-5.5-doc/windows-service-howto.html
Tomcat and IIS: Install & Setup
• http://tomcat.apache.org/connectors-doc/webserver_howto/printer/iis.html
• http://onjava.com/pub/a/onjava/2002/12/18/tomcat.html
• http://www.prasannatech.net/2008/07/integrating-iis-with-tomcat.html
Load Balancing and best Practices
• http://people.apache.org/~mturk/docs/article/ftwai.html