BeyondERP.Newsletter
Menu

Setup step on the Open sales order lines by customer page · Sales and marketing

Review open lines by customer

Follow up backorders grouped by customer.

Business process
Manage sales orders
Menu item
output:CustSalesOpenLinesbyCust_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 prints open sales order lines grouped by customer.
What you do hereUse it to follow up backorders per customer: the lines customers ordered that haven't shipped yet.
ExampleFor example, customer BEAT-000123 calls on 09.11.2026 about delayed goods. The report shows three open lines for the customer, two of them for item CHAIR-01 with 24.00 pieces still to ship, so customer service can answer in one call.
Open sales order lines 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 processManage sales orders
Menu pathSales and marketing › Inquiries and reports › Sales order reports › Open sales order lines by customer
Set up firstAll sales orders Microsoft Learn
Used next byBackorder lines Microsoft Learn
Related pagesOpen sales orders Microsoft Learn
In this process Follow up open sales orders · Review open lines 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 itWhen backorders are reviewed per customer.
How oftenDaily or on demand.
What the output showsOpen sales order lines grouped by customer.

Source: Microsoft Learn

Setup steps on this page

Review open lines by customer

Follow up backorders grouped by customer.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Sales order reports > Open sales order lines by customer.
  2. Filter on the customer accounts you are answering for.
  3. Read the open lines under each customer and look first at lines whose ship date has passed.
  4. Change the delivery date on the late orders and tell the customers, or split the available stock between the orders.

Source: Microsoft Learn

Common errors and fixes

MessageWhat to do
The report isn't available or can't be run in your legal entity.Its menu item ends in _NA, like the other United States and Canada reports in this menu. Microsoft documents the _NA reports as available only to legal entities whose primary address is in Canada or the United States. Use Open sales order lines or Backorder lines in other legal entities. Microsoft Learn

Test checklist

  1. In a US or Canadian legal entity, create a sales order with two lines and ship one.
  2. Run the report.
  3. Check that only the unshipped line is printed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review open lines by customerFilter on the customer accounts you are answering for.Backorders per customer answer the question customers ask: what am I still waiting for.Is the by-customer view the one this team needs?Reading open lines as late lines. Open only means not shipped; compare the ship date with today.Test: Open line grouped by customer

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: Running the inquiry or report changes no data.
Feature or countryUS, CA
If you change it laterLines leave the report when they are shipped; run it again after packing slips 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:CustSalesOpenLinesbyCust_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:CustSalesOpenLinesbyCust_NA
Data migrationLoad order: Open sales order lines by customer has no data entity in Data management. It is a report: it reads open sales order lines and stores nothing of its own.Checked in Dynamics 365
Everyone

8Sources

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