Hello -
We are wondering if there is a way to move money on account from one CID to another, but that "another" account is a completely different person.
The situation is a subscriber account has three tickets for a concert and the "third" person (a friend) owns that third ticket and made an exchange and a credit balance remains on the account. Well the account it is on is the original buyer but belongs to the friend and the friend had said she wants to donate that balance. So the friend should get the tax credit. We print our letter manually but it doesn't accurately reflect in Tess.
I hope this makes sense.
Thank you!
Brian
I’ve saved the sql that creates the report procedure (tracking all uses of a specific payment method for a date range) at:
http://www.tessituranetwork.com/Community/members/luciespieler8144/files/money_5F00_in_5F00_transit.sql.aspx
You’ll have to update the id of the payment method, and you might want to use display_name or sort_name from ft_constituent_display_name() instead of a computed name from t_customer.
Lucie