DBSync Cloud Workflow (iPaaS)

2022

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

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