BeyondERP.Newsletter
Menu

Setup step on the Sales districts page · Sales and marketing

Set up Sales districts

Use this page to group sales and sales statistics by geographical area.

Used by
Auditor, Collections agent, Collections manager and 7 more roles
Business process
Maintain contacts and accounts
Menu item
smmBusRelSalesDistrictGroup
Main table
smmBusRelSalesDistrictGroup
Data entity
smmSalesDistrictEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you list the geographical areas, the sales districts, used for sales and sales statistics.
What you do hereUse this page to group sales and sales statistics by geographical area.
ExampleBEAT splits its market into the sales districts NORTH, SOUTH and EXPORT. Customer CUST-000245 is in NORTH, and the sales statistics for May 2026 show 412,000.00 USD of sales in NORTH against 298,500.00 USD in SOUTH.
Sales districts 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

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 Sales districts1 screen

Use this page to group sales and sales statistics by geographical area.

  1. Screen 1

    Create a sales district

    Go to Sales and marketing > Setup > Prospects > Sales districts

    1. Select New
    2. Enter the sales district code and description
    3. Select Save
    1Sales districtBEAT-SD
    DescriptionSales district
    Create a sales district (zoomed on the outlined fields)
    Show the full screenCreate a sales district
    page title tab to open what to set or check

How to use it

  1. Go to Sales and marketing > Setup > Prospects > Sales districts.
  2. Select New and enter the Sales district code, such as NORTH, and a Description.
  3. Agree the list with the sales and finance teams before prospects and customers are loaded, because both use the code.
  4. Open Sales and marketing > Relationships > Prospects > All prospects and set the Sales district on a prospect to check that the code is offered.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Sales districtThe code of the sales district, for example NORTH. You select it on a prospect or a customer to place it in a geographical area for sales and sales statistics.Microsoft data model NORTHSalesDistrictId
DescriptionA short description of the sales district, shown next to the code.Checked in Dynamics 365Northern regionDescription

Common errors and fixes

MessageWhat to do
Sales by district add up to less than total sales.Some customers or prospects have no sales district. Filter All customers and All prospects on an empty Sales district and fill it in. Microsoft data model

Test checklist

  1. Create two codes, NORTH and one more.
  2. Set NORTH on two prospects on All prospects.
  3. Filter All prospects on NORTH.
  4. Check that 2 prospects are listed.

Source: Microsoft data model

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Sales districtsSales districts that match the geographical areas sales management reports on, set on every prospect and customer.The district code is stored on prospects and customers, so sales statistics by area are only complete when every record has a district.How is the market split into areas for sales reporting?Leaving the district empty on part of the customers, so area statistics don't add up to total sales.Test: District filters customers and prospects

Feature management and licence

Licence or add-inOn the live system, Sales manager, Marketing manager, Accounts receivable manager, Information technology manager and Collections manager can maintain this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Codes can be changed; prospects and customers keep the code they were saved with.
If you change it laterThe code is stored on prospects (smmBusRelTable.SalesDistrict) and customers, so a new code is available on both at once. Renaming a description changes only the text shown. Microsoft data model
Technical architect

6Technical

Menu itemsmmBusRelSalesDistrictGroup Checked in Dynamics 365
FormsmmBusRelSalesDistrictGroup Checked in Dynamics 365
TablesmmBusRelSalesDistrictGroupShown as “Sales districts” in Record infoChecked in Dynamics 365
Data entitiessmmSalesDistrictEntitySales districts Microsoft data model
Who can open itPrivilegesMaintain prospect sales districts smmBusRelSalesDistrictGroupMaintainView prospect sales districts smmBusRelSalesDistrictGroupViewDutiesEnable customer process CustCustomerProcessEnableInquire into customer reference data CustCustomerReferenceDataInquireEnable prospect process smmBusinessRelationProcessEnableInquire into prospect reference data smmBusinessRelationReferenceDataInquireEnable the Sales and marketing process smmCRMProcessEnableInquire into Sales and marketing reference data smmCRMReferenceDataInquire
10 security rolesAuditor AuditPolicyManagerCollections agent CollectionLetterCollectionsAgentCollections manager CollectionLetterCollectionsManagerChief financial officer CompanyChiefFinancialOfficerMarketing manager CRMMarketingManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerInformation 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 CRMMarketingManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerInformation technology manager SysServerITManagerCollections manager CollectionLetterCollectionsManagerTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounting manager LedgerAccountingManagerCollections agent CollectionLetterCollectionsAgentAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 10 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=smmBusRelSalesDistrictGroup
Integrate withsmmSalesDistrictEntity data entity Microsoft data model
Data migrationsmmSalesDistrictEntity (Sales districts): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Sales districts 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 definitionsmmBusRelSalesDistrictGroup columns and relations Microsoft data model
Everyone

8Sources