The Delivery Export report creates an Excel-friendly list of items for a selected event. Filter the results by order status, delivery dates, product, supplier, and delivery status.
Description
Use the Delivery Export 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.
Available Filters
Use the following filters to select the event, 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 |
| 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 |
| Column Format | Standard Contact Info Edlen Freeman Electrical Contact With Address Info Item Details with Onsite Info |
Standard. Edlen is for use when Boomer is integrated with Edlen. Freeman Electrical provides a format compatible with ExpoCad. |
| Product Code | 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. |
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.
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.
Column Format: Selects the layout of the exported columns. Standard is selected by default. Use Edlen when Boomer is integrated with Edlen. The Freeman Electrical format is compatible with ExpoCad.
Product Code: 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.
Sample Report
Open the Delivery Export Spreadsheet to see an example of the exported report.