payments on ticket orders

Please correct me if I’m making the reading this incorrectly.

There is a newer report (starting in v9.0) that replaces the old standard Daily Sales Report called Ticket Sales by Period.  This report only tallies sales activity on transactions (ie, payments, refunds, or exchanges) and paid seat activity.  In other words, it will not increment reserved, unpaid seats by ticket count or amount.  Sales are only shown when a payment has been made.

If a user books 4 unpaid tickets, nothing will show up on the report.

If a user books and pays off 4 tickets, 4 tickets and the ticket amount will show up on the report.

If a user books 4 unpaid tickets, then only pays off 2 of them,  you will only see 2 tickets and the amount paid on the report.

Hope this makes sense.  I’m over simplifying here slightly, as the report shows all transactional movement (ie Sales, Refunds/Returns, and Exchanges), but the answer above is to help with your situation directly.

+Ryan Creps

+Tessitura Network

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Richard Jackson
Sent: Thursday, October 27, 2011 1:26 PM
To: Ryan Creps
Subject: [Tessitura Ticketing Forum] payments on ticket orders

Hello all,

I've had some inquiries about a report that shows when ticket orders are paid off (or at least when payments on ticket orders are made).  I'll elaborate a bit here:

Our Group Sales department reserves a boatload of seats for various productions well in advance of actual show.  These reserved seats show up on our Daily Sales Report the day the reservation is made.  When the payment(s) come in, nothing shows becuase the order_dt is what shows.  What Group Sales wants to see is when their cash payments typically come in (i.e. we sell X number of seats for Y dollars on 1/1/2011 - those orders are typically paid in March, so...) for planning purposes.

However, in looking around at the system, I don't see a canned report.  Also, while with contributions you can pull by a specific transaction type (pledge payment), there's no such seperate transaction type for ticketing - the only thing I saw I could go on was payment date in T_ORDER_SEAT_HIST.  Our Group Sales is not using the invoicing fucntions as they send a contract out for the larger groups and we don't want the tickets available to print UNTIL they're paid to prevent scanner issues with reprints.

So before I set out writing something custom, I was wondering if anyone has a report or query that pulls this info already.  Any assistance is appreciated.  Many thanks!

RJ

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!

Please correct me if I’m making the reading this incorrectly.

There is a newer report (starting in v9.0) that replaces the old standard Daily Sales Report called Ticket Sales by Period.  This report only tallies sales activity on transactions (ie, payments, refunds, or exchanges) and paid seat activity.  In other words, it will not increment reserved, unpaid seats by ticket count or amount.  Sales are only shown when a payment has been made.

If a user books 4 unpaid tickets, nothing will show up on the report.

If a user books and pays off 4 tickets, 4 tickets and the ticket amount will show up on the report.

If a user books 4 unpaid tickets, then only pays off 2 of them,  you will only see 2 tickets and the amount paid on the report.

Hope this makes sense.  I’m over simplifying here slightly, as the report shows all transactional movement (ie Sales, Refunds/Returns, and Exchanges), but the answer above is to help with your situation directly.

+Ryan Creps

+Tessitura Network

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Richard Jackson
Sent: Thursday, October 27, 2011 1:26 PM
To: Ryan Creps
Subject: [Tessitura Ticketing Forum] payments on ticket orders

Hello all,

I've had some inquiries about a report that shows when ticket orders are paid off (or at least when payments on ticket orders are made).  I'll elaborate a bit here:

Our Group Sales department reserves a boatload of seats for various productions well in advance of actual show.  These reserved seats show up on our Daily Sales Report the day the reservation is made.  When the payment(s) come in, nothing shows becuase the order_dt is what shows.  What Group Sales wants to see is when their cash payments typically come in (i.e. we sell X number of seats for Y dollars on 1/1/2011 - those orders are typically paid in March, so...) for planning purposes.

However, in looking around at the system, I don't see a canned report.  Also, while with contributions you can pull by a specific transaction type (pledge payment), there's no such seperate transaction type for ticketing - the only thing I saw I could go on was payment date in T_ORDER_SEAT_HIST.  Our Group Sales is not using the invoicing fucntions as they send a contract out for the larger groups and we don't want the tickets available to print UNTIL they're paid to prevent scanner issues with reprints.

So before I set out writing something custom, I was wondering if anyone has a report or query that pulls this info already.  Any assistance is appreciated.  Many thanks!

RJ

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!