BeyondERP.Newsletter
Menu

Setup step on the Customer turnover report page · Sales and marketing

Total customer turnover

Total invoiced sales per customer.

Business process
Measure sales performance
Menu item
output:CustRevenue
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 report that shows customer invoice totals, sorted by invoice account or by order account.
What you do hereUse it to see what each customer was invoiced, for example for a year-end customer review or a rebate discussion.
ExampleFor example, BEAT invoices the stores of chain BEAT-000300 through one head-office invoice account. With Criteria set to Invoice account the head office shows 640,000.00; with Order account the same amount is split over its 12 stores.
Customer turnover 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
Menu pathSales and marketing › Inquiries and reports › Customer statistics › Customer turnover report
Set up firstAll customers Microsoft Learn
Used next byProspect turnover Microsoft Learn
Related pagesTop 100 Microsoft Learn
In this process Rank the top customers · Review gross margin by customer
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 need invoiced totals per customer, for example for a year-end review.
How oftenOn demand, typically at period or year end.
What the output showsInvoice totals for each customer, by invoice account or order account depending on Criteria.

Source: Microsoft Learn

Setup steps on this page

Total customer turnover

Total invoiced sales per customer.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Customer statistics > Customer turnover report.
  2. In Criteria, choose invoice account to total by the customer who was billed, or order account to total by the customer who ordered.
  3. Select the customers to include, for example one customer chain.
  4. Compare the totals with the customer's invoice history; when invoice and order accounts differ, the two choices give different amounts per customer.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
CriteriaChooses whether totals are shown by invoice account or by order account.Microsoft Learn

Common errors and fixes

MessageWhat to do
A customer shows less turnover than expected.Its invoices may be billed to another invoice account. Run the report with Criteria set to order account. Microsoft Learn

Test checklist

  1. Pick a customer with a different invoice account.
  2. Run the report twice, once per Criteria option.
  3. Check that the totals move between the order and the invoice customer.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Total customer turnoverChoose Criteria first: invoice account or order account.When customers order for another invoice account, the two choices total the same invoices under different customers.Which account should turnover reviews use?Comparing a total by invoice account with a target set per ordering customer.Test: Turnover by order and invoice account

Feature management and licence

Licence or add-inOn the live system, Sales manager, Accounts receivable manager, Sales representative, Collections manager and Accounting manager use this page; 9 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.
If you change it laterTotals are read from posted invoices at run time; invoices posted later need a new run. Revenue per customer group and customer is also available in the Sales and profitability performance Power BI content. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:CustRevenue Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itSales manager TradeSalesManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerSales representative TradeSalesRepresentativeCollections manager CollectionLetterCollectionsManagerAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 9 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:CustRevenue
Data migrationLoad order: Customer turnover report has no data entity in Data management. It is a report: it totals posted invoices and stores nothing of its own.Checked in Dynamics 365
Everyone

8Sources

To cite this step: SM-INQ-210, Total customer turnover. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-INQ-210