Integrations & ERP Custom Fields / Salesforce

SalesForce: Configuration

This section outlines how to set up and connect YayPay to your SalesForce® system:

  • Sync Sales Reps from SalesForce (at the account level) to YayPay.
  • To sync Customer Success Reps from SalesForce (at the account level) to YayPay.
  • Retrieve custom fields from SalesForce (at the account level) and sync them with YayPay at the customer level (for all connectors that work with SalesForce, i.e. CSV, Sage Intacct®, NetSuite®, Zuora®, or Acumatica®, API). 
    CRM Custom Fields will sync to YayPay only if a Sales / CS Rep is assigned to the customer.
  • Send a Statement Link from YayPay to SalesForce. The information is attached to the account/customer in SalesForce.
    Before syncing, create a new custom text field on the account level in your SalesForce system in the Object Manager section. The connector will fill this new custom text field with the Statement Link from YayPay.
  • Push Customer's Notes to SalesForce.
    Both customer and invoice notes can be pushed to SalesForce at the customer level.
  • SalesForce integration with YayPay requires that the AR data is first synced from another ERP into YayPay. The synchronization then uses the customer ID as the common identifier, which is obtained after the sync with the ERP and must match the ID of the account in SalesForce. 
  • The integration scope will only include active users in SalesForce such as those who are assigned as Sales Reps to accounts.
  • Before being assigned in YayPay, these users will be created as Sales or CS users in YayPay, based on the defined mapping. The relationship between the users and their assigned roles is visible on the internal Statement page. 
    A SalesForce user cannot be integrated and assigned as both a Customer Success Specialist and Sales Specialist in YayPay at the same time, e.g. House Account shown below.
  • To ensure that your Sales Reps or Customer Success (CS) Reps that will be created as user accounts in YayPay through this integration can access YayPay after the integration, activate Single Sign On (SSO) for each user in SalesForce. 
    This should be done before initiating the sync with SalesForce. If this step is skipped, it may prevent YayPay Sales or CS users from accessing the YayPay platform.
  • Contacts from SalesForce will not be synced.


Configuring SalesForce

This section describes how to configure SalesForce before synchronizing it with YayPay.

Setting Up Your System

Before you start synchronizing data with YayPay, you need to configure certain settings in SalesForce. This section will guide you through the necessary configuration steps.

  1. Log in to SalesForce using your admin credentials.

  2. Switch to SalesForce Classic mode and navigate to the Administration page. On this page, you will find different sections categorized into Administer, Build, Deploy, and Monitor.

  3. Go to the Build section and click on the Create menu. From the sub-menu that appears, select Apps.

  4. On the Connected Apps page, click on the New button.

    The purpose of this Connected App is to ask for permission to access your SalesForce data. It is connected to the SalesForce API using the OAuth protocol. In this context, the external application is called YayPay. For more details on how to create a Connected App, visit the SalesForce Community site.

  5. On the New Connected App page that opens, fill in the provided fields based on the information shown in the accompanying screenshot and name the new app new YayPay Integration.

  6. Navigate to the API (Enable OAuth Settings) section and enter one of the YayPay application URLs into the Callback URL field.

    Use one of these YayPay application URLs for the Callback URL:
    • US Production – https://app.yaypay.com/SalesForce/oauth2/redirect

    • EU Production – https://app1.yaypay.com/SalesForce/oauth2/redirect

    • If you have configured a Subdomain in your Settings | Business page, use the URL that you see after logging into YayPay. For example, https://mycompany.app.yaypay.com/SalesForce/oauth2/redirect where mycompany is the subdomain you configured.

    For YayPay Development environment, use the URL: https://developer.yaypay.com/salesforce/oauth2/redirect.

  7. Click on the Save button to save your changes.

    On the Yaypay integration page that appears, note the Consumer Key and Consumer Secret and save them in a secure location, such as a notepad or a document. You will need this information for configuring YayPay at a later stage.

  8. After creating the connected app, navigate to the Trusted IP Range for OAuth Web Server Flow section and specify the IP addresses from which a user, such as YayPay, will be allowed to log into SalesForce. This helps to ensure that only authorized IP addresses can access your SalesForce account.

    Add the following YayPay IP addresses to Trusted IP Range for OAuth Web Server Flow section:

    Delete

    Note

    If unsure which IP addresses for YayPay you should use, contact our YayPay Support (support@yaypay.com) or your YayPay Account Representative

  9. Authorize all users in the organization by going to the Setup | Manage Apps | Connected Apps section in SalesForce. 
  10. Find the desired app and change the Permitted Users setting to All users may self-authorize
  11. Save the changes to allow all users in the organization to authorize the app themselves. 

Regenerating a Token

  1. Log in to SalesForce and go to Create | Apps section.

  2. On the page that opens, navigate to the Connected Apps section.

  3. Select your connected app, e.g. YP03SF.

  4. On the page that opens, go to the Initial Access Token for Dynamic Client Registration section and click Regenerate.


Configuring YayPay

This section explains how to configure YayPay to connect to your SalesForce.

Setting Up Your Sync Account

To configure YayPay to connect to SalesForce:

  1. Go to Settings | Integrations to check if an ERP system (such as Sage Intacct®, NetSuite®, Zuora®, or Acumatica®) is connected.

    This is because the integration between SalesForce and YayPay requires that the AR data is first synced from the ERP into YayPay. During the synchronization process, the customer ID is used as the common identifier. This customer ID is obtained after syncing with the ERP and must match the account ID in SalesForce.

  2. Go to Settings| Business and navigate to the Sync account level Sales/CS panel.  

  3. For both the Sales and Custom Success options, select the SalesForce option in order to prepare YayPay to sync the Sales and Customer Success Reps from SalesForce.

  4. Delete

    Note

    SalesForce has priority over NetSuite as a source system for syncing sales and customer success data.

    For example, if you set Sales to NetSuite and Customer Success to SalesForce, both sales and customer success data will be synced from SalesForce.

    However, if you select YayPay for Sales and Customer Success options, it means that you will add and/or update the assignment of Sales and CS Reps solely within YayPay, without the integration with SalesForce or NetSuite.

  5. Click SAVE CHANGES to confirm the settings.


Connecting to SalesForce

Continue after Setting Up Your Sync Account by configuring the connection to your SalesForce:

  1. Navigate to Settings | Integrations and select the SALESFORCE tab.

  2. Click CONNECT.

  3. In the SalesForce Authorization dialog that opens, configure the following options.

    Enter values for the following options in this dialog:
    • Consumer Key – Enter the key obtained from your SalesForce setup when configuring the integration with YayPay.

      This field is required for the connection with YayPay to work. In SalesForce, you can find this information by navigating to the Setup | Create menu | Apps | Connected Apps section and clicking on the instance name. On a page that opens, click Manage Consumer Details to view the credentials.

    • Consumer Secret – Enter the secret obtained from your SalesForce setup when configuring the integration with YayPay.

      This field is required for the connection with YayPay to work. In SalesForce, you can find this information by navigating to the Connected Apps section and clicking on the instance name. On a page that opens, click Manage Consumer Details to view the credentials.

    • Custom domain – If you have a subdomain in SalesForce and you want to synchronize it as a subsidiary in YayPay, fill in this field with the value of the Current My Domain URL field from SalesForce.
      The domain name can contain up to 34 characters, numbers and hyphens. As a result, the connector uses this domain for authorization. 

      Additionally, go to Connected Apps section, click on the instance name and in the API (Enable OAuth Settings) section and make sure the Require Proof Key for Code Exchange (PKCE) Extension for Supported Authorization Flows check box is unchecked.

      If you leave the Custom Domain field empty, the connector uses the following URL for authorization:https://login.SalesForce.com/services/Soap/u/38.0.

    • Sandbox – If you have a sandbox account and you want to sync data from it, check this check box before initiating the integration.

  4. Click SAVE to close the panel and initiate an integration attempt (it will close with a successful integration prompt). 

Connector Settings : Mapping Fields from SalesForce®

After completing Connecting to SalesForce, the Connector Settings panel appears.

On this panel, configure the following:

  1. Click on the Load Field Mapping button to load fields from SalesForce.

  2. Map YayPay fields to their corresponding SalesForce equivalents by selecting values from the provided drop-down menus. 
    The values displayed in the drop-down menus are taken from Field Labels in SalesForce. For example:

    Thus, select these Field Labels as values in the drop-down menus:

    Select mapping for the following YayPay fields:
    • ERP ID (required) – Select your ERP ID value from the drop down menu.

      This is a unique identifier that is used to match accounts in YayPay and SalesForce, ensuring accurate pairing between the two systems, i.e. before connecting to SalesForce, enter your YayPay customer ERP ID into the ERP ID field in SalesForce. The ERP ID column in YayPay can be inserted into the Aging Report page, its value is taken from your ERP system.

    • Sales representative – Select the corresponding SalesForce field, for example Sales Representative.

      To sync this user correctly with YayPay, make sure to add the Sales Representative user in SalesForce by clicking on the Edit button in the Account Detail section and then clicking on the Lookup icon located next to the field. In the Lookup dialog that opens, select a user from the list. This user assigned to your account in SalesForce will be then synced at the account level to YayPay.

      Also make sure that you set this user correctly when Setting Up Your Sync Account, i.e. on the Sync account level Sales/CS panel, select SalesForce for the Sales option.

      Additionally, this user must be unique withing all the your YayPay businesses, i.e. the user's email address must be unique across all subsidiaries. This means that you cannot sync the same sales representative for multiple customers within the same business account. However, if you have multiple subsidiaries, you can go to the Settings | Business and navigate to the Linked Subsidiaries panel. Here, you can specify the subsidiaries where the same person can work. This allows you to sync the same sales representative for multiple linked subsidiaries within the same YayPay instance.

      As a result, you will see this user on the CONTACTS tab of the Statement page.

      This field is required if you want to sync custom fields from SalesForce, for example Statement Link.

    • Customer Success – Select the corresponding SalesForce field, for example Customer Rep.

      To sync this user correctly with YayPay, make sure to add the Customer Rep user in SalesForce by clicking on the Edit button in the Account Detail section and then clicking on the Lookup icon located next to the field. In the Lookup dialog that opens, select a user from the list. This user assigned to your account in SalesForce will be then synced at the account level to YayPay. 

      Also make sure that you set this user correctly when Setting Up Your Sync Account, i.e. on the Sync account level Sales/CS panel, select SalesForce for the Custom Success option.

      Additionally, this user must be unique withing all the your YayPay businesses, i.e. the user's email address must be unique across all subsidiaries. This means that you cannot sync the same customer success manager for multiple customers within the same business account. However, if you have multiple subsidiaries, you can go to the Settings | Business and navigate to the Linked Subsidiaries panel. Here, you can specify the subsidiaries where the same person can work. This allows you to sync the same customer success manager for multiple linked subsidiaries within the same YayPay instance.

      As a result, you will see this user on the CONTACTS tab of the Statement page.

      This field is required if you want to sync custom fields from SalesForce, for example Statement Link.

    • Statement Link – Select the custom text field that you previously created on the Account level in your SalesForce system in the Object Manager section. The connector will then fill this custom text field's content with the Statement Link from YayPay.

      The Statement Link is a link leading to your Customer Portal. 

      During each sync, the connector checks and updates the Statement Links in SalesForce. If the Statement Link expires, the connector will remove it from SalesForce during the next sync.

      If the Last Sync Date on the Connector Settings page in YayPay is not updated after the synchronization process, it indicates that the connector will not send the statement link to SalesForce.

      Delete

      Note

      Users cannot have multiple roles within the same business. For example, a user cannot be both a Customer Success Manager (CS) and a Sales Representative (Sales Rep) at the same time. Changing roles is not allowed because the user may be assigned to other customers in the business, which could disrupt their intended role. Therefore, the connector will only synchronize the user with one role.

      If you encounter this log message: Unable to update Account(...) with id {} due to empty Mapping field!, it means the connector couldn't find the mapped field for the Statement Link. Although this will not cause the sync process to fail, it means the client will not be able to find the Statement Link in SalesForce.


    Delete

    Tip

    Consult your SalesForce Admin when looking at the available options displayed in the drop-down list, to help you decide on the mapping.

  3. Optionally, you can also specify the following:
    • Sandbox – If you have a sandbox account and you want to sync data from it, check this check box before initiating the integration with SalesForce.

    • Push the Customer Note to SalesForce – If checked, new notes are pushed to SalesForce using the SalesForce connector. For this to work, you must also create the Notes tab for your account in SalesForce.

      Both customer and invoice notes can be synced to SalesForce, where they will be added at the customer level. For example to push invoice notes to SalesForce, go to the Aging Report page, choose a customer and then select an invoice to add an invoice note. YayPay will then send a request to SalesForce to create a corresponding note at the customer level.

      Delete

      Warning

      If you update a note in YayPay, the SalesForce connector will not update it in SalesForce since it does not support note updates or removals. To ensure the most recent note is in SalesForce, you must manually delete the already existing note in SalesForce and then create a new one in YayPay. As a result, the connector will push this new note to SalesForce during the next sync.

  4. Click SAVE to confirm the settings.

  5. Click Sync at the top of the Connector Settings panel to start the synchronization process in the background.


Once the integration is running, the Sales Rep and Customer Rep assigned to the Account in SalesForce will be synced and found in YayPay. They will be automatically assigned to the corresponding customer in YayPay. Additionally, the Statement Link will be sent as a hyperlink/URL to a field in SalesForce, as shown below:


Delete

Note

To complete the setup in both YayPay and SalesForce, you will require access as an administrator in both systems.

YayPay cannot synchronize the same role as both Sales Rep and Customer Success simultaneously.

Mapping the roles correctly is crucial for the synchronization between YayPay and SalesForce. This ensures that the sync process can accurately find a match between the appropriate Account/Customer in both systems. By assigning the correct Sales Specialist Rep and/or Customer Success Specialist to the Customer in YayPay, the integration can effectively manage the relationship between the two platforms. 

During the synchronization process, your sales users will be automatically set up as sales users in YayPay. To review this, you can navigate to the Settings | User Management page in YayPay. Under the Sales/CS tab, you will find the details of the sales users, including their assigned roles and permissions within the system.

Example  During the sync process, there are several use cases that can occur. Here are a few examples:

  • If multiple customers have the same ERP ID, the last updated Account will be used for mapping in YayPay. 
    1. Account 1 - has a Sales Specialist 1 - Customer ERP ID 455

    2.  Account 2 - has a Sales Specialist 2 - Customer ERP ID 455

    3.  Account 3 - has a Sales Specialist 3 - Customer ERP ID 455

  • If a Note is created within a customer in YayPay, and there are multiple customers that share the same ERP ID, the notes will be created for each Account in SalesForce with the same ERP ID:
    1. Account 1 - Note 1 - Customer ERP ID 455

    2.  Account 2 - Note 2 - Customer ERP ID 455

    3.  Account 3 - Note 3 - Customer ERP ID 455

Delete

Note

  • To complete the setup in both YayPay and SalesForce, you will require access as an administrator in both systems.

    YayPay cannot synchronize the same role as both Sales Rep and Customer Success simultaneously.

  • There is no Custom Field mapping available in this version of the connector.

Delete

Tip

  • The ERP ID field in YayPay represents the unique ID of the Account/Customer obtained from your ERP system through the synchronization process, e.g. NetSuite®, Intacct®, QuickBooks®, API, etc.

  • The "corresponding field" may exist in your SalesForce system if you have created your own internal integration between SalesForce and your ERP system. You can check with your SalesForce Admin to find out the name of this field.
    1. If the ID field does not exist in SalesForce, you will need to create and set it up in SalesForce on the Account record.

    2. Once the field is created, you will need to populate it with the same ID value from your ERP for each Account/Customer in SalesForce. 

      If you do not intend to sync certain Accounts to YayPay, leave the field empty in SalesForce.

  • To find out the values of the ERP ID for each customer in YayPay, add the column ERP ID to the grid on the Aging Report page.

    You can export the Aging Report data to Excel to help you populate the Accounts in SalesForce with the same ID value.



Syncing Customer-Level Custom Fields

To map and sync account-level custom fields from SalesForce to YayPay, follow the steps described in this chapter. The mapped fields will appear as additional fields and values for synced customers from your ERP system in YayPay.

You can also synchronize custom fields from SalesForce to display them at the customer level in YayPay.

To do so:

  1. Go to Settings | Integrations | SALESFORCE tab and make sure that you are connected to SalesForce and have the fields mapped, i.e. that the setup is completed.

  2. Once connected, navigate to Settings | ERP/CRM Custom Fields page to add and map the custom fields from SalesForce. 

    These custom fields are fields from the Account Detail page in SalesForce. For example CUSTFIELD field:

  3. Enter the value for the Source Field Name and YayPay Display Name columns on the ERP/CRM Custom Fields page:

    • The Source Field Name value must be taken from the API Name column in SalesForce.

      To obtain it, navigate to Accounts | Fields and select a specific custom field. On the Account Custom Fields & Relationships page, select the fields value from the API Name column.

      Enter this value into the Source Field Name column:

    • YayPay Display Name is the name under which your custom field will be displayed in YayPay.

  4. Check the SalesForce check box next to the newly added fields to sync a custom field from your SalesForce system instead of your ERP system.

  5. Optionally, you can check the other check boxes such as Display on Statement if you want this custom field from SalesForce to be visible on the Statement page in YayPay or Email Recipient if you want to use this field as a recipient when sending email reminders.

  6. Click SAVE to confirm the settings.

    Once saved, the connector will pull the specified custom fields from SalesForce and display them at the customer level in YayPay. The Customer-level custom fields synced from SalesForce are displayed in the same way as the custom fields synced from other ERPs.

Delete

Note

Customer-level custom fields will be synced with YayPay only if the SalesForce account has the Sales Specialist and Customer Success Specialist fields filled.

In YayPay they are displayed in the CONTACTS tab on the Statement page.

Before starting the sync process, it is necessary to initiate the sync process for the ERP connector. Once that is done, you can proceed to sync SalesForce to retrieve the SalesForce account along with its custom fields. Additionally, it's important to ensure that the Sales Representative or Customer Success Specialist is unique within your biz in YayPay.

During the sync process, there are several use cases that can occur. Here are a few examples:

  • In SalesForce, there are three accounts (Account 1, Account 2, Account 3) that have the same custom field and are associated with a Customer that has ERP ID 455:
    • Account 1 - Custom Field 1 - Customer ERP ID 455 - the last modified date of the account 07/08/2021 10:00:00

    • Account 2 - Custom Field 1 - Customer ERP ID 455 - the last modified date of the account 07/08/2021 10:01:00

    • Account 3 - Custom Field 1 - Customer ERP ID 455 - the last modified date of the account 07/08/2021 10:02:00

    • The ERP Connector will synchronize the custom field of Account 3, which is associated with the Customer ERP ID 455 and has a last modified date of 07/08/2021 at 10:02:00.

  • In SalesForce, there are three accounts (Account 1, Account 2, Account 3) that have different custom fields but are associated with the same Customer that has ERP ID 455:
    • Account 1 - Custom Field 1 - Customer ERP ID 455 - the last modified date of the account 07/08/2021 10:00:00

    •  Account 2 - Custom Field 2 - Customer ERP ID 455 - the last modified date of the account 07/08/2021 10:01:00

    •  Account 3 - Custom Field 3 -Customer ERP ID 455 - the last modified date of the account 07/08/2021 10:02:00

    • In YayPay, you have specified that you want to sync Custom Field 2 and Custom Field 3. After the synchronization process, you will see these custom fields at the Customer Level in YayPay. If you have multiple custom fields with the same name, only the most recent field that was sent to the YayPay Upload API will be stored.

  • If you decide to disconnect SalesForce in Settings | Integrations after the customer-level custom fields have been synchronized, the connector will no longer be able to establish the relationship between the Account ID and Customer ID. As a result, the custom fields that were set up for SalesForce in the ERP/CRM Customs Fields section will disappear after you upload the page.

  • If the connector is unable to synchronize the custom fields from SalesForce, such as when there is no connection due to entering invalid credentials during the connection process in YayPay, the corresponding error will be logged on the LOGS tab of the Integrations page.


Reviewing Sync Results

Through the data mapping and Sync process in YayPay, you can review the outcome of the synchronization in several places:

  • Statement page
  • Aging Report page
  • Settings | Manage Companies page
  • Settings | User Management page


Statement Page

You can find the Sales Specialists and/or Customer Success Specialists assigned to a specific customer on the CONTACTS tab of the Statement page.

The Sales Specialist field will now display the Sales Rep information imported from SalesForce. Additionally, the Sales Specialist field will be made 'read-only', meaning it will be greyed out and users will not be able to make any changes to it to prevent accidental modifications.

You can perform a sample check using the Statement page

To look up a customer, use the Search page in YayPay.

Aging Report Page

You can use the Aging Report to check for a broader data set. You can:

  • Add the column called Sales representative to the grid on the Aging Report page and export the data to Excel.

  • Use the Aging filter called Assigned Sales Representative or Assigned Customer Success and select the appropriate employee.



Manage Companies Page

Based on the number of Accounts/Customers in SalesForce that were mapped to YayPay's ERP ID in the mapping configuration, you will find the outcomes of both linked and unlinked accounts on the Settings | Manage Companies page.


User Management

During the sync process, your sales users will have been automatically set up as sales users in YayPay. To review this, you can navigate to the Settings | User Management page in YayPay. 

Under the Sales/CS tab, you will find the details of the sales users, including their assigned roles and permissions within the system.


Engage your Sales/CS Reps During your Collection Process

With your Sales and/or Customer Success users assigned to the customers in YayPay, you can start involving and collaborating with them during your collection process. For more details, see the following section:

  • To schedule a periodic email notification to all assigned Sales and Customer Success Representatives and provide them with visibility of their Accounts/Customers during the collection process, refer to the Send Aging Notification to Sales/CS Specialists section.
  • To include Sales and Customer Success Representatives as recipients in Workflow Email Reminders for Invoice Overdue Milestones, refer to the Automating your Collection Process section.

Can't find what you need?

Contact our support team support@yaypay.com for help.