BeyondERP.Newsletter
Menu

Report page · Sales and marketing

Top 100

A report that ranks customers, the top 100 by default, sorted by the option you choose, with Revenue as the default sorting. It always runs across all customers of the legal entity.

Business process
Measure sales performance
Menu item
output:salesRankingReport
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 report that ranks customers, the top 100 by default, sorted by the option you choose, with Revenue as the default sorting. It always runs across all customers of the legal entity.
What you do hereUse it to list your leading customers for account planning or a sales review.
ExampleFor example, BEAT runs Top 100 at the end of October with Sorting Revenue and Number of records 10; BEAT-000123 ranks first with 1,240,000.00, and two customers in the top 10 have no account manager yet.
Top 100 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 processAnalyze sales performance › Measure sales performance
Menu pathSales and marketing › Inquiries and reports › Customer statistics › Top 100
Set up firstAll customers Microsoft Learn
Used next byCustomer turnover report Microsoft Learn
Related pagesSales and profitability performance 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.

When to run it

When to run itWhen you prepare account planning or a sales review.
How oftenOn demand, for example at period end.
What the output showsA ranked list of customers sorted by the option in Sorting, with as many rows as Number of records.

Source: Checked in Dynamics 365

Setup steps on this page

Rank the top customers

List the leading customers for account planning.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Customer statistics > Top 100.
  2. In Sorting, keep Revenue to rank by sales, or choose another sorting option.
  3. In Number of records, keep 100 or enter a smaller number such as 10 for a short list; the report always covers all customers.
  4. Read the ranking and check the account owner and credit terms of the top customers.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
SortingWhat ranks the customers; Revenue is the default and puts the customers with the highest sales first.Checked in Dynamics 365Revenue
Number of recordsHow many customers are printed; 100 by default.Checked in Dynamics 36510

Common errors and fixes

MessageWhat to do
Records to include can't be changed in the Top 100 dialog.This is by design: the Improve "Top 100" customers report performance feature always runs the report across all customers and disables the Records to include settings. Use Number of records to shorten the list. Microsoft Learn

Test checklist

  1. Run Top 100 with Sorting Revenue and Number of records 5.
  2. Check that 5 customers are printed in falling order of revenue.
  3. Check that the first customer is the one with the highest sales in the customer list.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Rank the top customersChoose Sorting first, then the Number of records.The sorting decides who is a top customer; the number only shortens the list.How many customers should the account review cover?Expecting the report to rank one customer group. It always ranks all customers; filter the printed list instead.Test: Top 5 by revenue

Feature management and licence

Feature to turn onImprove "Top 100" customers report performance
Licence or add-inOn the live system, Sales manager and Chief executive officer use this page; 2 roles can run it in total. The Improve "Top 100" customers report performance feature is always on (mandatory as of 10.0.29).

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the report reads the data of the legal entity you run it in. To compare legal entities, run it in each one. Checked in Dynamics 365
Can it be undoneReversible: The report changes no data; it only reads sales figures. Run it again with other parameters at any time. Checked in Dynamics 365
If you change it laterThe Improve "Top 100" customers report performance feature is mandatory as of 10.0.29, so custom queries on this report are no longer possible; it always ranks all customers. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:salesRankingReport Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itSales manager TradeSalesManagerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:salesRankingReport
Data migrationLoad order: Top 100 has no data entity in Data management. It is a report: it ranks customers by their sales and stores nothing of its own.Checked in Dynamics 365
Everyone

8Sources