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?
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