Edit

Share via

Inventory Order Details (report)

The Inventory Order Details report shows each sales order and the line-level breakdown for each item (such as the order number, customer's name, shipment date, order quantity, delayed quantity, outstanding quantity, and unit price). The information includes unfulfilled shipments, applied line and invoice discounts, and the total amount on order.

Lines with a shipment date in the past are included in the quantity on back order.

Available layouts

INTRODUCED IN: Business Central 2025 release wave 2.

The report includes different layouts for different use cases:

  • An Excel layout with worksheets designed for print and for analysis.
  • A Word layout designed for print/PDF output.

You can export either layout from the Report Layouts, edit it in Excel or Word to cater for your needs, and import it back to Business Central. To learn more, go to Creating your own report layouts.

Use cases

Analyze outstanding sales orders to understand expected sales volumes for items. To highlight overdue back orders, compare overall outstanding shipments with the planned shipment dates.

Sales representatives use the report to:

  • Track order status to keep customers updated.
  • Spot potential shipment issues to manage customer expectations.
  • Determine which orders to prioritize, based on shipment status and expected delivery dates.

Sales managers use the report to:

  • Understand expected sales volumes for items by analyzing outstanding sales orders.
  • Highlight overdue back orders by comparing overall outstanding shipments with the planned shipment date.
  • Address customer complaints proactively by identifying shipments that are delayed or at risk of being delayed.

Logistics coordinators use the report to:

  • Optimize shipment schedules by monitoring back orders.
  • Prevent revenue leakage by ensuring accurate discount application.
  • Proactively address potential issues and ensure that shipments are on schedule.

Try the report

Try the report here: Inventory Order Details

Tip

If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.

Sales reports
Ad hoc analysis of sales data
Sales analytics overview

Find free e-learning modules for Business Central here

  • Last updated on