• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 37 views
  • Users 0 members are here
Related

Modifying Ticket Order Billing Report

Matthew Hodge
$organization

Hi all,

We were interested in doing some invoicing for our schools program on Tessitura (this is our first year doing schools out of Tess), but the invoices from last year that we're trying to replicate include a breakdown of the cost per child attending a concert.

In other words, we'd love an invoice that included a unit cost and price type. The Ticket Order Billing report looks great in terms of functionality for this kind of thing, but it doesn't have price type, making it a problem.

Has anyone ever tried modifying this report to include further detail about the report? It's not exactly easy, because it uses the interim System Window type instead of running straight through Infomaker. I just thought I'd check, in case there was a billing report out there that I could borrow.

 

Cheers,

 

Matt

  • $organization

    I should say - further to that - I'd be happy to try playing with an existing one, but I'm not entirely sure which stored procedure feeds into that report. There's TP_ORDER_BILLS, but that doesn't contain all the performance details like you see in Ticket Order Billing. Is there another procedure that I should know about?

  • $organization

    The procedure that you want is TP_ORDER_ACK.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hodge
    Sent: Sunday, May 22, 2011 11:27 PM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] Modifying Ticket Order Billing Report

     

    I should say - further to that - I'd be happy to try playing with an existing one, but I'm not entirely sure which stored procedure feeds into that report. There's TP_ORDER_BILLS, but that doesn't contain all the performance details like you see in Ticket Order Billing. Is there another procedure that I should know about?

    From: Matthew Hodge <bounce-matthewhodge3604@tessituranetwork.com>
    Sent: 5/23/2011 1:21:40 AM

    Hi all,

    We were interested in doing some invoicing for our schools program on Tessitura (this is our first year doing schools out of Tess), but the invoices from last year that we're trying to replicate include a breakdown of the cost per child attending a concert.

    In other words, we'd love an invoice that included a unit cost and price type. The Ticket Order Billing report looks great in terms of functionality for this kind of thing, but it doesn't have price type, making it a problem.

    Has anyone ever tried modifying this report to include further detail about the report? It's not exactly easy, because it uses the interim System Window type instead of running straight through Infomaker. I just thought I'd check, in case there was a billing report out there that I could borrow.

     

    Cheers,

     

    Matt




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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

    Thanks for that – I’ll have a look around and check it out.

     

     

    Cheers,

     

     

    Matt




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!