Having an issue with Ticket count by payment method by mode of sale. Now I KNOW this can't be done. I have gotten the official word that this can't be done and have always known this couldn't be done. But...
There are certain promoters and or traveling shows that require this kind of break out and I can not possibly be the only one that is required to provide this break out to them.
Is there anybody willing to share their code to help with this. I can't even get close. Maybe you have some sort of work around like dumping the ticket counts into the first payment method of a split payment lineitem.
Would appreciate any help or guidance.
Thanks,
Marty
Hi Marty
We haven’t had to report on Payment Method by Mode Of Sale, but we did need to do a ticket counts by Payment Method report as part of the post-event suite of reports we provide to our presenters.
Ticket Counts on mixed payments was a problem so yes there is a degree of ambiguity but it’s within an acceptable range.
We decided to assign the ticket count to the highest value payment in the transaction. Only where both are the same value does the count go to the “first” payment method in the order.
On the report we have a disclaimer that says: When an order is paid by more than one payment method the ticket count for the order is assigned in total to the payment method of the highest value.
Im happy to share if you think this will help.
Regards
Peter
PS:
You might be interested in another tricky scenario we had to deal with regarding exchanges when developing the report.
We had a customer exchange perfs and also buy an extra ticket, but using a different payment method to the original purchase.
Scenario:
A Mastercard sale of 2 tickets is exchanged to another performance and an extra seat added.
The upgrade is paid by Visa.
The original Mastercard value stays with this perf, but an equivalent negative value is added to the (exchange) tally.
The ticket count against Mastercard is reduced by 2 (ie zero in this performance).
A value for the upgrade difference is applied to the value of Visa.
A value for the original tix is applied as a positive value against (exchange).
(Essentially this means the order is mixed payment of Visa and (exchange))
In accordance with our rules on mixed payments the ticket count of 3 updates the payment type which is the higher value in the new transaction : ie either to Visa or (exchange). In this case (exchange) was higher so all three tix are tallied here.
peter nelson business analyst
information systems
pnelson@SYDNEYOPERAHOUSE.COM
T+61 2 9250 7180 F+61 2 9251 7821
SYDNEY OPERA HOUSE BENNELONG POINT
GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA
SYDNEYOPERAHOUSE.COM
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Marty Jones Sent: Wednesday, 13 May 2009 07:41 To: Peter Nelson Subject: [Tessitura Ticketing Forum] Need Help
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 consider the environment before printing this email. =====This message is intended for the addressee(s) named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
Marty,
We don't report on ticket count by payment method and mode of sale (although we are constantly asked about it), but we do report on payments by mode of sale and payment method. I've uploaded our report to my files area if you want to take a look at it.
I've played around a little with trying to connect t_order_seat_hist to t_transaction/t_payment based on the date time stamp but I've never had enough time to see if I could make it work. (If Chuck is listening, if we could get the transaction_no added to t_order_seat_hist for all of the money events we could report on this easier, I think - I keep meaning to submit an enhancement request for this).
Please share anything you come up with on this - I hate telling our presenters we can't give them the information they need (especially when they say they can get it from other places that use the evil ones).
-steve carlock
Santa Barbara Center for the Performing Arts/The Granada
Hi Steve
I sent Marty a copy of our Stored Procedure and he has reported that it worked on their data with minimal local tweaking (i thought we may have customised it too much but apparently not).
So if youre still interested in a Ticket counts by Payment Method report (using our highest-value-gets-the-count model) report let me know.
(and yes ... our report also came out of a determination to match whatever presenters say they can get from the other side)
Hi,
I would be very interested in the report you mention, as we are going to have to start reporting this way soon.
Thanks,Caryl
Hi Caryl
Ive uploaded three files to my profile - the SQL code (which is based on Tessitura's RP_PMTS_BY_PERF_NEW), xml file for Report Setup and a sample of the rep (a bit dull visually but we use this as a subreport of a bigger (more attractive!) post event suite).
I didnt include a pbl as the output is quite easy to group. Note in the SQL there is some now redundant code to do with calculation of CC commissions which you can ignore.