Gift Certificate Reports

I don't know of a report (custom or otherwise) that will list all Gift Certificates sold, even if they are totally used up. However the code is very simple. Thus:

select g.gc_no, sum(pmt_amt) from t_payment p
        join t_gc g on p.payment_no = g.payment_no
    where pmt_method = 76   -- Replace with your payment method number
    group by g.gc_no

Run this, copy the results to excel and count/sum to your hearts content.

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!

I must not have that report.  All I have is Gift Certificate Details and Gift Certificate Expiration, which don’t have that option.  Does anyone else have it?

Leslie Fillingham, Finance Director

Milwaukee Repertory Theater

414-224-1761

We use the Gift Certificate Report with a date range and then select (all) for the criteria Outstanding Only?.

This report gives us a listing of all the gift certificates sold for the specified period.  It also gives us information about the transactions, balances, and customers.

I don't know of a report (custom or otherwise) that will list all Gift Certificates sold, even if they are totally used up. However the code is very simple. Thus:

select g.gc_no, sum(pmt_amt) from t_payment p
        join t_gc g on p.payment_no = g.payment_no
    where pmt_method = 76   -- Replace with your payment method number
    group by g.gc_no

Run this, copy the results to excel and count/sum to your hearts content.

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!

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!

I must not have that report.  All I have is Gift Certificate Details and Gift Certificate Expiration, which don’t have that option.  Does anyone else have it?

Leslie Fillingham, Finance Director

Milwaukee Repertory Theater

414-224-1761

We use the Gift Certificate Report with a date range and then select (all) for the criteria Outstanding Only?.

This report gives us a listing of all the gift certificates sold for the specified period.  It also gives us information about the transactions, balances, and customers.

I don't know of a report (custom or otherwise) that will list all Gift Certificates sold, even if they are totally used up. However the code is very simple. Thus:

select g.gc_no, sum(pmt_amt) from t_payment p
        join t_gc g on p.payment_no = g.payment_no
    where pmt_method = 76   -- Replace with your payment method number
    group by g.gc_no

Run this, copy the results to excel and count/sum to your hearts content.

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!

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!