BeyondERP.Newsletter
Menu

Report page · Sales and marketing

Open sales orders

A United States and Canada report that lists open sales orders, meaning orders with items the customer ordered that haven't shipped yet, with status, ship date and customer.

Business process
Manage sales orders
Menu item
output:CustSalesOpenOrders_NA
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 lists open sales orders, meaning orders with items the customer ordered that haven't shipped yet, with status, ship date and customer.
What you do hereUse it to follow up backorders: orders that must ship soon to reach the customer's requested receipt date, or that are already late.
ExampleFor example, BEAT's US legal entity runs the report every morning; on 09.11.2026 it lists SO-001234 for BEAT-000123 with ship date 06.11.2026, three days late, so customer service calls the customer with a new date.
Open sales orders 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 › Open sales orders
Set up firstAll sales orders Microsoft Learn
Used next byBackorder lines Microsoft Learn
Related pagesOpen sales order lines by customer 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 itWhen you follow up backorders, for example before daily shipping planning.
How oftenDaily or on demand.
What the output showsOpen sales orders with status, sales order, ship date and customer account.

Source: Microsoft Learn

Setup steps on this page

Follow up open sales orders

List orders that still have items to ship and find the late ones.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Sales order reports > Open sales orders.
  2. Filter on Ship date up to today plus a few days to see what must ship now, or on Customer account to answer one customer.
  3. Read status and ship date per order; an order with a ship date in the past is a backorder to follow up.
  4. Change the delivery date on the order and tell the customer, as Microsoft recommends for backorders.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
StatusThe status of the sales order.Microsoft Learn
Sales orderThe sales order number.Microsoft Learn
Ship dateThe date the order must ship to arrive on the customer's requested receipt date.Microsoft Learn 06.11.2026
Customer accountThe customer account the order is for.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 Backorder lines in other legal entities. Microsoft Learn

Test checklist

  1. In a US or Canadian legal entity, create a sales order with a ship date of yesterday and don't ship it.
  2. Run the report with Ship date up to today.
  3. Check that the order is listed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Follow up open sales ordersFilter on Ship date up to today first.The ship date is when the order must leave to reach the requested receipt date; past dates are late orders.Which report should customer service use for backorders?Reading the report as order lines. It lists orders; use the open sales order line reports for line quantities.Test: Late order is listed

Feature management and licence

Licence or add-inOn the live system, Accounts receivable clerk, Accounts receivable manager, Accounts receivable centralized payments clerk, Accounts receivable payments clerk and Collections manager use this page; 13 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 sales orders. Run it again with other parameters at any time. Checked in Dynamics 365
If you change it laterThe list changes as packing slips are posted; run it again after shipping. 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:CustSalesOpenOrders_NA Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkCollections manager CollectionLetterCollectionsManagerGive people one of these roles. On this system, 13 roles can run this page.Checked in Dynamics 365
Developer

7Developer

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

8Sources