Order Type Summary by Delivery Type Report

Purpose: This report displays order information summarized by order type and delivery type for orders that were entered within the date range you entered on the Order Delivery Type Summary Screen.

Which orders are included? The report includes order information only for orders whose Order status in the Order Header table is blank (Open), H (Held), X (Closed), or C (Cancelled). The date range you entered on the Order Type Summary screen determines which orders are selected for the report.

How to print: Enter a date range on the Order Delivery Type Summary Screen and select Submit.

For more information: See the sample report in PDF format.

Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.

Contents: A separate line prints on this report for each order type associated with orders entered within the date range you entered on the Order Delivery Type Summary screen. Within each order type, a separate line prints order information for each delivery type. Order information displays on this report in ascending order type, delivery type sequence.

• Start date: The date entered in the Start date field on the Order Delivery Type Summary screen. The report includes orders whose Order date in the Order Header table falls within the specified date range.

• End date: The date entered in the End date field on the Order Delivery Type Summary screen. The report includes orders whose Order date in the Order Header table falls within the specified date range.

• Order Type: The code and description of an order type associated with one or more orders that were entered within the specified date range. From Order type in the Order Header table and Description in Order Type table.

• Delivery Type: A description of the delivery type assigned to orders entered for the order type specified. From Delivery Type in the Order Ship To table.

- No Broker Type = Delivery Type is blank (not defined for the order ship to).

- Delivery = Delivery Type D.

- Store Pickup = Delivery Type P.

- Retail Pickup = Delivery Type R.

- Ship for Pickup = Delivery Type S.

• Number of Orders: The number of orders entered within the specified date range for the order type and delivery type. This is the sum of the qualifying records in the Order Header and Order Ship To tables that are associated with the specified order type and delivery type for the selected date range. Note:

- Multi-recipient orders count as a single order unless a different delivery type is defined for a ship to. For example, a multi-recipient order counts as a single order if the Delivery Type for each ship to is S. However, if the Delivery Type for one ship to is S and the Delivery Type for the other ship to is blank, the order counts as 2 orders.

- This number includes cancelled orders, regardless of whether the cancel reason code used reduces demand.

• Number of Lines: The total number of order lines on the orders entered within the specified date range for the order type and delivery type. This is the sum of the qualifying records in the Order Detail table that are associated with the specified order type and delivery type for the selected date range. Note:

- This number does not include orders cancelled using a cancel reason code that reduces demand.

- This number includes main set items as well as each component item.

• Number of Units: The total number of units on the orders entered within the specified date range for the order type and delivery type. This is the sum of the Qty ordered in the Order Detail table for the selected orders. Note:

- This total does not include orders cancelled using a cancel reason code that reduces demand.

- This total includes main set items as well as each component item.

• Merchandise Amount: The total merchandise amount on the orders entered within the specified date range for the order type and delivery type. This is the sum of the Qty ordered x Price in the Order Detail table for the selected orders. Note: This total does not include orders cancelled using a cancel reason code that reduces demand.

• Average Amount The average merchandise amount on the orders entered within the specified date range for the order type and delivery type. The system uses the following calculation to determine the Average Amount: Merchandise Amount for the order type and delivery type / # Orders for the order type and delivery type = Average Amount for the order type and delivery type.

• Average Number of Lines: The average number of lines on the orders entered within the specified date range for the order type and delivery type. The system uses the following calculation to determine the Average Number of Lines: Lines for the order type and delivery type / # Orders for the order type and delivery type = Average Number of Lines for the order type and delivery type.

• Percentage of Orders: The percentage of all orders entered within the specified date range that are associated with this order type and delivery type. The system uses the following calculation to determine the Percentage of Orders Number of Orders for this order type and delivery type / Total Number of Orders for all order types x 100 = Percentage of Orders.

• Percentage of Amount: The percentage of the total merchandise amount entered within the specified date range that are associated with this order type and delivery type. The system uses the following calculation to determine the Percentage of Amount: Merchandise Amount for this order type and delivery type / Total Merchandise Amount for all order types x 100 = Percentage of Amount

• Totals: Totals across all order types:

- Total Number Orders: The number of orders entered within the specified date range across all order types and delivery types. This is the sum of the Number of Orders across all order types and delivery types.

- Total Number of Lines: The total number of order lines on the orders entered within the specified date range across all order types and delivery types. This is the sum of the Number Lines across all order types and delivery types.

- Total Number of Units: The total number of units on the orders entered within the specified date range across all order types and delivery types. This is the sum of the Number of Units across all order types and delivery types.

- Total Merchandise Amount: The total merchandise amount on the orders entered within the specified date range across all order types and delivery types. This is the sum of the Merchandise Amount across all order types and delivery types.

- Total Average Amount: The average merchandise amount on the orders entered within the specified date range across all order types and delivery types. This is the sum of the Average Amount across all order types and delivery types.

- Total Average Number of Lines: The average number of lines on the orders entered within the specified date range across all order types and delivery types. This is the sum of the Average Number of Lines across all order types and delivery types.