Delivery By Product

  • This report provides a list of all products ordered as well as the exhibitors who ordered them. A key parameter that substantially changes the way the report looks is the "Use Attributes To Group" parameter.  The first example below is set to "No", and the second example is set to "Yes".  As shown in the results, it is the difference of tables being grouped by their size and not additionally by the color of the skirt. 

    mceclip0.png

     

     

  • Field Name Available Values Default
    Event

    Any event(s) in the system

    None 

    Print Product Codes

    No
    Yes
    No

    Revenue Type(s)

    All revenue types that have been defined in the system

    All 

    Status(es)

    Payment Pending
    Confirmed
    Cancelled
    Closed
    Payment Pending
    Confirmed
    Closed

    Product(s)

    None  If desired, print a delivery report for selected products only.

    Create Start Date/Time

    Any date and or date/time (for time format, enter 3/11/2012 8am for example).

    Beginning of time

    Create End Date/Time

    Any date and or date/time (for time format, enter 3/11/2012 3pm for example).

    Now 
    Order Modify Start Date/Time

    Any date and or date/time (for time format, enter 3/11/2012 8am for example).

    Beginning of time

    Order Modify End Date/Time

    Any date and or date/time (for time format, enter 3/11/2012 3pm for example).

    Now
    Item Modify Start Date/Time Any date and or date/time (for time format, enter 3/11/2012 8am for example).
    Will return only items that have been modified between the start and end date defined.

    Beginning of time

    Item Modify End Date/Time

    Any date and or date/time (for time format, enter 3/11/2012 3pm for example).

    Now 
    Page Break Between Products No
    Yes
    No

    Delivery Status

    All
    Not Delivered
    Delivered
    All

    Sort Exhibitors By

    Booth
    Exhibitor
    Booth

    Customer Type(s)

    Exhibitor
    EAC
    Show Organizer

    All customer type(s)

    Location(s)

    Any location(s) that have been defined within the exhibit booths for the event.

    All Locations
    Pavilion(s)

    Any pavilion(s) that have been defined within the exhibit booths for the event.

    All Pavilions

    Group By None
    Location
    Event
    None
    Use Attributes to Group
    Yes
    No

    Determines whether products such as tables are grouped by both dimensions as well as skirt color (see attached sample).
    Yes

    Supplier(s)

    All suppliers used in the event.

    All suppliers

    Include Bundle Parents

     

    No
    Yes

    No

    Use Numeric Code as Weight

    No
    Yes

    No

  • Delivery By Product No Attribute Group By
    Delivery By Product With Attribute Group By