Quick script to calculate # of credit card transactions?

Do you have payment method groups set up? You could calculate all the payment methods in the credit card group. That is easier than specifying all the payment methods.

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hodge
Sent: Tuesday, February 28, 2012 5:16 PM
To: Gloria Ormsby
Subject: [Tessitura Technical Forum] Quick script to calculate # of credit card transactions?

I'm trying to work out how to calculate how many credit card transactions we ran through Tessitura last year. I was assuming that it was just the count of distinct payment_nos in T_PAYMENT that had a credit card type of pmt_method.

But is there some other catch to it all that I should know about?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

Do you have payment method groups set up? You could calculate all the payment methods in the credit card group. That is easier than specifying all the payment methods.

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hodge
Sent: Tuesday, February 28, 2012 5:16 PM
To: Gloria Ormsby
Subject: [Tessitura Technical Forum] Quick script to calculate # of credit card transactions?

I'm trying to work out how to calculate how many credit card transactions we ran through Tessitura last year. I was assuming that it was just the count of distinct payment_nos in T_PAYMENT that had a credit card type of pmt_method.

But is there some other catch to it all that I should know about?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!