V9 - Open sales order detail report


 

Use case

The Open sales order detail report (Operations > Reports > Sales > Open sales order detail) shows open sales order transactions with unshipped items.

 

While the basics for running any report in SOS Inventory are covered in Reporting introduction and Running a report, the filters, options, and columns specific to the Open sales order detail report are explained below.

 

Filters

From date and To date.

 

Location. Select All or an individual location. All is the default.

 

Item name contains. Type all or part of an item name to display matching items.

 

Customer. Choose a desired customer from the dropdown.

 

Options

Highlight past due dates. Highlights in light red every item on a sales order that has not shipped and is past its due date. This option is enabled by default. You must select the Due Date as a column to see the highlighted orders.

 

Show "from" and "to" dates. If checked, shows a date range at the top of the report, based on your From date and To date filters. The date range appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the header will appear only if you print your spreadsheet. If a header is also entered for the report, the date range will be displayed below the header.

 

Group by. A set of options that allows you to group data on the report. The options include: None, Item, or Customer. The default is None, which orders transactions by date, from oldest to newest. If your Group by option is set to Item or Customer, the report shows the name of each item or customer as a subheading, followed by the associated sales order transactions, which are also organized by date, from oldest to newest. A Total line for each item or customer listed is also displayed.

 

Header. Enter header text for the report, if desired. The header appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the header will appear only if you print your spreadsheet.

 

Footer. Enter footer text for the report, if desired. The footer appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the footer will appear only if you print your spreadsheet and will show above the system-generated text, Report Generated [date] [timestamp].

 

Columns

The default columns for the Open sales order detail report are Order #, Order Date, Customer, Item, Description, Ordered and Backordered. Twenty-four SOS column options are available, as well as any custom fields you have defined for items and sales orders.

 

The order number is a clickable link to its record on the Sales orders list. Columns on the report are sortable.

 

Sample Open sales order detail report

The sample Open sales order detail report below was filtered for a date range from 11/10/2025 to 11/20/2025, with Location set to All. The default option, Highlight past due dates, was enabled. In addition to the default columns (Order #, Order Date, Customer, Item, Description, Ordered and Backordered), Due Date was selected. The Total line displays the sums of the quantities in the Ordered and Backordered columns.

 

The Due Date field for SO-169 is highlighted, showing that the 5 backordered Audio Recording Set items for customer ABC Tech Solutions are past their due date of 11/13/2025.

 

A sample Open sales order detail report