BeyondERP.Newsletter
Menu

Report page · Accounts receivable

Customer turnover report

A report that shows customer invoice totals.

Business process
Analyze sales performance
Menu item
Output:CustRevenue
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 that shows customer invoice totals.
What you do hereUse this report to view customer invoice totals sorted by invoice account or order account.
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
Menu pathAccounts receivable › Inquiries and reports › Customers › Customer turnover report
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 analyze sales volume per customer, for example for account reviews or rebate discussions.
How oftenOn demand, or at period end for sales analysis.
What the output showsCustomer invoice totals sorted by invoice account or by order account. Totals differ between the two options when customers order on one account and are billed on another.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts receivable > Inquiries and reports > Customers > Customer turnover report.
  2. In Criteria (shown as the Totals option), choose Invoice account to total by the account that is billed, or Order account to total by the ordering customer.
  3. Filter on the customers and the invoice period you want totals for.
  4. Run the report and compare the totals of the largest customers with your sales figures.

Source: Microsoft Learn

Fields on the page

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

4Design impact

Can it be undoneNothing to undo: The report only reads posted invoice totals. Microsoft Learn
Technical architect

5Technical

Menu itemOutput:CustRevenue Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerCollections manager CollectionLetterCollectionsManagerFinancial controller LedgerFinancialControllerAuditor AuditPolicyManagerGive people one of these roles. On this system, 9 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=Output:CustRevenue
Everyone

7Sources