Page History

Issue: Insertion of Invoice to Opportunity is done based on QuickBooksID (AVSFQB__Quickbooks_Id__c).

...

Image Removed

Fig1: Mapping

Image Removed

Fig2: Logs

Solution:

...

Open Invoice to Opportunity workflow.

...

Open first rule and replace existing mapping for AccountID as shown below:

Image Removed

Fig3: Updated mapping

Existing mapping:

...

SYNCING INVOICES BASED ON CUSTOMER TYPE

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

Image Added

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.

2ND RULE: SF UPDATE OPPORTUNITY

Image Added

VALIDATE ROW: IF(VALUE("OpportunityId")!="",IF(VALUE("CustomerRef/FullName/CustomerRet/

...

...

...

Updated mapping:

...

,"false")

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

3rd RULE:SF UPSERT OPPORTUNITYLINEITEM

Image Added

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

Image Added

VALIDATE ROW:

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

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

Now invoices will sync of customer type “Retail”