• Replies 3 replies
  • Subscribers 414 subscribers
  • Views 76 views
  • Users 0 members are here
Related

Pulling a list of unpaid groups

Nicole Wetzell
$organization

Hello - I was wondering if anyone has some advice on pulling a list of groups who have reserved their seats in an order, but not paid for them. I tried various combinations (i.e. <> $0, =< $0, => $0, etc) in Ticket History Amount and added a Ticket History Season and MOS Group Sales to the order. Nothing is pulling the correct list Any help is appreciated. Thanks!

  • $organization

    Hi Nicole,

    There are a few options for you. You can use the Order Search screen (in a ticket order, or in Season Manager) to find these orders based on Paid/Unpaid status and save the results to a list with the List button. Or you could run the Single Sale Order Listing report limited to unpaid orders only, and save those results to a list. 

    http://www.tessituranetwork.com/Help_System_v125/Content/Ticket_Order_Processing/Order%20Search.htm

    http://www.tessituranetwork.com/Help_System_v125/Content/Reports/Single%20Sale%20Order%20Listing.htm

    http://www.tessituranetwork.com/Help_System_v125/Content/Reporting%20Overview/Output.htm (Save As List section)

    -Michael Wilcox, Tessitura Network

  • $organization

    I would use T-Stats.

     

    Cube: Seats

    Measures: Reserved Val or Reserved Num

    Filter: Group Sales Price Types

     

    Dani Meister

    Manager, Ticketing and Sales

    Balboa Park Cultural Partnership

    1549 El Prado, Suite 2

    San Diego, CA 92101

    dani.meister@bpcp.org

    Office: (619) 232-7502 x1208

     

    From: Tessitura Group Sales Forum [mailto:forums-groupsales@tessituranetwork.com] On Behalf Of Nicole Wetzell
    Sent: Monday, July 25, 2016 11:42 AM
    To: dani.meister@bpcp.org
    Subject: [Tessitura Group Sales Forum] Pulling a list of unpaid groups

     

    Hello - I was wondering if anyone has some advice on pulling a list of groups who have reserved their seats in an order, but not paid for them. I tried various combinations (i.e. <> $0, =< $0, => $0, etc) in Ticket History Amount and added a Ticket History Season and MOS Group Sales to the order. Nothing is pulling the correct list Any help is appreciated. Thanks!




    You have been sent this message because you subscribed to the Tessitura Group Sales forum. You may manage your subscriptions on the website in the forums under "Forum Email Subscriptions".

  • $organization

    Thank you, Michael and Dani, for the answers.

     

    Michael, pulling the single sale order listing report and saving to a list was exactly what I was looking for as I wanted to suppress from an extraction.

     

    Nicole Wetzell

    Director of Sales

     

    50 E Congress Pkwy | Chicago IL 60605-1214

    Direct: 312.341.2356 | Fax: 312.341.2360

    Ticket Services Center: 312.341.2300

     

    Give today to support the Auditorium’s Hands Together, Heart to Art™ camp, celebrating the healing power of creative play.

     

    From: Tessitura Group Sales Forum [mailto:forums-groupsales@tessituranetwork.com] On Behalf Of Michael Wilcox
    Sent: Monday, July 25, 2016 2:38 PM
    To: Nicole Wetzell
    Subject: Re: [Tessitura Group Sales Forum] Pulling a list of unpaid groups

     

    Hi Nicole,

    There are a few options for you. You can use the Order Search screen (in a ticket order, or in Season Manager) to find these orders based on Paid/Unpaid status and save the results to a list with the List button. Or you could run the Single Sale Order Listing report limited to unpaid orders only, and save those results to a list. 

    http://www.tessituranetwork.com/Help_System_v125/Content/Ticket_Order_Processing/Order%20Search.htm

    http://www.tessituranetwork.com/Help_System_v125/Content/Reports/Single%20Sale%20Order%20Listing.htm

    http://www.tessituranetwork.com/Help_System_v125/Content/Reporting%20Overview/Output.htm (Save As List section)

    -Michael Wilcox, Tessitura Network

    From: Nicole Wetzell <bounce-nicolewetzell3052@tessituranetwork.com>
    Sent: 7/25/2016 2:35:41 PM

    Hello - I was wondering if anyone has some advice on pulling a list of groups who have reserved their seats in an order, but not paid for them. I tried various combinations (i.e. <> $0, =< $0, => $0, etc) in Ticket History Amount and added a Ticket History Season and MOS Group Sales to the order. Nothing is pulling the correct list Any help is appreciated. Thanks!




    You have been sent this message because you subscribed to the Tessitura Group Sales forum. You may manage your subscriptions on the website in the forums under "Forum Email Subscriptions".