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 Options Product Codes
    Admin Notes
    Neither
    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