• Replies 4 replies
  • Subscribers 415 subscribers
  • Views 150 views
  • Users 0 members are here
Related

report that gives ticket numbers?

Tommy Looney
$organization

Is there a report that will give the ticket numbers for an order?

I have an order where 100 tickets were printed but not scanned for a particular performance and I want to manually enter the ticket numbers to record attendance but I dont want to have to reprint the tickets and do it that way.

  • $organization
    On Nov 21, 2009, at 6:36 PM, "Tommy Looney" > wrote:


    Is there a report that will give the ticket numbers for an order?

    I have an order where 100 tickets were printed but not scanned for a particular performance and I want to manually enter the ticket numbers to record attendance but I dont want to have to reprint the tickets and do it that way.



    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!

    ________________________________
    This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.
  • $organization

    Hi,

    I think the Tickets Printed Report will give you that information. It is only filterable by day, but an order  with 100 tickets will stand out!

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tommy Looney
    Sent: Saturday, November 21, 2009 5:37 PM
    To: rbernard@smm.org
    Subject: [Tessitura Ticketing Forum] report that gives ticket numbers?

     

    Is there a report that will give the ticket numbers for an order?

    I have an order where 100 tickets were printed but not scanned for a particular performance and I want to manually enter the ticket numbers to record attendance but I dont want to have to reprint the tickets and do it that way.



    --
    View this message online at: http://www.tessituranetwork.com/COMMUNITY/forums/p/1559/5394.aspx#5394
    --
    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!

  • Former Member
    Former Member $organization
    You can scan tickets into Tessitura (or enter the ticket numbers manually) by going to Season Manager/Record Attendance. 
     
    Bob

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tommy Looney
    Sent: Saturday, November 21, 2009 6:37 PM
    To: Robert Bell
    Subject: [Tessitura Ticketing Forum] report that gives ticket numbers?

    Is there a report that will give the ticket numbers for an order?

    I have an order where 100 tickets were printed but not scanned for a particular performance and I want to manually enter the ticket numbers to record attendance but I dont want to have to reprint the tickets and do it that way.




    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

    We don't have a report but if you have somebody with access to Sql Server Management Studio, here is a query that will help.

     

     

    SELECT

        Distinct

        a.ticket_no

    FROM

        TX_SLI_TICKET a Join

        T_SUB_LINEITEM sl on sl.sli_no = a.sli_no

    where

        sl.order_no = @Order_no

        and sl.sli_status = 12

     

    Marty

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tommy Looney
    Sent: Saturday, November 21, 2009 5:37 PM
    To: Martin A. Jones
    Subject: [Tessitura Ticketing Forum] report that gives ticket numbers?

     

    Is there a report that will give the ticket numbers for an order?

    I have an order where 100 tickets were printed but not scanned for a particular performance and I want to manually enter the ticket numbers to record attendance but I dont want to have to reprint the tickets and do it that way.




    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!