BeyondERP.Newsletter
Menu

Report page · Accounts receivable

Invoice turnover report

A report that prints turnover for customer invoices.

Business process
Analyze sales performance
Menu item
Output:CustInvoiceVolume
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 prints turnover for customer invoices.
What you do hereUse this report to see the total invoice amount for customers in a chosen time period, such as a year.
Invoice 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 › Invoices › Invoice 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 need total invoice amounts per customer for a period, for example for annual turnover reporting.
How oftenOn demand, often once a year.
What the output showsTotal invoiced amount per customer account or tax exempt number for the period, above the minimum amount. Totals that are higher than expected usually include sales tax because Amount excl. sales tax was off.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts receivable > Inquiries and reports > Invoices > Invoice turnover report.
  2. In Grouping by, choose customer account or tax exempt number.
  3. Enter the From date and To date, for example a whole year.
  4. Enter a Minimum amount to leave out small customers, and switch Amount excl. sales tax to Yes for amounts without sales tax, then run it.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Grouping byGroups invoices by customer account or by tax exempt number.Microsoft Learn
From dateThe first date of transactions to include.Microsoft Learn
To dateThe last date of transactions to include.Microsoft Learn
Minimum amountThe smallest invoice amount to include.Microsoft Learn
Amount excl. sales taxLeaves sales tax out of the amounts.Microsoft Learn
Billing classificationLimits the report to one or more billing classifications (public sector).Microsoft Learn
Solution architect

4Design impact

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

5Technical

Menu itemOutput:CustInvoiceVolume Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounting manager LedgerAccountingManagerCollections manager CollectionLetterCollectionsManagerAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkGive people one of these roles. On this system, 13 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources