BeyondERP.Newsletter
Menu

Report page · Retail and Commerce

Category sales report

A report dialog that prints sales figures for each node of a category hierarchy for a channel or operating unit over a period.

Business process
Analyze and monitor Point of Sale (POS) activity in Dynamics 365 Commerce
Menu item
RetailPerformanceByCategorySSRSReport
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 each node of a category hierarchy for a channel or operating unit over a period.
What you do hereUse this page to compare sales across product categories for a channel and date range.
ExampleFor example, a category manager can check how each category sold in a store during a promotion week.
Category sales 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 › Category sales 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 compare how product categories sell in a channel, for example to plan assortment or promotions.
How oftenOn demand, per period or season.
What the output showsSales metrics for each node of the category hierarchy for the channel and period. Products in the wrong category node usually point to category assignments rather than wrong sales.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Retail and Commerce > Inquiries and reports > Sales reports > Category sales report.
  2. Enter the From date and To date of the period to compare.
  3. In the Channel field, select the channel or operating unit whose category sales you want.
  4. Run the report and drill down from the top category node to the leaf nodes of the default product category hierarchy.

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

5Technical

Menu itemRetailPerformanceByCategorySSRSReport 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=RetailPerformanceByCategorySSRSReport
Everyone

7Sources