Check open orders
See what is on the books, what is late, and what is about to ship.Updated Nov 5 2026
The Order List is the backlog report. The same list answers "what is on the books", "what is late", and "what ships next". Only the filters change.
Who this is for
Sales reps and sales managers checking what they have promised, and production planners checking what is due.
Applies to
Why it matters: the backlog is everything promised and not yet shipped. Seeing late and upcoming work early is how you warn a customer or re-plan before a date is missed, rather than after.
-
What you are looking for
- Decide the question before you open the list:
- Everything open: every order not yet closed.
- What is late: open lines whose ship date has passed.
- What ships next: open lines with a ship date in the coming days or weeks.
- Decide whether you need one row per order or one row per line. Per-order is quicker to scan. Per-line shows each part and its dates.
- Decide the question before you open the list:
-
Set the filters and columns
- Open the Order List.
Sales > Orders > Order List. On the redesigned lists the screen is headedOrdersand shows open orders straight away. ClickFiltersto change what it shows. - Check
StatusisOpenfor a backlog. It is the default, near the bottom ofFilters.ClosedandAllare there when you need them. - Set
View BytoHeaderfor one row per order, orLinefor one row per part. It is the first field inFilters. On the classic list it may sit in the advanced filters, which you may need to expand first. - For dates that have passed, set
Ship Date Toto yesterday. Use the calendar picker; typing a date in the field does not register. To include orders due today, end it today and describe the view as "due today or earlier." For upcoming shipments, set both a start and an end date for the period you want to review. - Set
IntercompanytoAllto include build-to-stock orders. It defaults toNo, which limits the view to external customers. - Narrow further as needed:
Customer,Prcpart,Order Type,Location,Transcode,Sent/Emailed, the dock-date and ordered-on-date from/to pairs, and more. - To find what is stuck, use the
Holdfilter. TickDemand,Production,Invoicing, orCredit. - Choose the columns shown with the
Edit columnsicon at the right-hand end of the header row (+/- Columnson the classic list). Your choice is saved for next time.
- Open the Order List.
-
Run the report
- On the Order List (
Sales > Orders > Order List), with the filters set, clickApplyat the bottom ofFilters(Submiton the classic list). - Click a column header to sort by it.
Ship Dateis the useful one for late and upcoming work. Scroll right to reach it.
- On the Order List (
-
Save or export the view
- To hand the report to someone, click
Exportabove the results on the Order List to download it as a file. - To rerun it later, open the list again. Your column choices are saved for you, so only the filters need setting.
- To hand the report to someone, click
Other ways to do this
From the Invoice List
For shipped and invoiced detail rather than open backlog.
- Open the Invoice List.
Sales > Invoices > Invoice List
From the dashboard
A quick look at the same questions, without opening the Order List.
- On your dashboard, click
Customize, thenAdd widget. - Add
Overdue Order. It ages open lines past their ship date or their dock date, your choice, in 0–30, 31–60, 61–90, and 91+ day buckets, by customer or by inside sales rep. - Add
Open Order Lines, headed OPEN ORDER BACKLOG, andBacklog by Customerfor what is open.Backlog by Customeris offered only to Admins and Managers.
By customer
- Open
Sales > Customers > Backlog By Customerand clickSubmit. It lists every customer's open backlog, or one customer's with theCustomerfilter, inPast Due,Backlog, 1 - 30 days…121 +columns, unless your instance sets different buckets. - For a single customer's orders, open the customer, open
Sales +in the left-hand menu, and clickOrders.