BeyondERP.Newsletter
Menu

Report page · Sales and marketing

Customer/item statistics

A report that shows sales per customer or per item for two periods side by side.

Business process
Measure sales performance
Menu item
output:smmSalesCustItemStatistics
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 shows sales per customer or per item for two periods side by side.
What you do hereUse it to compare sales between two periods, for example this quarter with the same quarter last year.
ExampleFor example, BEAT compares the third quarter of 2025 with the third quarter of 2026 per item: CHAIR-01 rose from 52,000.00 to 61,300.00, while DESK-02 fell from 40,000.00 to 22,800.00, which starts a talk with purchasing.
Customer/item 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 › Customer statistics › Customer/item statistics
Set up firstAll customers Microsoft Learn
Used next byTop 100 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 compare sales between two periods.
How oftenOn demand, usually at period end.
What the output showsSales per customer or per item for Period 1 and Period 2 side by side.

Source: Microsoft Learn

Setup steps on this page

Compare sales between two periods

Compare sales per customer or item for two periods.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Customer statistics > Customer/item statistics.
  2. Set Posting to customer to compare sales per customer, or to item to compare sales per item.
  3. Enter From date and To date for Period 1 and for Period 2, for example the same quarter of two years.
  4. Read the rows with the largest change first; if every row drops, check that both periods have the same number of days.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
PostingChooses whether sales are shown by customer or by item.Microsoft Learn
From dateThe start and end dates of the first period to compare.Microsoft Learn

Common errors and fixes

MessageWhat to do
Both periods show the same amounts.Period 1 and Period 2 have their own From date and To date; enter different dates for each. Microsoft Learn

Test checklist

  1. Pick a customer with sales in both periods.
  2. Run the report with Posting set to customer and the two periods.
  3. Check that each period's amount matches the customer's invoices in that period.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Compare sales between two periodsSet Posting, then two periods of the same length.Periods of different length make every row look like growth or decline.Which view should the period review use?Comparing a period that isn't closed yet with a full period.Test: Two-period comparison

Feature management and licence

Licence or add-inOn the live system, Sales manager and Chief executive officer use this page; 2 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: The report changes no data; it only reads sales data. Run it again with other parameters at any time. Checked in Dynamics 365
If you change it laterAmounts are read at run time; invoices posted later in a period change it on the next run. Year-over-year revenue change by customer region and sales category is also in the Sales and profitability performance Power BI content. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:smmSalesCustItemStatistics 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:smmSalesCustItemStatistics
Data migrationLoad order: Customer/item statistics has no data entity in Data management. It is a report: it reads sales data and stores nothing of its own.Checked in Dynamics 365
Everyone

8Sources