BeyondERP.Newsletter
Menu

Setup step on the Gross margin by customer page · Sales and marketing

Review gross margin by customer

Find the customers with low or negative gross profit.

Business process
Measure sales performance
Menu item
output:CustGrossMarginbyAccount_NA
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 United States and Canada report that shows sales order information with sales amount, cost, gross profit and gross profit percentage, sorted by customer, as a summary or with each order's details.
What you do hereUse it to review the gross profit earned per customer and find customers with low or negative margins.
ExampleFor example, BEAT's US legal entity reviews October: BEAT-000123 has sales of 85,000.00, cost of 71,400.00 and a gross profit of 16.00 percent, against 28.00 percent on average, so its discounts are reviewed.
Gross margin by customer 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 › Gross margin by customer
Set up firstAll sales orders Microsoft Learn
Used next bySales and profitability performance Microsoft Learn
Related pagesTop 100 Microsoft Learn
In this process Total customer turnover · Review gross margin by item
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 itAt period end, or when you review pricing per customer.
How oftenOn demand, often monthly.
What the output showsSales amount, cost, gross profit and gross profit percentage per customer, with sales order details when Summary is off.

Source: Microsoft Learn

Setup steps on this page

Review gross margin by customer

Find the customers with low or negative gross profit.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Customer statistics > Gross margin by customer.
  2. Set Summary to Yes for one total per customer, or leave it off to see each sales order's details.
  3. Select the Customer account, Sales order or Date range to include, for example last month.
  4. Read the gross profit percentage per customer and open the orders behind any low or negative margin.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
SummaryShows only a summary for each customer instead of each sales order's details.Microsoft Learn Yes
Customer accountThe customer account used on the sales order.Microsoft Learn
Sales orderThe sales order number to include.Microsoft Learn
DateThe sales order transaction date.Microsoft Learn

Common errors and fixes

MessageWhat to do
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. Use the Sales and profitability performance Power BI content elsewhere. Microsoft Learn

Test checklist

  1. Pick one customer with invoiced sales.
  2. Run the report with Summary Yes for it.
  3. Check that sales amount minus cost equals the gross profit shown.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review gross margin by customerDecide Summary first: a total per customer for the overview, details for the follow-up.The summary shows which customers to look at; the details show which orders cause it.Which margin view should BEAT's monthly review use?Reading a negative gross profit as a pricing error when the cost on the item may be wrong.Test: Gross profit per customer

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: Running the inquiry or report changes no data.
Feature or countryUS, CA
If you change it laterFigures are read at run time, so run the report again after more invoices are posted. 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:CustGrossMarginbyAccount_NA 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:CustGrossMarginbyAccount_NA
Data migrationLoad order: Gross margin by customer has no data entity in Data management. It is a report: it reads sales and cost data and stores nothing of its own.Checked in Dynamics 365
Everyone

8Sources

To cite this step: SM-INQ-220, Review gross margin by customer. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-INQ-220