Conversion of a String Value Type Present in QuickBooks to Double Value of Type at Salesforce

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.