Delivery Information by Item

You access this report in one of these ways:

  • By clicking the heading of the Delivery Information metric and selecting by Item
  • By clicking the Settings button in one of the other delivery information reports, selecting Select dimension, and selecting Product in the Select Dimension dialog
  • By clicking a dimension element in one of the other delivery information reports and selecting from the menu

The view of the data is filtered by these hierarchies:

  • Order time
  • Delivery time
  • Supplier
  • Ship-from
  • Warehouse
  • Purchase Office
  • Buyer
  • Order reference

To change your view of the data, select from the filter lists. If the lists are not displayed, click the down arrow in the report heading.

The Product hierarchy is selected in the heading of the data table. Each element of the hierarchy forms a row of the report.

You can expand the hierarchy and drill down to view the data at any level.

For each row the report shows this information:

  • Order amount of received lines
  • Number of order lines delivered
  • Average lead time per order line
  • Order quantity
  • Received quantity
  • The percentage of order lines that are complete
  • The percentage of order lines that are on time
  • The percentage of order lines that are complete and on time

You can filter the percentage completeness of order lines with these options:

  • Actual vs. confirmed date
  • Actual vs. planned date
  • Confirmed vs. planned date
Select an option from the list in the table heading.
Note: The on-time delivery percentages do not necessarily total 100% of all order lines because not all order lines have a promised or required delivery date specified.

If you access the report from the Procurement dashboard then, by default, the complete Product hierarchy is selected. You can instead restrict the hierarchy to, for example, the top or bottom 5 Items, measured by one of these metrics:

  • Order amount
  • Number of order lines
  • Average lead time per order line
  • Order quantity
  • Received quantity

To restrict the hierarchy, click Complete Hierarchy and select Top Count or Bottom Count. From the Cut off list, select the number of Items to view. From the Filter by list, select a metric.

If you enable a top count, the elements of the hierarchy are sorted in descending order, by value and the selected measures. For example, the top 5 elements by order amount displays the five elements with the highest order amount first, and the lowest order amount last. A count of the bottom 5 elements by order amount displays the element with the lowest order amount first.

If you access the report from one of the other order information reports, in which you have restricted the hierarchy, the same restriction is automatically applied. To view the complete hierarchy, select Complete Hierarchy.

These are the linked reports:

To access the linked reports, click the Settings icon in the table heading, select Select dimension and select from the Select Dimension dialog. Or click an element in the table and select from the menu.