BeyondERP.Newsletter
Menu

Setup step on the Sales orders per customer page · Sales and marketing

Review orders per customer

See each customer's orders and what is still to be invoiced.

Business process
Manage sales orders
Menu item
output:SalesHeading
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 report that prints sales orders sorted by customer, optionally with the last packing slip and last invoice of each order and the invoiced, not invoiced and margin totals.
What you do hereUse it to review a customer's orders and what is still to be invoiced, for example before an account review or a credit decision.
ExampleFor example, before a credit review on 09.11.2026, BEAT prints the orders of BEAT-000123 with Totals set to Yes: 48,200.00 invoiced and 12,450.00 ordered but not invoiced, which the credit manager adds to the open balance.
Sales orders per 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 processManage sales orders
Menu pathSales and marketing › Inquiries and reports › Sales order reports › Sales orders per customer
Set up firstAll sales orders Microsoft Learn
Used next byCustomer turnover report Microsoft Learn
Related pagesSales order lines Microsoft Learn
In this process Review open lines by ship date · Review sales order lines
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 itBefore an account review or a credit decision for a customer.
How oftenOn demand.
What the output showsSales orders grouped by customer, with the last packing slip and invoice when Forms is Yes and the invoiced, ordered not invoiced and margin not invoiced amounts when Totals is Yes.

Source: Microsoft Learn

Setup steps on this page

Review orders per customer

See each customer's orders and what is still to be invoiced.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Sales order reports > Sales orders per customer.
  2. Set Forms to Yes to see each order's last packing slip and last invoice, and Totals to Yes to see the invoiced amount, the amount ordered but not invoiced and the margin not invoiced.
  3. Select the customer accounts or sales orders to print, for example the customers of one account manager.
  4. Read the ordered but not invoiced amount per customer and check orders that were shipped but not invoiced.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
FormsAdds the last packing slip and last invoice for each sales order.Microsoft Learn Yes
TotalsAdds the invoiced amount, the amount ordered but not invoiced, and the margin not invoiced.Microsoft Learn

Common errors and fixes

MessageWhat to do
The last packing slip and invoice columns are empty.Set Forms to Yes; without it the report prints only the orders. Microsoft Learn

Test checklist

  1. Pick a customer with one invoiced and one open order.
  2. Run the report with Forms and Totals set to Yes for that customer.
  3. Check that the invoiced order shows its last invoice and that Ordered, not invoiced equals the open order's amount.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review orders per customerSet Totals to Yes and select the customers first.Totals adds the invoiced and ordered but not invoiced amounts, which is the figure an account or credit review needs.Which details should the account review print?Reading Margin, not invoiced as realized margin. It is the margin on what hasn't been invoiced yet.Test: Totals per customer

Feature management and licence

Licence or add-inOn the live system, Sales manager, Rental manager, Rental coordinator agent, Accounts receivable clerk and Accounts receivable manager use this page; 18 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.
If you change it laterAmounts are read at run time; invoices posted later change the invoiced and not invoiced totals. A customer invoice completes the sales order, packing slip and invoice cycle. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:SalesHeading Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itSales manager TradeSalesManagerRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerGive people one of these roles. On this system, 18 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:SalesHeading
Data migrationLoad order: Sales orders per customer has no data entity in Data management. It is a report: it reads customers and sales orders and stores nothing of its own.Checked in Dynamics 365
Everyone

8Sources

To cite this step: SM-INQ-170, Review orders per customer. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-INQ-170