Hello,
I am looking for a report that will tell me how many gift certificates we have sold and their current value.
Has anyone crafted this beauty or has a tricksy way of building a list to capture this info?
Thanks!
Becci Strickland
TPAC Box Office Manger
Becci,
The Gift Certificate Expiration Utility (Finance category) can be used in a review-only mode to get a brief (one-line) list of each gift certificate currently outstanding, its original value and its current value. Out-of-the-box parameters only allow the selection of one gift certificate payment method, but it could be modified to allow multiple selection.
Be careful with relying on this report - because it’s real purpose is to expire/write-off GCs that have a balance it ignores Certificates that have a nil balance. So if a GC is purchased and then fully redeemed its like it NEVER happened!
It works if youre only interested in those with a current balance, but you’ll need customised reporting to get a count of how many GCs you’ve actually sold within a period that includes those fully redeemed.
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 Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Jonathan Smillie Sent: Friday, 16 October 2009 08:17 To: Peter Nelson Subject: Re: [Tessitura Shared Reports Forum] Gift Certificate Reports
From: Becci Strickland <bounce-beccistrickland7719@tessituranetwork.com> Sent: 10/15/2009 3:30:10 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the 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=====
Thanks all!
I had figured that the Expire Utility would be a place to start…however it makes me super nervous.
I am looking for a full record though…any one got a custom report that does this?
From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Peter Nelson Sent: Thursday, October 15, 2009 5:33 PM To: Becci Strickland Subject: RE: [Tessitura Shared Reports Forum] Gift Certificate Reports
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=====