Scope
Will lengthy customer IDs in Chargebee get cut off when synced to Intacct?
How can the character limit of Intacct integration be overcome?
Summary
By default, the Chargebee-to-Intacct integration supports only the first 17 characters of the customer ID in Chargebee to be synced over to Intacct. If there are more than 17 characters of the customer ID in Chargebee, only the first 17 characters will be synced to Intacct. This is the standard behaviour.
If you wish to retain the entire customer ID, we can help you map the customer ID field in Chargebee to a custom field in Intacct where the 17 character limit does not exist- contact support@chargebee.com for more details.
Solution
If the customer ID is Hr5511rRKlNuLS1T2O in Chargebee, and if this is a new record being synced to Intacct, the ID in Intacct would be: Hr5511rRKlNuLS1T2, meaning only 17 characters of the customer record in Chargebee would be synced over to Intacct.
More context on how our integration with Intacct works today.
Intacct has a character limit of 20 characters. But our integration will cut it off at 17 characters.
For example let's say we have a customer in Chargebee with the id “Hr5511rRKlNuLS1T2” (17 character).
Let's say the same customer already exists in Intacct as well, but Chargebee tries to sync the same customer again (as per the integration).
CB syncs another customer with the same id “Hr5511rRKlNuLS1T2“; then CB will send it across as “Hr5511rRKlNuLS1T2_2” to avoid a duplicate error.
In order for us to add the suffix _2 etc, our integration will utilise the last 3 characters of the customer id.
To bypass the above limitation, we can help you map the customer ID field in Chargebee to a different field in Intacct, so that the full length of the customer ID in Chargebee is synced to Intacct.
a. We can map the customer ID to a different field in Intacct to avoid cutting off the customer ID at 17 characters.
b. To do so, first you need to create a filed in Intacct, for "Customers", and the field should be of type: String/Text
c. Once created, you need to provide the destinationFieldID of the custom field in Intacct.
We will then map the customer ID field in Chargebee to the custom field that you share with us.