Skip to main content
Try for free

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
Sales
Production

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.

  1. What you are looking for

    1. 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.
    2. 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.
  2. Set the filters and columns

    1. Open the Order List. Sales > Orders > Order List. On the redesigned lists the screen is headed Orders and shows open orders straight away. Click Filters to change what it shows.
    2. Check Status is Open for a backlog. It is the default, near the bottom of Filters. Closed and All are there when you need them.
    3. Set View By to Header for one row per order, or Line for one row per part. It is the first field in Filters. On the classic list it may sit in the advanced filters, which you may need to expand first.
    4. For dates that have passed, set Ship Date To to 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.
    5. Set Intercompany to All to include build-to-stock orders. It defaults to No, which limits the view to external customers.
    6. Narrow further as needed: Customer, Prcpart, Order Type, Location, Transcode, Sent/Emailed, the dock-date and ordered-on-date from/to pairs, and more.
    7. To find what is stuck, use the Hold filter. Tick Demand, Production, Invoicing, or Credit.
    8. Choose the columns shown with the Edit columns icon at the right-hand end of the header row (+/- Columns on the classic list). Your choice is saved for next time.
  3. Run the report

    1. On the Order List (Sales > Orders > Order List), with the filters set, click Apply at the bottom of Filters (Submit on the classic list).
    2. Click a column header to sort by it. Ship Date is the useful one for late and upcoming work. Scroll right to reach it.
  4. Save or export the view

    1. To hand the report to someone, click Export above the results on the Order List to download it as a file.
    2. To rerun it later, open the list again. Your column choices are saved for you, so only the filters need setting.

Other ways to do this

From the Invoice List

For shipped and invoiced detail rather than open backlog.

  1. Open the Invoice List. Sales > Invoices > Invoice List

From the dashboard

A quick look at the same questions, without opening the Order List.

  1. On your dashboard, click Customize, then Add widget.
  2. 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.
  3. Add Open Order Lines, headed OPEN ORDER BACKLOG, and Backlog by Customer for what is open. Backlog by Customer is offered only to Admins and Managers.

By customer

  1. Open Sales > Customers > Backlog By Customer and click Submit. It lists every customer's open backlog, or one customer's with the Customer filter, in Past Due, Backlog, 1 - 30 days … 121 + columns, unless your instance sets different buckets.
  2. For a single customer's orders, open the customer, open Sales + in the left-hand menu, and click Orders.