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