Orders By Commodity / Organization

Creates a report that consists of Orders for a given Organization(s), for a given commodity, created within the time period selected, grouped by Organization, commodity and submitter, and sorted by create date.

Parameters

The following table lists the parameters that can be set to create a report:

Parameter	Description
Organization	One or more organizations from a list comprised of the session organization and its children organizations, if any.
Currency To Convert To	The currency into which all Order amounts will be converted, for the Actual Price and Extended columns of the report.
Create Date - From	The beginning date for the report's period.
Create Date - To	The ending date for the period covered by the report.
Commodity	One or more commodities from a list comprised of the top-level commodities used by all outstanding Orders.

Column Description

The following table lists the column names and descriptions of the report:

Column	Description
Date Created	When the Order was created.
Order Number	The number assigned to the Order.
Supplier	Name of Order's supplier.
Part Number	Number assigned by the buyer to the part being ordered.
Part Description	Name of the part being ordered (buyer's description.)
Quantity	Number of parts being ordered.
Converted Price	The unit price for the item, converted into the currency the user selected on the report's parameters page.
Extended Price	The Converted Price multiplied by the Quantity.