• Replies 7 replies
  • Subscribers 415 subscribers
  • Views 266 views
  • Users 0 members are here
Related

Unseated Seats

Lea Ann Reed
$organization

Hey all! I am having some issues with unseated seats and was hoping someone would know a new or different place to find them.  Season Manager says we have 47 tickets that money has been collected for but are not seated.  I have tried running the Package Seating Report and Single Sale Order Listing to no avail.  I have also tried looking in the order search screen but yet again, nothing.  I would really like to find these and get the money and tickets where they need to go.  Thanks for any help you can give!

Lea Ann Reed
Manager of Sales
Kansas City Repertory Theatre

Parents
  • $organization
    Lea Ann,
     
    I know this will seem a bit roundabout, but this is what we have done for the past four years with excellent success, and it also helps us find orders which have not been paid in full.  If you go to Season Overview, you can scroll through the performances in your season to determine which events have Collected Resv/Uns showing.  Make note of the event/date/times, and go to Ticketing Setup to determine the Performance No from the event setup screen.  Then you can execute the following query in Management Studio to determine the customer numbers on the unseated tickets.
     

    Use Impresario

    Go

    declare @perf_no int

    select @perf_no = 6639 -- insert performance number with balance here

    select o.customer_no, s.order_no, unseated_cnt = IsNull(count(*), 0),

    unseated_amt = IsNull(sum(case

    when p.price_category = 1 then b.paid_amt else 0 end), 0),

    unseated_amt_contribution = IsNull(sum(case

    when p.price_category > 1 then b.paid_amt else 0 end), 0)

    From [dbo].t_perf a (nolock)

    JOIN [dbo].t_sub_lineitem s (nolock) ON a.perf_no = s.perf_no

    JOIN [dbo].t_lineitem l (nolock) ON s.li_seq_no = l.li_seq_no

    JOIN [dbo].t_sli_detail b (nolock) ON s.sli_no = b.sli_no

    JOIN [dbo].t_pmap p (nolock) ON b.pmap_no = p.pmap_no

    JOIN [dbo].tr_price_type r ON s.price_type = r.id

    JOIN [dbo].t_order o on s.order_no = o.order_no

    Where a.perf_no = @perf_no

    and l.primary_ind = 'Y'

    and s.sli_status in (1,2,6)

    and b.paid_amt > 0

    group by o.customer_no, s.order_no

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Lee Ann Reed
    Sent: Wednesday, September 15, 2010 2:32 PM
    To: Lee Schlosser
    Subject: [Tessitura Ticketing Forum] Unseated Seats

    Hey all! I am having some issues with unseated seats and was hoping someone would know a new or different place to find them.  Season Manager says we have 47 tickets that money has been collected for but are not seated.  I have tried running the Package Seating Report and Single Sale Order Listing to no avail.  I have also tried looking in the order search screen but yet again, nothing.  I would really like to find these and get the money and tickets where they need to go.  Thanks for any help you can give!

    Lea Ann Reed
    Manager of Sales
    Kansas City Repertory Theatre




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • $organization
    Lea Ann,
     
    I know this will seem a bit roundabout, but this is what we have done for the past four years with excellent success, and it also helps us find orders which have not been paid in full.  If you go to Season Overview, you can scroll through the performances in your season to determine which events have Collected Resv/Uns showing.  Make note of the event/date/times, and go to Ticketing Setup to determine the Performance No from the event setup screen.  Then you can execute the following query in Management Studio to determine the customer numbers on the unseated tickets.
     

    Use Impresario

    Go

    declare @perf_no int

    select @perf_no = 6639 -- insert performance number with balance here

    select o.customer_no, s.order_no, unseated_cnt = IsNull(count(*), 0),

    unseated_amt = IsNull(sum(case

    when p.price_category = 1 then b.paid_amt else 0 end), 0),

    unseated_amt_contribution = IsNull(sum(case

    when p.price_category > 1 then b.paid_amt else 0 end), 0)

    From [dbo].t_perf a (nolock)

    JOIN [dbo].t_sub_lineitem s (nolock) ON a.perf_no = s.perf_no

    JOIN [dbo].t_lineitem l (nolock) ON s.li_seq_no = l.li_seq_no

    JOIN [dbo].t_sli_detail b (nolock) ON s.sli_no = b.sli_no

    JOIN [dbo].t_pmap p (nolock) ON b.pmap_no = p.pmap_no

    JOIN [dbo].tr_price_type r ON s.price_type = r.id

    JOIN [dbo].t_order o on s.order_no = o.order_no

    Where a.perf_no = @perf_no

    and l.primary_ind = 'Y'

    and s.sli_status in (1,2,6)

    and b.paid_amt > 0

    group by o.customer_no, s.order_no

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Lee Ann Reed
    Sent: Wednesday, September 15, 2010 2:32 PM
    To: Lee Schlosser
    Subject: [Tessitura Ticketing Forum] Unseated Seats

    Hey all! I am having some issues with unseated seats and was hoping someone would know a new or different place to find them.  Season Manager says we have 47 tickets that money has been collected for but are not seated.  I have tried running the Package Seating Report and Single Sale Order Listing to no avail.  I have also tried looking in the order search screen but yet again, nothing.  I would really like to find these and get the money and tickets where they need to go.  Thanks for any help you can give!

    Lea Ann Reed
    Manager of Sales
    Kansas City Repertory Theatre




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
No Data