2022
Issue:
Mapping a custom field, present under Customer in QuickBooks, couldn’t be mapped into the Custom field present at Salesforce.
The main reason was Type conversion mapping. Custom field type was String in QuickBooks and it was of Type Double in Salesforce.
The following screen shot displays the custom field of Type String in QuickBooks that has to be mapped to another custom field of Type Double in Salesforce.
Solution:
I used the following mapping query in order to convert the String to Double in Salesforce instance.
VALUE("DataExtRet[DataExtName[1]/text()='Item Code']/DataExtValue")
The value in the custom field was converted successfully and synchronized to Salesforce instance as shown below
The converted value is shown in Salesforce.