DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 23

changes.mady.by.user Vishwanath B

Saved on

compared with

New Version Current

changes.mady.by.user Shri Raksha N

Saved on

Key

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

Table of Contents

Panel

Salesforce & QuickBooks BiDirectional Template

  • Go to www.mydbsync.com, click . Click on Customer Login. Enter your User Name Username and Password and click . Then, click on Sign in. Click on Launch to access DBSync Project pageDevelopment Studio.
  • Validate your connection settings for Salesforce & and QuickBooks.
  • Go to workflow Opportunity to invoice, in . In the Rules section, open the map for Sequence No.2 and 2. Then, replace the mapping of VALIDATE ROW from "true" to "false".
  • After making the above changes, DBSync will not create jobs in your QuickBooks.
  • The above procedure can be replicated for other mapping states mappings - like OpportunityToSalesOrder, OpportunityToSalesReceipt, OpportunityToEstimate and OpportuintyToCreditMemo.
  • Open mapping for sequence/rule no. 6 and make the following changes to the source and target mappings.
  • Find the target field "InvoiceAddRq/InvoiceAdd/CustomerRef/FullName" and replace the source code by copy and paste the following: LEFT(VALUE("Account/Name"),41) 
  • Open Mapping for sequence/rule no. 8 and make the following changes to the source and target mappings.
  • Find the target field "InvoiceModRq/InvoiceMod/CustomerRef/FullName" and replace the source code by copy and paste the following: LEFT(VALUE("Account/Name"),41)

Panel

Salesforce & QuickBooks Online Template

  • Go to www.mydbsync.com, click . Click on Customer Login. Enter your User NameUsername and Password and click .  Click on Sign in. Click on Launch to access DBSync Project pagethe Development Studio.
  • Validate your connection settings for Salesforce & and QuickBooks Online.
  • Go to the process SFQB_OpportunityToInvoice, open . Open the workflow OpportunityToInvoice. Then, open the map for Sequence No.2 and replace the mapping of VALIDATE ROW from "true" to "false".
  • Now, open Open mapping for Sequence No 34 and make the following changes to Source and Target Mappings.
  • Find the target field "InvoiceAddRq/InvoiceAdd/CustomerRef/FullName" and replace the source code by copy -pasting and paste 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 & and QuickBooks Online solution template.