DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 5

changes.mady.by.user Eugenio

Saved on

compared with

New Version Current

changes.mady.by.user Avinash Rao

Saved on

Key

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

Overview

DBSync Jumpstart package for Salesforce & QuickBooks Integration is an easy to use application to integrate Salesforce Accounts, Products, Opportunity, Invoice with QuickBooks Customers, Items, Job, Sales Order & Invoice.DBSync is also allows to migrate historical QuickBooks data into Salesforce or vice versa. It provides Bi-directional sync solution template. You can buy the template to do receivable automation between your Salesforce CRM and QuickBooks accounting software. The solution template acts as a plug & play solution. It automates integration of Customers, Orders & Invoicing with your QuickBooks software based on incremental updates and increased visibility across both the systems.
The solution provides Bi-directional data-exchange with a pre-built field-to-field mappings along with flexibility for complex and dynamic custom mapping capability. It  DBSync also has an automatic online update, enabling all . This enables DBSync customers to enjoy all the product updates and features with every new release.

Using the OAuth protocol for connecting to Salesforce, makes it highly secure and easy to use.


               

Data Flow

Image Modified

Below steps will allow the user to setup DBSync for integration between Salesforce and QuickBooks.

...

2.       Login to DBSync using the provided USERNAME Username and PASSWORDPassword.

3.       Once logged in, you will be able to see the landing page. Click on the “Development Studio” button located on the top right side of the page.

4.       The next page will the comprises of working environment for all DBSync Projects, Processes and Workflows.

...

7.       Click on the “Connectors” from the Left Menu and configure the Salesforce connector using your Salesforce Account credentials and Click on SAVE once its Authenticated.

8.       Once authenticated       Next, click on the available Process by clicking on the “Processes” link in on the Left Menu.

9.       On the process , page, users you will see the “Workflows” available for integration.

...

1.       Accounts to Customer: This data flow will Workflow will be unidirectional integrating data from Salesforce to QuickBooks. Salesforce Accounts will be integrated as QuickBooks Customers.

Steps:

  •  Switch Switch ON the process and Accounts to Customer Workflow and click on EDIT button placed along side of the next to he workflow.
  • In On the EDIT screen, the TRIGGER sections will allow the users to Query data from Source (Salesforce) and the RULE section allows will allow user to configure the mappings for the target System (QuickBooks)Click .
  • Once the mappings are finished, click on SAVE WORKFLOW located on the TOP RIGHT side of the page, once the mappings are finished.

 

2.       Quote to Estimate:  This data flow will Workflow will be unidirectional integrating data from Salesforce to QuickBooks. Salesforce Quotes and Quotes Line Items will be integrated as Estimates and Line items in QuickBooks.

...

  • Switch ON the Quotes to Estimate process and Workflow. Then, click on the EDIT button placed along side of next to the workflow.
  • In On the EDIT screen, the TRIGGER sections will allow the users to Query data from Source (Salesforce) and the RULE section allows will allow users to configure the mappings for the target System (QuickBooks).
  • Click Once the mappings are finished, click on SAVE WORKFLOW located on the TOP RIGHT side of the page, once the mappings are finished.


3.       Opportunity to Sales Order (QBDQuickBooks Desktop): This data flow will Workflow will be unidirectional integrating data from Salesforce to QuickBooks. Salesforce Orders Opportunity and Order Opportunity Line items will be integrated as Sales Order and Sales Order Line Items in QuickBooks.

...

  • Switch ON the Opportunity to Sales Order process and Workflow. Then, click on the EDIT button placed along side of next to the workflow.
  • In On the EDIT screen, the TRIGGER sections will allow the users to Query data from Source (Salesforce) and the RULE section allows will allow users to configure the mappings for the target System (QuickBooks).
  • Click Once the mappings are finished, click on SAVE WORKFLOW located on the TOP RIGHT side of the page, once the mappings are finished.

 

4.       Salesforce Invoice Opportunity to QB QuickBooks Invoice: This data flow will Workflow will be unidirectional integrating data from Salesforce to QuickBooks. Salesforce Invoice Opportunity and Invoice Opportunity Line items will be integrated as Invoice and Invoice Line Items in QuickBooks.

...

Steps:

  • Switch ON the Salesforce Invoice Opportunity to QB Invoice process and QuickBooks Invoice Workflow. Then, click on EDIT button placed along side of next to the workflow.
  • In On the EDIT screen, the TRIGGER sections will allow the users to Query data from Source (Salesforce) and the RULE section allows will allow users to configure the mappings for the target System (QuickBooks).
  • Click Once the mappings are finished, click on SAVE WORKFLOW located on the TOP RIGHT side of the page, once the mappings are finished.

5.       QB QuickBooks Payments to Salesforce Invoice: This data flow will Workflow will be unidirectional integrating data from QuickBooks to Salesforce. QuickBooks Payments applied against the Invoice will be integrated as Salesforce Invoices/ Invoice Payments.

Steps:

  • Switch ON the QB QuickBooks Payments to Salesforce Invoice process and Workflow. Then, click on EDIT button placed along side of next to the workflow.
  • In On the EDIT screen, the TRIGGER sections will allow the users to Query data from Source (Salesforce) and the RULE section allows will allow users to configure the mappings for the target System (QuickBooks).
  • Click Once the mappings are finished, click on SAVE WORKFLOW located on the TOP RIGHT side of the page, once the mappings are finished.

 

6.       QB QuickBooks Items to Salesforce Products (Types = Inventory, Service, Non-Inventory): This data flow will be unidirectional integrating data from QuickBooks to Salesforce. QuickBooks Items will be integrated as Salesforce Products as flat structure.

Steps:

  • Switch ON the QB QuickBooks Items to Salesforce Products process and . Then, click on the EDIT button placed along side of next to the workflow.
  • In On the EDIT screen, the TRIGGER sections will allow the users to Query data from Source (Salesforce) and the RULE section allows will allow users to configure the mappings for the target System (QuickBooks).
  • Click Once the mappings are finished, click on SAVE WORKFLOW located on the TOP RIGHT side of the page, once the mappings are finished.

 

Running the Sync.

  • QuickBooks Online: Integration can be initiated using a “RUN NOW” button located alongside next to each workflow in DBSync; or, it can be scheduled in DBSync Scheduler.
  • QuickBooks Desktop: Integration can be initiated or scheduled using QuickBooks Web connector.