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

« Previous Version 5 Current »

Issue :  After turning on Multi currency feature in Salesforce, Product stopped Integrating to Salesforce opportunities  

Description: Since after turning on Multi Currency in an Salesforce org, There are troubles getting products from QuickBooks to be Integrated correctly to opportunities in salesforce. When we add a new currency to one of our products in our standard price book in Salesforce none of the products from QuickBooks will sync over to the opportunity. It just creates an opportunity with no products. 


Resolution : Follow the below mentioned steps and change the mappings as per your QuickBooks file in your project.

Step 1 : Navigate to  Workflow listing page of the project for which you wish to make changes  by Project → processes → workflow.

Step 2 : Click on Edit of the work flow  " OpportunityToInvoice " ,  Replace the reader query from  Advanced Query Builder with the the following query and click on Save & Close button.


SELECT Opportunity.Id,Opportunity.AVSFQB__Primary_Contact__r.FirstName,Opportunity.AVSFQB__Primary_Contact__r.LastName,Opportunity.Owner.QB_SalesRep_ID__c,
Opportunity.AVSFQB__Primary_Contact__r.Email,Opportunity.AVSFQB__Quickbooks_Id__c,Opportunity.AccountId,LastModifiedDate,Opportunity.Account.Id,
Opportunity.Account.CurrencyIsoCode,Opportunity.Account.Name,Opportunity.Account.BillingStreet,Opportunity.Account.BillingCity,
Opportunity.Account.BillingState,Opportunity.Account.BillingPostalCode,Opportunity.Account.BillingCountry,Opportunity.Account.ShippingStreet,
Opportunity.Account.ShippingCity,Opportunity.Account.ShippingState,Opportunity.Account.ShippingPostalCode,Opportunity.Account.ShippingCountry,
Opportunity.Account.Fax,Opportunity.Account.Phone,Name,Description,CloseDate ,(SELECT Quantity,UnitPrice,Description,Opportunity.owner.FirstName,
Opportunity.owner.LastName,Opportunity.Id,Opportunity.CloseDate,PricebookEntry.Name,PricebookEntry.Product2.ProductCode,PricebookEntry.Product2.Name,
PricebookEntry.Product2.Description,PricebookEntry.Product2.Id,PricebookEntry.UnitPrice,PricebookEntry.Product2.AVSFQB__QuickBooks_ItemType__c FROM
OpportunityLineItems) ,Opportunity.Account.AVSFQB__Quickbooks_Id__c,Opportunity.AVSFQB__Generate_Object__c FROM Opportunity where
Opportunity.AVSFQB__Generate_Object__c = 'Invoice'


Step 3 : In the Rules, You will find total of Nine rule and make sure to open the mappings of Rule no 1. 

Step 4 : Add the following mapping to the Rule 

CustomerAddRq/CustomerAdd/CurrencyRef/FullName

=

IF(VALUE("Account/CurrencyIsoCode").equals("USD"),"US Dollar",IF(VALUE("Account/CurrencyIsoCode").equals("GBP"),"British Pound Sterling",IF(VALUE("Account/CurrencyIsoCode").equals("EUR"),"Euro",IF(VALUE("Account/CurrencyIsoCode").equals("CAD"),"Canadian Dollar",""))))

Step 5 : Click on Save & Close button to close the mappings screen, After which make sure to Save the workflow to Save the complete workflow. 

Now, The products from QuickBooks integrate seamlessly to respective Salesforce opportunity.








  • No labels