So I think I know the answer but just wanted to field some possibilities:
We have a situation where a ticketing payment was made in the wrong account and now need to transfer the payment to the correct account. Is there a way do this without refunding the credit card?
Hi Julie,
I don't know if this is best practice - and I've never done it for Ticket payments, but rather Contributions, but I've avoided refunding a customer's card and recharging by putting the money in your company's Suspense Account. Use the Payment Method associated to this sort of "holding pot" G/L and then use the same payment when reentering to the correct customer's account.
Best to let your Finance department know...
Frannie
Thanks Franny! This is helpful. We are currently working with our accounting department to figure something out and they were sort of on this path so we'll continue on.
You can refund to a gift certificate and use that for payment. Just remember to delete the credit card off the wrong record.
_______________________________________________________ Karen Diche Manager, Season Tickets Segerstrom Center for the Arts 600 Town Center Drive, Costa Mesa, CA 92626 T (714) 556-2122 x 4359 F (714) 755-7477 E KDiche@SCFTA.org
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Julie Gregorchuk Sent: Tuesday, August 28, 2012 9:07 AM To: Karen Diche Subject: [Tessitura Ticketing Forum] Moving payment from one constituent account to another
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 have a payment method for this called “Money in Transit” that is tied to our suspense account. We’ve been using this for both tickets and contributions (always documented in order notes or contribution notes) for years, and only a couple of employees here have access to this payment method. I set up a monthly report to audit Money in Transit when we discovered discrepancies where funds were not moved entirely correctly. The report takes all transactions using this payment method, and returns enough information about them so that you can track issues, if there are any. The final balance of these transactions for any given time period of a day or longer should be $0, of course, so when the balance isn’t $0, you need to find out why not. (In over 7 years, we’ve had this issue a couple of times.)
Here’s the procedure, if anyone would like to use it. (You’ll have to substitute your own payment method in place of 58 below.)
---------------------------------------------------------Money in Transit payment method id
select a.*,
cast ( floor( cast(a.pmt_dt as float)) as datetime) as 'float'
from @money_in_transit a
where a.pmt_dt between @start_dt and @end_dt
_____________________________Lucie SpielerIT Development and Training Manager
Editor, Season Program BookFLORIDA GRAND opera
Well, all the code for my little Money in Transit report procedure disappeared when I hit “send.” I’d be happy to send it to you off forum.
lspieler@fgo.org