Hi all
We have had a problem with fees doubling where events in 2 different seasons are sold together in an order (we have a flat-rate transaction fee). At the moment Ticket Office staff manually remove the second fee, but it does occasionally happen online as well. We have not had any custom code written to stop this (yet).
I remember seeing this on the enhancement lists over the last few years but I'm not sure if a solution came with any of the upgrades.
Does anyone happen to know anything about this?
Thanks!
Katie.
The only way we’ve been able to avoid the operators having to alter the fees is to manually select which performances in the new fiscal year receive the new fee. It’s sort of a pain to remember to do when adding the performance but once we stop selling to the old fiscal year, we can just go back to selecting “all”.
Susan M. Crockett
Chief Information Officer
Ruth Eckerd Hall & The Historic Capitol Theatre
1111 N. McMullen Booth Rd. l Clearwater, FL 33759
727.712.2757 l Fax: 727.791.6020
scrockett@rutheckerdhall.net
Facebook Twitter YouTube
Tickets to all of our great shows are on sale now at RuthEckerdHall.com
This email and any files transmitted with it are confidential and intended solely for the use of the intended individual or entity. If you have received this email in error please notify the sender. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information received in error is strictly prohibited.
From: Duane Woods [mailto:bounce-duanewoods8158@tessituranetwork.com] Sent: Friday, April 15, 2011 1:57 PMTo: Susan CrockettSubject: Re: [Tessitura Ticketing Forum] RE: Doubling Fees
Has there been a solution or enhancement in the past couple of years to resolve this issue, of double charging order fees when a shopping cart contains product from two different fiscal years? This is the first year we have productions on sale across two fiscal years, and is now an issue for us.
Thanks,
Duane
From: Chris Campbell <bounce-chriscampbell8862@tessituranetwork.com>Sent: 12/16/2009 6:26:43 AM
Hi, everyone -
We've got the same thing right now, too - again, because they span the financial year. It would be great if anyone had any creative ideas around it!
C.//X.
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!
We also have this problem. With website orders the operator can't remove the extra fee so we have worked around this by adding the following code to the WP_ADD_FEES_TO_CARD SP after the execute dbo.TP_CALC_FEES call.
Obviously any changes to Tessitura SP's must be done with caution and need to be re-applied after any system version updates.
Hopefully the enhancement will be implemented in a release soon.
SQL Code below:
--DH TEMP FIX: REMOVE MULTIPLE POSTAGE FEES
delete @fees
--select *
from @fees tf
join t_fee f on f.fee_no = tf.fee_no
where f.category = 0 --category 0 = Online Postage Fee
and f.fee_no = 11 --only the standard postage fee
and tf.id NOT IN(select top 1 tf.id
order by f.fiscal_year desc
)
Dara
Well its been 9 years and fees at an order level are still doubling when performances purchased in an order cross financial years. Since changing the web site would costs us £££, we chose to add your modification to WP_ADD_FEES_TO_CARD. We are testing at the moment and so far it is working! Thank you!
No problem Roberta Harrill,
Glad it works. As Gregg mentioned it would be better if this was party of the core application.
I did log an enhancement request for this 9 years ago, but it will need others to do the same for it to be an feature worth implementing in the core product.