Order Reference by Product

You access this report in one of these ways:

  • By clicking the heading of the Order Reference metric and selecting by Item
  • By clicking the Settings button in one of the other order reference reports, selecting Select dimension, and selecting Product in the Select Dimension dialog
  • By clicking a dimension element in one of the other order reference reports and selecting from the menu

The report analyzes a metric selected from the Measure hierarchy, filtered by these hierarchies:

  • Order time
  • Delivery time
  • Supplier
  • Ship-from
  • Ship-to
  • Buyer
  • Purchase Office
  • Status

These are the metrics available in the Measure hierarchy:

  • Order amount
  • Number of order lines
  • Average order line amount
  • Order quantity
  • Unit price

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.

By default, for each row, the report shows what numbers and what percentages of orders have these as their source:

  • Sales order
  • Contract
  • Requisition
  • Dropshipment

A total for each row is also displayed.

If a selected Item is a base element, its Base Unit of Measure is displayed.

You can display additional or different sources. Click the Settings icon in the table heading and select Configure columns. In the Select visible elements dialog, select the sources to display. You can display these additional sources:

  • Contract applicable but not used
  • Linked to RFQ
  • Linked to Itemion order

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.