A United States and Canada report that shows customer invoice details such as invoice number, invoice date, invoice amount and total miscellaneous charges.
Sales and marketingInquiries and reportsSales statistics
output:CustSalesAnalysisByInvoice_NAV2
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 is
A 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 here
Use it to analyze posted customer invoices for a period, or one invoice, including the charges added to them.
Example
For 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.
The page in Dynamics 365. page title tab to open what to set or check
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 it
After invoicing, when you analyze posted customer invoices and their charges for a period.
How often
On demand, typically at month end.
What the output shows
One row per customer invoice with invoice number, invoice date, invoice amount and total miscellaneous charges.
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
Post an invoice with a charge for a test order.
Run the report with Date set to today.
Check that the invoice is listed with the charge in total miscellaneous charges.
On 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 company
Per 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 undone
Reversible: 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 later
The 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 item
output:CustSalesAnalysisByInvoice_NAV2Checked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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
Load 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