BeyondERP.Newsletter
Menu

Inquiry page · Sales and marketing

Sales and profitability performance

An analytics page with Power BI reports that sales managers use to monitor revenue, gross profit and profit margins.

Used by
Chief executive officer, Sales manager
Business process
Measure sales performance
Menu item
SalesProfitabilityPerformancePowerBI
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 isAn analytics page with Power BI reports that sales managers use to monitor revenue, gross profit and profit margins.
What you do hereUse this page to follow changes in revenue and profit growth over time for customers and products.
ExampleFor example, BEAT's sales manager opens the page in November 2026: Top 10 customers by revenue shows BEAT-000123 first, and Customer profitability shows BEAT-000300 with high revenue but a gross margin of 9.00 percent, so its discount levels are reviewed.
Sales and profitability performance 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 performance analysis › Sales and profitability performance
Set up firstSales categories Microsoft Learn
Used next byGross margin by customer Microsoft Learn
Related pagesTop 100 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.

Setup steps on this page

Review sales and profitability performance

Follow revenue, gross profit and margin trends by customer and product.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Sales performance analysis > Sales and profitability performance.
  2. Check the report filters: by default the content shows the current calendar year; change the date or company filter if you review another period or legal entity.
  3. Start on Revenue by customer and Revenue by product to see the leaders, then open Customer profitability to find customers with high revenue and a low gross margin.
  4. Follow up the customers and products you found with the sales reports, for example Gross margin by customer.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Revenue by customerReport page with the top 10 customers by revenue, revenue by customer group, total revenue, year-over-year growth and gross margin.Microsoft Learn
Revenue by productReport page with revenue and gross profit by sales category and the top 10 products by revenue.Microsoft Learn
Revenue by periodReport page with revenue by month and year-over-year variance.Microsoft Learn
Customer profitabilityReport page that plots each customer's gross margin against revenue.Microsoft Learn BEAT-000300: high revenue, 9.00 percent margin
Profitability analysisReport page with revenue and gross profit by month and the top 15 customers by gross margin.Microsoft Learn

Common errors and fixes

MessageWhat to do
The reports show no data or old data.The content is filled from aggregate measurements staged in the Entity store; make sure the aggregate measurements are deployed and refreshed. Microsoft Learn

Test checklist

  1. Open the page and set the date filter to last year.
  2. Read Total revenue on Revenue by customer.
  3. Check that it matches last year's invoiced revenue in the accounting currency for the same legal entity.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review sales and profitability performanceSet the date and company filters first; the default is the current calendar year.Year-to-date and year-over-year figures depend on the date filter; another company filter changes every chart.Which tool should BEAT's monthly sales review use?Comparing gross margin here with the gross margin reports without noting that this content also subtracts commission and included sales tax.Test: Revenue matches invoices

Feature management and licence

Licence or add-inOn the live system, Sales manager and Chief executive officer use this page; 2 roles can open it in total. No Feature management feature is needed to open it.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyCompany filter: the content covers the legal entities in its data and can be filtered by company, so one view can show several legal entities. Microsoft Learn
Can it be undoneReversible: The page only reads analytics data; nothing is changed. Microsoft Learn
If you change it laterRevenue is the invoice line amount in the accounting currency; gross profit subtracts cost of goods sold, commission and included sales tax. Figures change only when the Entity store data is refreshed, not at the moment an invoice is posted. Microsoft Learn
Technical architect

6Technical

Menu itemSalesProfitabilityPerformancePowerBI Checked in Dynamics 365
FormSalesProfitabilityPerformancePowerBI Checked in Dynamics 365
Who can open itPrivilegesSales and profitability performance SalesProfitabilityPerformancePowerBIViewDutiesReview sales orders process performance SalesOrdersProcessPerformanceReview
2 security rolesChief executive officer CompanyChiefExecutiveOfficerSales manager TradeSalesManager
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 open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Share, Power BIChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SalesProfitabilityPerformancePowerBI
Data migrationLoad order: Sales and profitability performance has no data entity in Data management. Its data comes from aggregate measurements of the Invoice lines entity staged in the Entity store, built from posted invoices and inventory transactions, so there is nothing to migrate to it.Microsoft Learn
Everyone

8Sources