Why Do the Record IDs in Salesforce and NetSuite Not Match in My Custom Data Flow?

The Salesforce IDs that are being synced to NetSuite are different than the IDs that are visible in Salesforce, yet, they reference the same record. Typically, a Salesforce ID is 15 characters long, but Celigo references a Salesforce ID that is amended with an additional three digits (Ex: Salesforce ID = a6614000000PCAq, but syncs to NetSuite as a6614000000PCAqAAO).  This may cause problems when you try to sync existing records between the two systems using a custom data flow.

There are two versions of every record ID in Salesforce:

• a 15 digit case-sensitive version which is referenced in the UI 
• an 18 digit case-insensitive version which is referenced through the API 

The last 3 digits of the 18 digit ID are a checksum of the capitalizations of the first 15 characters.  This ID length was created as a workaround to legacy systems that were not compatible with case-sensitive IDs. The API will accept the 15 digit ID as input but will always return the 18 digit ID. To easily convert a 15 digit record ID to an 18 digit record ID, click here.