2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Issue: 

1. We cannot update the QB Id’s based on the name from QB to SF if the name contains special characters.

2. We cannot link any Object based on name if the name contains special characters.

Description:

Salesforce does not allows to query the field name if it contains any special characters(‘,/,\) in it. Hence we need to escape the special characters, so that the respective field can be queried.

Image Removed

Figure 1

Image Removed

Figure 2

Resolution:

  1. Open the mapping and identify the field in QuickBooks that needs to be linked and contains special character(s).
  2. Pass the value of the field by using the ESCAPESPECIALCHARACTER() function and save it.

Examples:

  1. TLOOKUP("select Id from Account where Name='"+ESCAPESPECIALCHARACTER(VALUE("Name"))+"'")
  2. LINK("Account","select Id,AccountId from Opportunity","Name",ESCAPESPECIALCHARACTER(VALUE("CustomerRef/FullName")),"Opportunity")


Image Added

1-First Login into your Microsoft Dynamics 365 CRM and then click on Settings.

Image Added

       

 2-Then in settings click Solutions options under customization.

Image Added

 3-Then solution package window will open where we need to click on Import option.

Image Added

4-Then Select Solution Package Pop up window will open. Here we need to Browse for the DBMSQB3.0 Manged solution file.


Image Added

5-Then after selecting the file click on next and it will start importing the package. Once the package is imported you can see the solution package installed as below image.



Image Added