DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 24

changes.mady.by.user Vishwanath B

Saved on

compared with

New Version 25

changes.mady.by.user Vishwanath B

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3
Table of Contents
Panel

Salesforce & QuickBooks BiDirectional Template

  • Go to www.mydbsync.com, click on Customer Login. Enter your User Name and Password and click on Sign in. Click on Launch to access DBSync Project page.
  • Validate your connection settings for Salesforce & QuickBooks.
  • Go to workflow Opportunity to invoice, in the Rules section open the map for Sequence No.2 and replace the mapping of VALIDATE ROW from "true" to "false".
  • After making above changes, DBSync will not create jobs in your QuickBooks.
  • The above procedure can be replicated for other mapping states like OpportunityToSalesOrder, OpportunityToSalesReceipt, OpportunityToEstimate and OpportuintyToCreditMemo.
Panel

Salesforce & QuickBooks Online Template

  • Go to www.mydbsync.com, click on Customer Login. Enter your User Name and Password and click on Sign in. Click on Launch to access DBSync Project page.
  • Validate your connection settings for Salesforce & QuickBooks Online.
  • Go to the process SFQB_OpportunityToInvoice, open the workflow OpportunityToInvoice, open the map for Sequence No.2 and replace the mapping of VALIDATE ROW from "true" to "false".
  • Now, open mapping for Sequence No 3 and make the following changes to Source and Target Mappings.
  • Find target field "InvoiceAddRq/InvoiceAdd/CustomerRef/FullName" and replace the source code by copy-pasting the following.
Code Block
IF(ISEMPTY((String)SESSION_GET("CreateJobFlag")),LEFT(VALUE("Account/Name"),41),
LEFT(VALUE("Account/Name"),41)+":"+ LEFT(VALUE("Name"),41))
  • This completes disabling of Jobs for your Salesforce & QuickBooks Online solution template.