DBSync Cloud Workflow (iPaaS)

2022

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

For Invoices to sync based on particular customer type do the following changes:

Go to the workflow:” Invoices to Opportunity”

1st Rule: SF   UPSERT AVSFQB_INVOICE__C

VALIDATE ROW : IF(ISEMPTY(VALUE("OpportunityId")),IF(VALUE("CustomerRef/FullName/CustomerRet/CustomerTypeRef/FullName").equals("Retail"),"true","false"),"false")

Here “Retail” is the customer type we can change it according to our requirement.


2ND RULE: SF UPDATE OPPORTUNITY


VALIDATE ROW: IF(VALUE("OpportunityId")!="",IF(VALUE("CustomerRef/FullName/CustomerRet/CustomerTypeRef/FullName").equals("Retail"),"true","false"),"false")

Here “Retail” is the customer type we can change it according to our requirement.


3rd RULE: SF UPSERT OPPORTUNITYLINEITEM

VALIDATE ROW:

IF(ISEMPTY(VALUE("OpportunityId")),IF(VALUE("CustomerRef/FullName/CustomerRet/CustomerTypeRef/FullName").equals("Retail"),"true","false"),"false")

Here “Retail” is the customer type we can change according to our requirement.


4th RULE: SF UPSERT OPPORTUNITYITEM

VALIDATE ROW:

IF(ISEMPTY(VALUE("OpportunityId")),IF(VALUE("CustomerRef/FullName/CustomerRet/CustomerTypeRef/FullName").equals("Retail"),"true","false"),"false")

Here “Retail” is the customer type we can change it according to our requirement.

Now invoices will sync of customer type “Retail”


  • No labels