2022

Page tree

Versions Compared

Key

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

Introduction

  1. The

...

  1. purpose of

...

  1. Migration is to migrate the user's

...

  1. historical data on a single integration run.

...

  1. Update functionality updates records in QuickBooks and Salesforce.
  • The images below shows some of the snap-shots of the migration profile.

Image Removed

  • The validation for the Salesforce adapter is a must for proceeding further in the synchronization.

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.

...

  1. The section 'QuickBooks to Salesforce Migration Process' below, provides step by step instructions on how to initiate the migration of your Quickbooks records into Salesforce objects using Salesforce & Quickbooks Bidirectional Process Template.


Panel

QuickBooks to Salesforce Migration Process

  1. Go to www.mydbsync.com. Click on Customer Login.
  2. Enter your Username and Password. Click on Sign in.
  3. Click on Launch to check if Salesforce and QuickBooks Bidirectional Process Template is added to the profile.
  4. If Salesforce and QuickBooks Bidirectional Process Template is not included in the profile, go back to the Home page. Click on Process Template to see the list of process templates.
  5. Click on SalesforceQuickBooks:Bidirectional to add this template to your profile.
  6. Click on Launch. DBSync Projects page will display in the next tab.
  7. Click on Projects > SalesforceQuickBooks:Bidirectional > Connectors.
  8. Configure DBSync with QuickBooks Web connector. For a detailed step by step configuration process click on Configuring DBSync with QuickBooks Web Connector link.
  9. Based on the requirements, appropriate steps must be enabled before running the integration.
  10. To migrate QuickBooks Customer to Salesforce Accounts, click on Processes > SalesforceQuickBooks:Bidirectional > turn on CustomerToAccount work flow. In the “Last Success Run”, edit the date from which you want to Migrate the data. Click on Save.
  11. To migrate QuickBooks Items to Salesforce Products, click on Processes > SalesforceQuickBooks:Bidirectional > turn on ItemServiceToProduct work flow. In the “Last Success Run” edit the date from which you want to Migrate the data. Click on Save.
  12. To migrate QuickBooks Invoice to Salesforce Opportunity, click on Processes > SalesforceQuickBooks:Bidirectional > turn on InvoiceToOpportunity work flow. In the “Last Success Run” edit the date from which you want to Migrate the data. Click on Save.
  13. Follow similar procedure to migrate Items belonging to Item types Inventory, Non-Inventory, Discount, Other Charge and Sales Tax and the transactions of type Estimate, SalesOrder, SalesReceipt and CreditMemo.