BeyondERP.Newsletter
Menu

Setup page · Sales and marketing

Relation types

A setup page where you set up the relation types used to classify business relations such as prospects, and see which table each type's records are kept in.

Used by
Marketing manager, Information technology manager, Sales manager
Business process
Identify and qualify leads
Menu item
smmBusRelTypeGroup
Main table
smmBusRelTypeGroup
Data entity
SalesProspectRelationTypeEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you set up the relation types used to classify business relations such as prospects, and see which table each type's records are kept in.
What you do hereUse this page to set up the relation types used to classify prospects, and to see which table each type's records come from. The prospect type set on Sales and marketing parameters must be one of these types.
ExampleBEAT keeps the type Prospect with table source Relation table as its default prospect type, and adds B2B prospect for trade customers. In the prospect-to-cash setup, the same type is entered as Default relation type on Accounts receivable parameters.
Relation types page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processIdentify and qualify leads
Menu pathSales and marketing › Setup › Prospects › Relation types
Set up firstSales and marketing parameters Microsoft Learn
Used next byAll prospects Microsoft Learn
Related pagesAccounts receivable parameters Microsoft Learn Customer groups Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Relation types1 screen
  1. Screen 1

    Check the relation types

    Go to Sales and marketing > Setup > Prospects > Relation types

    1. Review the delivered relation types and the table each one comes from
    2. Add a new type only when you need another kind of business relation, then enter the type, description and table source and select Save
    1TypeB2B prospect
    1DescriptionB2B prospect
    1Table sourceB2B prospect
    Check the relation types (zoomed on the outlined fields)
    Show the full screenCheck the relation types
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Prospects > Relation types.
  2. Review the Type, Description and Table source columns for each relation type.
  3. Select New to add a relation type, and enter the Type and Description.
  4. Go to Sales and marketing > Setup > Sales and marketing parameters and, on the Prospects tab, set Type to the prospect type and check that Table source is Relation table.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
TypeThe code of the relation type, for example Prospect. It is the value set in the Type field on the Prospects tab of Sales and marketing parameters.Microsoft Learn ProspectTypeId
DescriptionA short description of the relation type.Checked in Dynamics 365B2B prospectTypeDescription
Table sourceThe table that records of this relation type are kept in. For the prospect type used with prospect-to-cash, Learn requires Relation table.Microsoft Learn Relation tableTableType

Common errors and fixes

MessageWhat to do
Prospects created in Dynamics 365 Sales arrive with the wrong relation type, or conversion to customer fails.Set Default relation type on the Prospect FastTab of Accounts receivable parameters to the same type as on Sales and marketing parameters, and check that prospect and customer number sequences don't overlap. Microsoft Learn

Test checklist

  1. Check that the type Prospect has Table source Relation table.
  2. On Sales and marketing parameters, Prospects tab, set Type to Prospect.
  3. Create a prospect on All prospects.
  4. Check that the new prospect has type Prospect.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Relation typesKeep the type Prospect with Table source Relation table as the prospect type on Sales and marketing parameters, and use the same type as Default relation type on Accounts receivable parameters.Learn's prospect-to-cash setup requires the prospect type with table source Relation table on Sales and marketing parameters and the same default type on Accounts receivable parameters.Will prospects be integrated with Dynamics 365 Sales?Using different prospect types on the two parameter pages, so prospects synced from Dynamics 365 Sales don't match the prospects created in Supply Chain Management.Test: New prospects get the default relation type

Feature management and licence

Licence or add-inOn the live system, Sales manager, Marketing manager and Information technology manager can maintain this page. With prospect-to-cash, the features Integrate Sales Quotation lifecycle with Dynamics 365 Sales and Enable prospects in Sales quotation lifecycle with Dynamics 365 Sales are on by default as of version 10.0.41; the second is mandatory as of 10.0.43.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Prospects keep the type they were created with, so changing the default type later leaves existing prospects on the old type. Microsoft Learn
If you change it laterThe prospect type on Sales and marketing parameters and the Default relation type on Accounts receivable parameters must point to the same relation type for prospect-to-cash; changing the type changes the type of new prospects only. Microsoft Learn
Technical architect

6Technical

Menu itemsmmBusRelTypeGroup Checked in Dynamics 365
FormsmmBusRelTypeGroup Checked in Dynamics 365
TablesmmBusRelTypeGroupShown as “Type table” in Record infoChecked in Dynamics 365
Data entitiesSalesProspectRelationTypeEntityProspect relation types Microsoft data model
Who can open itPrivilegesMaintain prospect types smmBusRelTypeGroupMaintainView prospect types smmBusRelTypeGroupViewDutiesEnable prospect process smmBusinessRelationProcessEnableInquire into prospect reference data smmBusinessRelationReferenceDataInquireEnable the Sales and marketing process smmCRMProcessEnableInquire into Sales and marketing reference data smmCRMReferenceDataInquire
3 security rolesMarketing manager CRMMarketingManagerInformation technology manager SysServerITManagerSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerMarketing manager CRMMarketingManagerInformation technology manager SysServerITManagerGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=smmBusRelTypeGroup
Integrate withSalesProspectRelationTypeEntity data entity Microsoft data model
Data migrationSalesProspectRelationTypeEntity (Prospect relation types): loaded for each company, in Microsoft's default template 330 - Sales and marketing.Load order: Microsoft's default template 330 - Sales and marketing loads Prospect relation types at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionsmmBusRelTypeGroup columns and relations Microsoft data model
Everyone

8Sources