BeyondERP.Newsletter
Menu

Report page · Sales and marketing

Sales analysis by invoice

A United States and Canada report that shows customer invoice details such as invoice number, invoice date, invoice amount and total miscellaneous charges.

Business process
Invoice sales orders in Dynamics 365 Supply Chain Management
Menu item
output:CustSalesAnalysisByInvoice_NAV2
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 United States and Canada report that shows customer invoice details such as invoice number, invoice date, invoice amount and total miscellaneous charges.
What you do hereUse it to analyze posted customer invoices for a period, or one invoice, including the charges added to them.
ExampleFor example, BEAT's US legal entity analyzes October 2026: 214 invoices, of which invoice CI-004512 for 2,350.00 carries 410.00 in miscellaneous charges, far above the usual 25.00 freight, so the charge is checked against its order.
Sales analysis by invoice 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 processManage accounts receivable › Issue sales invoices › Invoice sales orders in Dynamics 365 Supply Chain Management
Menu pathSales and marketing › Inquiries and reports › Sales statistics › Sales analysis by invoice
Set up firstAll sales orders Microsoft Learn
Used next bySales and profitability performance Microsoft Learn
Related pagesCustomer turnover report 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 itAfter invoicing, when you analyze posted customer invoices and their charges for a period.
How oftenOn demand, typically at month end.
What the output showsOne row per customer invoice with invoice number, invoice date, invoice amount and total miscellaneous charges.

Source: Microsoft Learn

Setup steps on this page

Analyze invoices and charges

Review posted invoices and their miscellaneous charges.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Sales statistics > Sales analysis by invoice.
  2. Decide whether you analyze one invoice, by Invoice, or all invoices posted in a period, by Date.
  3. Set Date to the posting date range, or Invoice to the invoice number.
  4. Review the invoice amount and total miscellaneous charges per invoice, and check unusually high charges against the sales order.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
DateThe date the sales invoice was posted.Microsoft Learn 01.10.2026 to 31.10.2026
InvoiceThe sales invoice to report on.Microsoft Learn

Common errors and fixes

MessageWhat to do
An invoice is missing.Date filters on the posting date of the invoice; widen the range or filter on Invoice. Microsoft Learn
The report isn't available or can't be run in your legal entity.It is a United States and Canada report: Microsoft documents the _NA reports as available only to legal entities whose primary address is in Canada or the United States. Microsoft Learn

Test checklist

  1. Post an invoice with a charge for a test order.
  2. Run the report with Date set to today.
  3. Check that the invoice is listed with the charge in total miscellaneous charges.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Analyze invoices and chargesFilter on the posting Date range first; use Invoice for a single invoice.Date is the invoice posting date, which is the period you report on.Should miscellaneous charges be reviewed monthly?Comparing invoice amounts across periods without the charges, which can differ a lot per invoice.Test: Invoice with a charge

Feature management and licence

Licence or add-inOn the live system, Accounts receivable manager, Accounting manager, Auditor, Financial controller and Chief executive officer use this page; 6 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 posted invoices. Run it again with other parameters at any time. Checked in Dynamics 365
If you change it laterThe report reads posted invoices at run time; invoices posted later in the period need a new run. Microsoft documents the _NA reports as available only to legal entities whose primary address is in Canada or the United States. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:CustSalesAnalysisByInvoice_NAV2 Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerAuditor AuditPolicyManagerFinancial controller LedgerFinancialControllerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

7Developer

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

8Sources