Custom: Method of Payment Report ?

Hi Ryan

Re your side question ..

For post-event reporting our Box Office required a report on ticket counts as well as value by payment method.

We too struggled with how to count tickets in Orders with more than one production and/or multiple payment methods, but established some basic rules prioritising which method to assign the count to in those scenarios.  

We decided the ticket count would be applied to whichever payment method has the higher value in the order.

 EG: A single $100 ticket paid $60 Visa and $40 Gift Certificate. This would increment ticket count by 1 against Visa, while the $ values would be assigned to the relevant pay types.

Where the payments are exactly the same value (eg $50 cash, $50 Visa) the ticket count is assigned to the "first" payment type – this bit is definitely arbitrary, and I think is just based on how they are ordered in t_payment..

As for how we assign counts to exchanged tix in a payment report …..

Are you on v10.0?  Try the new Performance Transaction Detail report.  Short of price types as a parameter and number of tickets, it should give you a good starting point.

Side question for the group at large…If I buy 2 tickets at $50.00 each (total $100), and pay $75 cash and $25 gift card, how would this show when reporting number of tickets?  As a former box office manager, I was always asked for this type of report, but I could never explain the need for number of tickets, because it’s arbitrary at the end of the day (IMHO).

J

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Bobbie Felser
Sent: Thursday, January 06, 2011 5:07 PM
To: Ryan Creps
Subject: [Tessitura Ticketing Forum] Custom: Method of Payment Report ?

It's me again... :o)

I was curious if anyone has a similar report as I describe below...

In a perfect world a Method of Payment report would have drop downs to select:

 And it would pull up with:

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 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!

Hi Ryan

Re your side question ..

For post-event reporting our Box Office required a report on ticket counts as well as value by payment method.

We too struggled with how to count tickets in Orders with more than one production and/or multiple payment methods, but established some basic rules prioritising which method to assign the count to in those scenarios.  

We decided the ticket count would be applied to whichever payment method has the higher value in the order.

 EG: A single $100 ticket paid $60 Visa and $40 Gift Certificate. This would increment ticket count by 1 against Visa, while the $ values would be assigned to the relevant pay types.

Where the payments are exactly the same value (eg $50 cash, $50 Visa) the ticket count is assigned to the "first" payment type – this bit is definitely arbitrary, and I think is just based on how they are ordered in t_payment..

As for how we assign counts to exchanged tix in a payment report …..

Are you on v10.0?  Try the new Performance Transaction Detail report.  Short of price types as a parameter and number of tickets, it should give you a good starting point.

Side question for the group at large…If I buy 2 tickets at $50.00 each (total $100), and pay $75 cash and $25 gift card, how would this show when reporting number of tickets?  As a former box office manager, I was always asked for this type of report, but I could never explain the need for number of tickets, because it’s arbitrary at the end of the day (IMHO).

J

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Bobbie Felser
Sent: Thursday, January 06, 2011 5:07 PM
To: Ryan Creps
Subject: [Tessitura Ticketing Forum] Custom: Method of Payment Report ?

It's me again... :o)

I was curious if anyone has a similar report as I describe below...

In a perfect world a Method of Payment report would have drop downs to select:

 And it would pull up with:

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 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!