2022

Page tree

Versions Compared

Key

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

Table of Contents

Panel

Salesforce &

...

QuickBooks BiDirectional Template

  • Go To to www.mydbsync.comSelect . Click on Customer Login. Enter your User Name Username and Password and click Login Button.
  • Click on Launch in the Console area of MyHome Page.
  • In DBSync console click on Quick Start Link.

...

  • . Then, click on Sign in. Click on Launch to access Development Studio.
  • Validate your connection settings for Salesforce . Enter Your Salesforce Username and Password and click on Validate button.

...

  • Go to QuickBooks configuration, enter you QuickBooks file path and click on Save Properties Button.

...

  • Go to workflow Opportunity to invoice configuration and uncheck the check box for mapping "Sync Opportunities as jobs in QuickBooks"

...

  • After making . In the Rules section, open the map for Sequence No.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.

Salesforce & Quickbooks Online BiDirectional Template

Disabling jobs in Quickbooks Online template requires one to access the dbsync console as it cannot be disabled via Quickstart window. The following section illustrates the same.

  • Login to your dbsync console as shown in the above Quickbooks desktop section.
  • Click on Manage--> edit link as shown below.
  •  
  • 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 on Customer Login. Enter your Username and Password.  Click on Sign in. Click on Launch to access the Development Studio.
  • Validate your connection settings for Salesforce and QuickBooks Online.
  • Go to process SFQB_OpportunityToInvoice. Open the workflow OpportunityToInvoice. Then, open the map for Sequence No.2 and replace the mapping of VALIDATE ROW from "true" to "false".
  • Open mapping for Sequence No 4 and make the following changes to Source and Target Mappings.
  • Find the target field "CustomerRef" and replace the source code by copy 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 Jobs for your Salesforce and QuickBooks Online solution template.