Back

Configure Financial Account/Account Mapping

Contents

Introduction

Map Default Financial Accounts/Accounts in Sales Cloud

Map to a Custom Financial Account Object

Create Fields for Manual Mapping

Manually Map to a Custom Financial Account Object

Manually Map to a Financial Services Cloud Financial Object

 

Introduction

Mapping links a field in Tamarac Reporting with the same field in Salesforce. It allows you to use your existing customized Salesforce objects to view Tamarac data by telling the two systems where each piece of data belongs.

For more information about mapping, see Understanding Mapping in the Salesforce Integration.

This page provides steps to map Salesforce Financial Accounts with Tamarac accounts.

This is Step 4 in Workflow: Configure Mapping. That workflow is the third step in the overall onboarding process.

Map Default Financial Accounts/Accounts in Sales Cloud

To map Salesforce Sales Cloud Financial Accounts with Tamarac accounts:

  1. Open the Tamarac app in Salesforce.

  2. Under Manage Mappings, click Edit in the Client/Contact row.

  3. Shared fields between Tamarac Reporting and your version of Salesforce will be mapped by default in the Tamarac app.

    For a list of all the Contact fields automatically mapped, see Default Financial Account/Account Mapping.

  4. For each Tamarac Reporting configuration field where Not Mapped is selected in the Salesforce field list, click the Salesforce field list and select the Salesforce field that corresponds to the Tamarac Reporting field.

  5. Select Has Junction if the object contains records that are associated with multiple other records. For example, if the same financial account is assigned to multiple Accounts, select Has Junction.

  6. When you are done, click Save.

  7. When you have reviewed the mapping for all the objects, click Send Mappings to send mappings to Tamarac. Click Send Mappings even if you don't make any changes to the default mappings. This creates the mapping link between Tamarac and Salesforce.

Map to a Custom Financial Account Object

If you already have a custom Financial Accounts object in Salesforce, you can manually map Tamarac Reporting fields to your custom object fields. You will choose to do this if you are an experienced Salesforce user and you want to display Tamarac Reporting data in your unique custom Financial Account object fields.

Mapping to a custom Financial Account Object involves two steps:

  1. Create fields for manual mapping.
  2. Manually map to the fields you created.

You'll find instructions for both steps below.

Create Fields for Manual Mapping

To manually create required fields:

  1. Under Setup, search for Object Manager.

  2. On the Object Manager page, search for Financial Account.

  3. Select your custom Financial Account.

    Note

    For Financial Services Cloud, select the Financial Account with the API Name FinServ__FinancialAccount__c

  4. Click Fields & Relationships.

  5. Click New.

  6. To create the Tamarac ID field, choose Text. Fill in the following:

    Characteristic Value
    Field Label Tamarac ID
    Length 20
    External ID Checked

    To create the Updated by Tamarac Integration field, choose Checkbox. Fill in the following:

    Characteristic Value
    Field Label Updated by Tamarac Integration

     

  7. Click Next.

  8. Select Establish Field-Level Security Requirements.

  9. Click Next.

  10. Select Page Layouts.

  11. For each Tamarac required field, select the corresponding Salesforce field you just created.

  12. Click Save.

Manually Map to a Custom Financial Account Object

To manually map Tamarac object fields to your existing Financial Account object fields:

  1. Create new fields in your existing Financial Account object to match required Tamarac fields.

    For more information on what fields are available for integration, see Default Financial Account/Account Mapping.

  2. In Manage Mapping, click Delete next to Financial Account. When you delete the default mapping and a create a new one, the fields will all default to not mapped. All fields will need to be mapped individually by the Salesforce Admin.

  3. Click New Mapping.

  4. Set the Tamarac entity to Financial Account.

  5. Set the Salesforce object to Financial Account.

  6. Map the required fields.

    The following fields must be created and mapped:

    Tamarac Reporting Field Salesforce Field Action
    Financial Account – Tamarac ID Tamarac ID

    Track the ID of the record from Tamarac.

    This field is not mapped by default in a custom financial account object. It must be manually mapped in order for the financial account integration to be enabled.

    Financial Account – Updated by Tamarac Integration Updated by Tamarac Integration

    Track when an update to the financial account in Salesforce is made through integration with Tamarac.

    This field is not mapped by default in a custom financial account object. It must be manually mapped in order for the financial account integration to be enabled.

  7. Click Save.

  8. When all mappings are complete, click Send Mappings.

Manually Map to a Financial Services Cloud Financial Object

To manually map Tamarac object fields to your existing Financial Account object fields:

  1. Create new fields in the Financial Services Cloud object to match required Tamarac fields.

  2. Click New Mapping.

  3. Set the Tamarac entity to Financial Account.

  4. Set the Salesforce object to Financial Account.

  5. Map required and desired fields. For more information on what fields are available for integration, see Default Financial Account/Account Mapping.

    The following fields must be created and mapped:

    Tamarac Reporting Field Salesforce Field Action
    Financial Account – Tamarac ID Tamarac ID

    Track the ID of the record from Tamarac.

    This field is not mapped by default in a custom financial account object. It must be manually mapped in order for the financial account integration to be enabled.

    Financial Account – Updated by Tamarac Integration Updated by Tamarac Integration

    Track when an update to the financial account in Salesforce is made through integration with Tamarac.

    This field is not mapped by default in a custom financial account object. It must be manually mapped in order for the financial account integration to be enabled.

    Primary Owner Not Mapped

    A default primary owner is required in order to save mapping.

     

    For Financial Services Cloud, a primary owner is required for Financial Account data to sync.

     

    For details, see Assign Default Primary Owner for Financial Accounts in Salesforce: Create New Clients, Households, and Financial Accounts.

  6. Click Save.

  7. When all mappings are complete, click Send Mappings.