BeyondERP.Newsletter
Menu

Report page · Retail and Commerce

Top products report

A report dialog that prints sales figures for the top-selling products (10 to 100) in a channel or operating unit.

Business process
Analyze and monitor Point of Sale (POS) activity in Dynamics 365 Commerce
Menu item
RetailTopProductsSSRSReport
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-selling products (10 to 100) in a channel or operating unit.
What you do hereUse this page to see which products sell best in a channel for a date range, ranked by a measure you choose.
ExampleFor example, a merchandiser can list the top 20 products in a store for last month to plan replenishment.
Top products 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 products 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 products sell best, or are most profitable, in a channel for a period.
How oftenOn demand, for example at the end of a sales period or promotion.
What the output showsSales metrics for the top N products (10 to 100) of the channel, ranked by the measure you choose. A product missing from the list may simply rank lower on the chosen measure, or its sales haven't been posted from the store yet.

Source: Microsoft Learn

Steps from Microsoft

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

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 products report only reads sales data; it changes nothing. Microsoft Learn
Technical architect

5Technical

Menu itemRetailTopProductsSSRSReport 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 RetailStoreManagerRetail merchandising manager RetailMerchandisingManagerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources