BeyondERP.Newsletter
Menu

Setup step on the Sales item group statistics page · Sales and marketing

Review sales by item group

See which item groups drive sales in a period.

Business process
Measure sales performance
Menu item
output:CustSalesItemGroupStatistics_NA
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 United States and Canada report that prints sales statistics per item group for a date range, with an option to list the item numbers under each group.
What you do hereUse it to see which item groups drive sales in a period, and switch on the detailed view to see the items behind a group.
ExampleFor example, BEAT's US legal entity runs the report for October 2026: item group CHAIRS sold 184,500.00 and item group DESKS 96,200.00; the detailed view shows that one item, CHAIR-01, makes up 61,300.00 of the chairs.
Sales item group statistics 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 › Sales statistics › Sales item group statistics
Set up firstItem groups Checked in Dynamics 365
Used next byGross margin by item Microsoft Learn
Related pagesSales and profitability performance Microsoft Learn
In this process Compare sales between two periods · Review sales and profitability performance
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 see which item groups drive sales in a period, for example at month end.
How oftenOn demand, usually once per period.
What the output showsSales statistics per item group for the date range, with item numbers listed when Detailed, with item numbers is on.

Source: Checked in Dynamics 365

Setup steps on this page

Review sales by item group

See which item groups drive sales in a period.

How to use it

  1. Go to Sales and marketing > Inquiries and reports > Sales statistics > Sales item group statistics.
  2. Enter the From date and To date of the period to analyze.
  3. Switch on Detailed, with item numbers to list the items under each item group, or leave it off for group totals only.
  4. Compare the group totals with the period's sales and open the detailed view for any group that looks too high or too low.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExample
From dateThe first date of the period to analyze.Checked in Dynamics 36501.10.2026
To dateThe last date of the period to analyze.Checked in Dynamics 36531.10.2026
Detailed, with item numbersLists the item numbers under each item group instead of group totals only.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
The report shows group totals but no items.Switch on Detailed, with item numbers. Checked in Dynamics 365
The report isn't available or can't be run in your legal entity.Its menu item ends in _NA, like the other United States and Canada reports. Microsoft documents the _NA reports as available only to legal entities whose primary address is in Canada or the United States. Microsoft Learn

Test checklist

  1. Run the report for last month with Detailed, with item numbers off.
  2. Run it again with the option on.
  3. Check that the items listed under one group add up to that group's total.

Source: Checked in Dynamics 365

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review sales by item groupEnter the period first, then decide on Detailed, with item numbers.Group totals answer which groups sell; the detail shows which items explain a group.How detailed should the monthly item group review be?Reading an item under an unexpected group as a report error; the item's group on the released product decides where it is counted.Test: Item group totals

Feature management and licence

Licence or add-inOn the live system, Accounts receivable manager, Accounting manager, Auditor, Financial controller and Chief executive officer use this page; 6 roles can run it in total. No Feature management feature is needed to open it.

Checked in Dynamics 365

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: Running the inquiry or report changes no data.
Feature or countryUS, CA
If you change it laterFigures are read at run time for the dates entered. Revenue per item group and sales category is also in the Sales and profitability performance Power BI content. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:CustSalesItemGroupStatistics_NA Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerAuditor AuditPolicyManagerFinancial controller LedgerFinancialControllerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:CustSalesItemGroupStatistics_NA
Data migrationLoad order: Sales item group statistics has no data entity in Data management. It is a report: it reads sales per item group and stores nothing of its own.Checked in Dynamics 365
Everyone

8Sources

To cite this step: SM-INQ-250, Review sales by item group. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-INQ-250