• Replies 7 replies
  • Subscribers 415 subscribers
  • Views 264 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

  • $organization

    Hi, Lee Ann:

     

    Go to Order Search and do as broad a search as possible. If you don’t need to limit yourself to a particular product (perf or package), select a performance date range that contains everything you are looking for, then set the Seated parameter to No, and make sure that the order date parameters are also as broad as possible. That should work.

     

    Lucie

     

     

    ___________________________________

    Lucie Spieler

    IT Development and Training Manager

    Editor, Season Program

     

    Florida Grand Opera

    8390 NW 25th Street

    Miami, FL 33122

    305.854.1643 x 1521

    Box Office: 800.741.1010

    To Give a Gift: 305.403.3315

    www.FGO.org

     

    2010-2011 | 70TH SEASON | THE MYSTERIES OF LOVE

    Turandot | The Tales of Hoffmann | Don Giovanni | Cyrano

     

  • $organization in reply to Lucie Spieler

    Lucie,

    Thank you.  However I have tried this and itdoes not find the orders.  Any other ideas?

    Lea Ann

  • $organization

    Sometimes I have found orders in our database with wildly wrong dates.  The only other thing I can think of: Are the Paid and Printed parameters and all the other Filter By parameters in Order Search set to (all)?

  • $organization

    Hi Lee Ann,

     

    Are you sure that Season Overview is up to date?  At the bottom of the Season Overview screen it says when the data was last refreshed.  If the Season Overview procedures have stopped running someone may have taken care of those seats since it was last updated.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

  • $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!
  • $organization in reply to Kevin Sheehan

    It is also possible it is not reserved unseated. That line also displays the $ amount of partial payment on partially paid seats (I think, somebody correct me if I'm wrong). So if you have a seat worth $50, and $5 of it is paid, it's an unpaid seated (and the whole seat and $50 are up in Reserved Unpaid, but the $5 received is down in Collected Res/Uns, if I'm remembering right. I spent eons once figuring out what made up that number. So it might be true that you have no unseated tickets. Those might be the fractionally paid seats.

  • $organization

    Amanda is correct.  The Collected Resv/Unseated row includes reserved, partially paid seats.  Here’s the relevant excerpt for the pretty new Season Overview doc:

     

    Collected Resv/Uns – Unseated partially and fully paid seats and partially paid reserved seats.  The amount is the paid amount for counted seats, not the full value of the seats.  As with other sales figures, revenue is broken out between Ticket Price category price maps and all other price map categories.

     

    You can find the whole document here, so no one has to spend eons trying to figure out any of those figures again.  J  I might have thought of Amanda’s great suggestion the last time I posted had I reviewed the document myself.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com