You can try something along these lines. I did real quick test on this and seems to work but you definitely want to test this yourself. I tested 3 situations, Ticket with no fee, Ticket with one performance level fee, and ticket with two performance level fees.
IF @ude_no = 6 AND
@design_type = 'T'
BEGIN
SELECT
@ude_value = SUM(sl.paid_amt + ISNULL(aaa.fee_amt_paid, 0))
FROM
t_seat s
JOIN T_SUB_LINEITEM sl ON sl.sli_no = @cur_sli_no AND
s.seat_no = sl.seat_no
LEFT JOIN ( SELECT
SUM(fee_amt_paid) AS fee_amt_paid ,
sli_no
dbo.T_SLI_FEE AS a
WHERE
sli_no = @cur_sli_no
GROUP BY
) AS aaa ON aaa.sli_no = @cur_sli_no
END
Marty Jones
Director of Information Services
Omaha Performing Arts 1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tina Treants Sent: Monday, September 12, 2011 10:17 AM To: Martin A. Jones Subject: RE: [Tessitura Ticketing Forum] Add a fee to ticket priceprinted on ticket
Thanks for your response.
We are in the testing phase but would prefer to put it as a fee so that it hits the accounting process correctly and rather than have to change all of our prices.
Tina >>> "Marty Jones" <bounce-martyjones7649@tessituranetwork.com> 09/12/2011 7:21 AM >>>
Is this fee an actual fee being set up under fees as or is it an additional price map?
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Tina Treants Sent: Sunday, September 11, 2011 12:12 PM To: Martin A. Jones Subject: [Tessitura Ticketing Forum] Add a fee to ticket price printed on ticket
Happy Monday
We are in need of adding a gallery fee to each of the theater tickets sold. I know about the User defined elements that can be created using LP_TICKET ELEMENT but wondered if anyone can advise a formula that can be put into the ticket design itself to accommodate this? We want the sum of " price + fee" to print on the ticket .
If anyone has done something like this and can provide the complete design element properties and formula, we would appreciate it.
If the best way really is to do it with the "User-Defined", help with that would also be appreciated.
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!
-- View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/5428/17392.aspx#17392 or reply to this message -- 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!
-- View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/5434/17398.aspx#17398 or reply to this message -- 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!
Marty
Thank you so much for your code! It was exactly what we needed to get us on our way to a solution. We really appreciate your time and expertise! I hope I can "pay it forward" someday.
Tina Treants
Software Application Support Specialist