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
Open the Delivery Export - Order Delivery Time spreadsheet to see an example of the exported report.