BeyondERP.Newsletter
Menu

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

Review open lines by item

Follow up backorders grouped by item.

Business process
Manage sales orders
Menu item
output:CustSalesOpenLinesbyItem_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 item.
What you do hereUse it to follow up backorders per item: the lines customers ordered that haven't shipped yet.
ExampleFor example, item DESK-02 is short at BEAT on 09.11.2026. The report shows 6 open lines for DESK-02 with 58.00 pieces in total, while 30.00 are on hand, so purchasing orders more and sales decides which orders ship first.
Open sales order lines by item 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 item
Set up firstAll sales orders Microsoft Learn
Used next byOpen sales order lines Microsoft Learn
Related pagesOpen sales orders Microsoft Learn
In this process Review open lines by customer · Review open lines by ship date
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 item.
How oftenDaily or on demand.
What the output showsOpen sales order lines grouped by item.

Source: Microsoft Learn

Setup steps on this page

Review open lines by item

Follow up backorders grouped by item.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Sales order reports > Open sales order lines by item.
  2. Filter on the items that are short.
  3. Read the open lines under each item 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 itemFilter on the items that are short.Backorders by item show how many orders wait for one item and whether more must be ordered.Is the by-item view the one this team needs?Comparing the open quantity with on-hand stock only; open purchase orders may already cover the gap.Test: Open line grouped by item

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:CustSalesOpenLinesbyItem_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:CustSalesOpenLinesbyItem_NA
Data migrationLoad order: Open sales order lines by item 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-150, Review open lines by item. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-INQ-150