- Click on Customer Login in at www.mydbsync.com and enter . Then, enter the registered user name username and password to sign in, then click . Click on Launch to Access DBSync Project Console.
- In the Project console, click on Template Library on the left panel. List A list of DBSync will be displayed.
- Choose your template according to the connectors Connectors you have. In this Demo, I will be using the "Salesforce & and QuickBooks Bidirectional" Template. Click on Try Now Button next to SalesforceQuickBooks: BiDirectional.
- A new Project will be added in the Project section with the Template Name.
- Click on the template SalesforceQuickBooks: Bidirectional. Then, click on the connectors. You should have Salesforce & and QuickBooks connectorsConnectors. Ensure Make sure that both the connector Connector settings are validated.
- You can refer the below link for the details on configuring DBSync with Salesforce and QuickBooks Desktop. to the http://help2.mydbsync.com/docs1/display/dbsync/Configuring+DBSync+with+Quickbook+WebConnector link for the details on configuring DBSync with Salesforce and QuickBooks Desktop.
- Go to the newly added project Project SalesforceQuickBooks: Bidirectional, click . Click on the available process.
- You will see a list of workflows. Each workflow will have the Trigger & Rules.
- Default mappings are listed in the rule of each Rule. You also have the capability to create custom mappings as per your business.
- You can choose to use, or not to use, a specific workflow. Status of the workflow can be either On or Off. Based on the business process & and the integration requirement, you can choose which one to keep OnON. If you want to keep the dataflow moving from Salesforce Opportunity to QuickBooks Invoice, OpportunityToInvoice status should be ON.
...
- The following workflows should be kept on ON based on the integration requirement to keep Salesforce as a master database for uni-directional integration. :
- AccountToCustomer
- ProductToItemService
- ProductToItemInventory
- ProductToItemNonInventory
- ProductToOtherCharge
- ProductToDiscount
- OpportunityToInvoice
- OpportunityToEstimate
- OpportunityToSalesOrder
- OpportunityToSalesReceipt
...
- The following workflows should be kept on ON based on the integration requirement to keep QuickBooks as a master database for uni-directional integration. :
- CustomerToAccount
- ItemServiceToProduct
- ItemInventoryToProduct
- ItemNonInventoryToProduct
- ItemDiscountToProduct
- ItemOtherChargeToProduct
- InvoiceToOpportunity
- InvoiceToInvoice
- EstimateToOpportunity
- SalesOrderToOpportunity
- SalesReceiptToOpportunity
Run Integration
- Once you are done with the mappings, you can run the integration using the scheduler or QuickBooks WebConnector.
- If you are using QuickBooks Webconnector Web Connector 'Auto RunAutoRun' in QB web connector QuickBooks, then, the Web Connector must be used to run integration on a fixed interval. To run the integration manually, 'Update Selected' in QB web connector QuickBooks Web Connector must be used.
- You can also use DBSync scheduler to schedule the Integration Run. The details are available in the following link http://help2.mydbsync.com/docs1/display/dbsync/SchedulerScheduler process is applicable for Only QuickBooks Online Connector/adapter.
{"serverDuration": 77, "requestCorrelationId": "a1110036143d8543"}