Introduction
- The migration template has been formulated for QuickBooks to Salesforce data migration.
...
- The following section gives you step by step instructions to initiate the migration of your Quickbooks records to Salesforce objects using Salesforce & Quickbooks MigrationBidirectional Process Template.
...
QuickBooks to Salesforce Migration
...
Process
- Go to www.mydbsync.com and register using Register Link on the top right corner of the page.To Add Adapters go to www.mydbsync.com and click on Customer Login.
- Enter your USER NAME Username and PASSWORD Password and click on Sign in, then .
- DBSync Profile will open in the next tab, click on Process Template, scroll to the bottom of the page and navigate to page 2 to select the Salesforce & Quickbooks Migration template as shown in the screenshot below.
Image Removed
- Click on View More Button besides the Template and on the next screen click on Add Now Button to add the Migration Template to your DBSync profile. The below screenshot illustrates the same.
Image Removed
Image Removed
- Once you click on the Add Now button, you will be re-directed to the properties window.
Enter your login information in the properties window for Salesforce and click on validate button to validate the login credentials of Salesforce. Once you receive the message "Connection settings are valid" click on Continue button at the bottom. If you receive the message "Connection settings are invalid" then please check for the following
- Check whether User ID and Password for Salesforce is correct.
- Is there any invalid Network Access Settings.
- Make sure that security token is added in your password (for Salesforce Adapter)
Image Removed
- The validation for the Salesforce adapter is a must for proceeding further in the properties window.
- Click on QuickBooks link from the left Menu to open QuickBooks settings. Enter you QuickBooks Desktop file path in the 'file:' section and click on Save Properties button.
- You can retrieve full path / location of your Quickbooks file by pressing 'F2' key on your keyboard when in Quickbooks 'Home' page as shown below.
Image Removed
- Click on configuration Link at the bottom of the Edit Properties Area. A Pop-up box will appear, asking to open the file with "QuickBooks Web Connector (default)" click on OK button as highlighted below in screenshot.
Image Removed
- Click on OK in the next window (first screenshot below) and on the next window select the option button "Yes, always; allow access even if QuickBooks is not running" and check the check box for "Allow this application to access personal data" and click on continue button (second screenshot below).
Image Removed
Image Removed
- In the Access Confirmation window click on the Done button. And the profile will get added to your QuickBooks Web Connector. A screenshot of the QuickBooks Web Connector is displayed.
Image Removed
- Click on the Advanced Properties on the left column and select Log Level as ALL from the drop down. The below image illustrates the same.
Image Removed
- For Validating the process click on the button Click to Validate Process. This process will check all the Adapter settings, mappings and states for the sync and present you with a report. In the report all the valid actions are marked with a green check icon as and all invalid actions are marked with red minus icon as . If all the actions are valid ( ) then click on continue button at the bottom.
Customer to Account Migration
- Select CustomerToAccount from the left column and enter in the details as required. Hovering your mouse cursor on the blue Question mark icon indicates how to fill-up the fields. Care should be taken to make sure that the data is entered in the prescribed format as it is case sensitive. A simple example is illustrated in the below screenhot
Image Removed
- There are generally four maps for each state as update and upsert as for example the CustomerToAccount has been shown. The maps are for updating the already existing Customer or for creating a new Customer.
Panel |
---|
Global Variables are used to assign the dates to query QuickBooks to pull accounting data. So for example, if you want to migrate data from 1/1/2009 to 1/1/2010, you will need to assign from to end dates accordingly.
|
Items to Product Migration
- Select ItemServiceToProduct from the left column and enter in the details in the same way as illustrated in the above Customer to Acocunt section. A screenshot for the same is shown below.
Image Removed to check if Salesforce & QuickBooks Bidirectional Process Template is added in the profile.
- If Salesforce & QuickBooks Bidirectional Process Template is not included in the profile, go back to home page and then Click on Process Template to see the list of process templates.
- Click on SalesforceQuickBooks:Bidirectional to add this template in the profile.
- Click on Launch, DBSync Profiles will be displayed in the next tab.
- Configure DBSync with QuickBooks Web connector. The detailed step by step process of configuration is shown in the following link. http://help.mydbsync.com/docs/display/dbsync/Configuring+DBSync+with+Quickbook+WebConnector
- Based on the requirement appropriate steps must be enabled before running the integration.
- To migrate QuickBooks Customer to Salesforce Accounts, select CustomerToAccount from the left column. In the “Last Success Run” edit the date from when you want to Migrate the data and Click on Save.
- To migrate QuickBooks Items to Salesforce Products, select ItemServiceToProduct from the left column. In the “Last Success Run” edit the date from when you want to Migrate the data and Click on Save.
- To migrate QuickBooks Invoice to Salesforce Opportunity, select InvoiceToOpportunity from the left column. In the “Last Success Run” edit the date from when you want to Migrate the data and Click on Save.
- Similar procedure can be followed to migrate Items belonging to Item types , Inventory, Non-Inventory, Discount, Other Charge and Sales Tax.
...
- and the transactions of type Estimate, SalesOrder, SalesReceipt, CreditMemo.