Contact field mapping

Data between Intacct and Salesforce is synchronized by mapping fields from one application to the other. Use the standard field mappings provided, or create custom mappings between Intacct and Salesforce.

There's a one-to-one relationship between fields in Intacct and Salesforce. You cannot map multiple fields in one application to a single field in the other application.

To view standard and custom field-mappings, go to the Advanced CRM Integration configuration page in Intacct. On the configuration page, use the link in the Field Mapping section of the object that you want to configure.

If a field is inactive in Intacct for either a standard or custom field mapping, it will not sync between Intacct and Salesforce.

After subscribing to the Advanced CRM Integration, configure Intacct to interact with Salesforce.

Pause synchronization

Before configuring synchronization options, Sage Intacct recommends disabling all synchronization with Salesforce while you make synchronization changes.

To turn off all synchronization:

  1. Log in to Intacct as an administrator.
  2. Go to Company > Admin > Subscriptions > Advanced CRM Integration and select Configure.

    Go to Company > Admin > Subscriptions > Sage People Integration and select Configure.

  3. On the Settings tab, deselect the Enable Intacct Salesforce synchronization checkbox and Save.

When you’re done making sync changes, return to the Intacct subscription page and re-enable synchronization.

Contacts standard field mapping

Salesforce Contacts synchronize with Intacct Contacts.

The Advanced CRM Integration adds Bill To and Ship To look up fields on the Account, Opportunity, and Contract records. The lookup fields create relationships to Salesforce Contacts. If Bill To and Ship To contacts is not provided, Intacct automatically creates Contact records in Intacct from the address in Salesforce records. These created Intacct contacts do not sync back to Salesforce.

To open the Contact standard field mapping:

  1. Log in to Intacct as an administrator.
  2. Go to Company > Admin > Subscriptions > Advanced CRM Integration and select Configure.

  3. On the Settings tab, in the Synchronization options > Contacts section, select the Field Mapping Contacts link. The field mapping dialog box opens.

Fields marked with a red asterisk (*) in the following table cannot be overridden using a custom field mapping and are always set to Active. The fields not marked with a red asterisk in this table can have both their Sync Rule and Status changed.Field marked with a red exclamation point (!) can only have their Status changed. The direction of the sync is always from Intacct because these fields are formula fields that are derived from Intacct information. See Change Sync Rule and Change Status for more information.

Intacct Salesforce Sync Rule Status

* Print As

Name To Intacct Active

* Contact Name

ia_crm__Intacct_Contact_ID__c To Intacct Active
Company name Account.Name

Default: To Intacct

Default: Active

First Name FirstName

Default: To Intacct

Default: Active

Last Name LastName

Default: To Intacct

Default: Active

Prefix Salutation

Default: To Intacct

Default: Active

Primary Email Address Email

Default: To Intacct

Default: Active

Primary Phone Phone

Default: To Intacct

Default: Active

Mobile MobilePhone

Default: To Intacct

Default: Active

Mail address Address line 1 MailingStreet

Default: To Intacct

Default: Active

Mailaddress City MailingCity

Default: To Intacct

Default: Active

Mailaddress State or territory MailingState

Default: To Intacct

Default: Active

Mailaddress ZIP or postal code MailingPostalCode

Default: To Intacct

Default: Active

Mailaddress Country MailingCountry

Default: To Intacct

Default: Active

Change Sync Rule

If the Sync Rule of a standard field mapping can be changed, a dropdown menu becomes available for use when you select the field line. Use this menu to select which direction the field syncs. The options are:

  • From Intacct
    The data source for the field is Intacct.
  • To Intacct
    The data source for the field is Salesforce.
  • Bi-directional
    When one field is updated in either application, the corresponding field in the other application is also updated upon sync.
Intacct ID fields, such as Account or Contract ID, cannot be overridden using a custom field mapping, and are always set to Active status.

Change Status

If the Status of a standard field mapping can be changed, a dropdown menu becomes available for use when you select the field line.

Use this menu to deactivate fields you do not need to sync between Intacct and Salesforce. The default setting is Active.

  • Active (default)

    When Active, information for a field is synced between Intacct and Salesforce, depending on the sync direction.

  • Inactive

    When Inactive, information for a field is not synced between Intacct and Salesforce.

Intacct ID fields, such as Account or Contract ID, cannot be overridden using a custom field mapping, and are always set to Active status.

Reset field mapping defaults

If you need to reset field mappings to the default settings, go to More actions > Reset default field mapping. You will be prompted to confirm that you want to reset all your field mappings for a specific area, such as Accounts. After you confirm, all field mappings for the selected area will be restored to their default settings.