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.

Important: When you generate this report if the report contains no data, the system may print a generic document with the following information:

The requested document is not currently implemented: MSR1174RPT

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.

• # 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.

• # 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.

• # 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.

• Merch $: The total merchandise dollars 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.

• Avg $: The average merchandise dollars 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 Avg $: Merch $ for the order type and delivery type / # Orders for the order type and delivery type = Avg $ for the order type and delivery type.

• Avg Lns: 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 Avg Lns: # Lines for the order type and delivery type / # Orders for the order type and delivery type = Avg Lns for the order type and delivery type.

• % 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 % Orders: # Orders for this order type and delivery type / Total # Orders for all order types x 100 = % Orders.

• % Dollars: The percentage of all merchandise dollars 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 % Dollars: Merch $ for this order type and delivery type / Total Merch $ for all order types x 100 = % Dollars.

• Totals: Totals across all order types:

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

- Total # 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 # Lines across all order types and delivery types.

- Total # 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 # Units across all order types and delivery types.

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

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

- Total Avg Lns: 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 Avg Lns across all order types and delivery types.