Delivery Export - Order Delivery Time

Report Overview

The Delivery Export - Order Delivery Time report creates an Excel-friendly list of items for a selected event. It is designed for customers who use the order-level delivery date and time feature.

Description

Use the Delivery Export - Order Delivery Time report to create a flat list of items for an event. After running the report, click the blue disk icon in the report parameter area and choose Excel to export the results.

This report is designed for customers who use the order-level delivery date and time feature. The report may return unexpected results if you do not use this feature. 

Available Filters

Use the following filters to select the event, orders, items, and delivery information included in the export.

Field Name Available Values Default
Event Any event in the system None
Status(es) Payment Pending
Confirmed
Cancelled
Closed
Payment Pending
Confirmed
Closed
Order # Any order number No specific order
Order Start Date Any date Beginning of time
Order End Date Any date Today
Delivery Start Any date Event contractor move-in date, or event start date if no move-in date is set
Delivery End Any date Event contractor move-out date, or event end date if no move-out date is set
Revenue Type(s) All revenue types in the system All
Product(s) Any product in the event All products
Delivery Status All
Not Delivered
Delivered
All
Supplier(s) All active suppliers All active suppliers. If you select specific suppliers, the events included depend on whether those suppliers are associated with them.
Customer Type(s) All customer types defined in the store All

Filter Details

Event: Selects the event for the export. No event is selected by default.

Status(es): Filters orders by status. Payment Pending, Confirmed, and Closed are selected by default.

Order #: Selects a specific order or includes orders without limiting the report to one order. No specific order is selected by default.

Order Start Date and Order End Date: Set the order date range. By default, the range begins at the beginning of time and ends today.

Delivery Start and Delivery End: Set the delivery date range. By default, the range uses the event’s contractor move-in and move-out dates. If those dates are not set, the event start and end dates are used.

Revenue Type(s): Selects which revenue types to include. All revenue types are included by default.

Product(s): Filters the export by product. All products in the event are included by default.

Delivery Status: Filters items by whether they have been delivered. All statuses are included by default.

Supplier(s): Selects which active suppliers to include. All active suppliers are included by default. When you select specific suppliers, events are included based on whether those suppliers are associated with each event.

Customer Type(s): Selects which customer types to include. All customer types are included by default.

Sample Report

▤

View Sample Report

Open the Delivery Export - Order Delivery Time spreadsheet to see an example of the exported report.