DBSync Cloud Workflow (iPaaS)

2022

Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Issue:

LineItems are not linking to opportunity in Salesforce From QuickBooks

For Invoice To Opportunity 

Solution:

In the rules OpportunityLineItem upsert 

Earlier mappings for opportunityID



SESSION_GET("OPPID-"+PARENTVALUE("TxnID"))


Then instead of using session-id need to do the following changes.

In Salesforce upsert and update rule, the status writer should be selected as Console adapter on success need to mapped as VALUE("newid") on error map can be mapped as "error in creating opportunity"




Then on OpportunityLineItem upsert rule need to update the mappings for opportunityId as below.


IF(ISEMPTY(VALUE("newid")),LOOKUP("Salesforce","select id from Opportunity where AVSFQB__Quickbooks_Id__c='"+PARENTVALUE("TxnID")+"'"),VALUE("newid"))






  • No labels