BeyondERP.Newsletter
Menu

Report page · Retail and Commerce

Top customers report

A report dialog that prints sales figures for the top customers (10 to 100) of a channel or operating unit.

Business process
Analyze and monitor Point of Sale (POS) activity in Dynamics 365 Commerce
Menu item
RetailSalesByCustomerSSRSReport
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report dialog that prints sales figures for the top customers (10 to 100) of a channel or operating unit.
What you do hereUse this page to see which customers buy the most in a channel for a date range, ranked by a measure you choose.
ExampleFor example, a marketing user can list the top 50 customers of a store to target a loyalty offer.
Top customers report 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 › Analyze and monitor Point of Sale (POS) activity in Dynamics 365 Commerce
Menu pathRetail and Commerce › Inquiries and reports › Sales reports › Top customers report
Related pagesStore management workspace reports 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 want to know which customers buy the most, or bring the most margin, in a channel.
How oftenOn demand, for example for customer reviews or loyalty campaigns.
What the output showsSales metrics for the top N customers (10 to 100) of the channel, ranked by the chosen measure. Sales without a customer, such as anonymous cash sales, don't appear.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Retail and Commerce > Inquiries and reports > Sales reports > Top customers report.
  2. Enter the From date and To date of the period you want to rank customers for.
  3. In the Channel field, select the channel or operating unit whose customers you want to rank.
  4. Run the report and choose the measure: sales amount, quantity, gross profit margin or margin percentage. It lists the top 10 to 100 customers.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
From dateThe first date of the period the report covers.Microsoft Learn
To dateThe last date of the period the report covers.Microsoft Learn
ChannelThe channel whose transactions the report shows.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The top customers report only reads data; it changes nothing. Microsoft Learn
Technical architect

5Technical

Menu itemRetailSalesByCustomerSSRSReport Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itRetail service RetailServiceRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerGive people one of these roles. On this system, 3 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=RetailSalesByCustomerSSRSReport
Everyone

7Sources