The Open sales receipt detail report (Operations > Reports > Sales > Open sales receipt detail) shows open sales receipts 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 receipts detail report are explained below.
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.
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].
The default columns for the Open sales receipt detail report are Order #, Order Date, Customer, Item, Description, Ordered and Backordered. Twenty-three 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 receipts list. Columns on the report are sortable.
The sample Open sales receipt detail report below was filtered for a date range from 11/01/2025 to 11/30/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 fields for SR-8 and SR-9 are highlighted. They show that the 4 backordered Air Duster Pro items for customer BlueWave Media, as well as 1 Austrian Mantel Clock for customer Al Latimer are past their due dates.
