Error converting number value in exponential notation

Document created by mike_aronson Employee on Oct 17, 2013
Version 1Show Document
  • View in full screen mode
Error converting a number value in exponential notation (scientific notation) from Salesforce to QuickBooks.
For example:  “There was an error converting the value "1.2345678E7"
 
This data can be converted by editing the XML Profiles that are used in the Map from Salesforce to QuickBooks:

set the Salesforce XML Profile Element’s Data Format Options to:
Data Type = Number and Number Format = "#E0" (without the quotes)

and

set the format for the Quickbooks XML Profile Element’s Data Format Options to:
Data Type = Number and Number Format = "#" (without the quotes).
 
AtomSphere will then convert the representations.

Attachments

    Outcomes