Code Mapping (Existing Users) User Guide

Prev Next

Transform Copilot forms include key account details such as Issued By, Administered By, and Payee, which must be accurately matched to existing CRM account records.

Ideally, this matching process happens automatically. However, because matching solely based on account names is often unreliable due to duplicates, inconsistencies, or name variations, automatic matching is not feasible. To address this, Transform Copilot provides a manual matching capability. This ensures users can accurately link the form data to the correct CRM accounts, maintaining data quality and supporting efficient contract management workflows.

Contract Ingestion

Refer to the Transform Copilot User Guide for detailed instructions on ingesting a contract document using Transform Copilot.

When you ingest a contract document using the Transform Copilot Ingest option, important details like the Contract Number, Solicitation Number, Dates, Addresses, and Codes are automatically extracted and mapped to the right fields in a CRM Contract record.

Fields such as Issued By, Administered By, Payee, and Ship To each represent an account and its location. Next to each account name, a unique code (CAGE Code or DODAAC) is provided for identification.

When the Create Contract button is clicked, a new contract record is created, and an automated process is triggered to search for matching site records using the unique codes extracted from the contract document, such as the Issue Code, Pay Code, and Facility Code. If matching site records are found, the system automatically creates a corresponding Contract Site record under the contract, links the contract to the appropriate site account, and maps the site details to the relevant fields within the contract.
contract header 1.png

Auto Matching of Mapped Codes

If matching site records are found, the system automatically creates a Contract Site record, links it to the contract, and fills in the site details.

To view the auto matched site details:

  1. Login to your Salesforce instance.

  2. Navigate to Contracts and open the relevant Contract record.

  3. Go to Details > Client & Prime Info.
    The Client Information, Prime Information, and Contract Sites are updated as per the auto match process.

    NOTE

    The auto-match process uses unique codes (CAGE code or DODAAC) to identify the correct accounts and automatically update the corresponding CRM fields with accurate data.

    auto code mapped - Copy.png

Manual Matching of Unmapped Codes

If matching site records are not found during the automated process, you must manually match the extracted codes to the correct accounts in the CRM.

To manually match the unmatched codes:

  1. Login to your Salesforce instance.

  2. Navigate to Contracts and open the relevant Contract record.

  3. Click Click here to complete the process.

    NOTE

    This option is visible only when you have unmapped codes from the Transform Copilot ingested contract.


    click here.pngA list of all unmapped codes from the Transform Copilot ingested contract are displayed.
    all codes1.png

  4. To map the unmapped codes, search for the account in the Search Account field.

    • If you do find the account, select the account from the list. The screen below shows an example where the Administered by account name, US Dept of Homeland Security Office of Procurement, is available in the search results.
      account available.png

    • If the account is not found, you will need to create a new one.

      NOTE

      Create a new account only if the account is not listed in the Search Accounts results.

      To create a new account:  

      1. Click the Create New Account icon.create new account1.png

      2. The record type is by default set to Federal (Hierarchy of Federal Agencies). Click Next to continue.create new account2.png

      3. Enter the Account Name. Optionally, fill in other available details, then click Save.

        TIP
        You can copy and paste the account’s name and address from the information displayed at the top of the screen.

        create new account3.pngThe new account is created.
        create new account5.png

  5. After adding the account, either by selecting from the search result or creating a new account, create a site by entering the address in the Street, City, State, and Zip Code fields.

    TIP

    You can copy and paste the account address from the information displayed in the Name and Address column.

    Notes:

    • The Create Site button is enabled by default for users with access to create accounts and sites.

    • It is recommended to create a site for the account, so that the next time this site appears in the form, it will automatically match.

  6. Once all unmapped codes from the Transform Copilot ingested contract are mapped, click Save.
    all accounts added.pngThe contract's Client & Prime info section is updated.
    contract full view after adding acc.png

Related Documents

Transform Copilot User Guides