Matching Gift Adjustments

Hi Jan,

I've come across this same issue before and sadly I have not had the chance to try all the options below but I did open a ticket and this was the information that was supplied.

 

The two types of credits you can adjust are Matching Gifts and gifts credited on the Matching/Credit tab. When you make an adjustment to a credited gift you will need to make adjustments for the credits as well for T_CREDITEE to be updated properly.
For a matching gift:
1. Make the adjustment to the original gift using the Adjust button.
2. Load the Matching Contribution.
3. Adjust the matching contribution appropriately for the matching ratio.
4. Before clicking saving the contribution on the matching adjustment go to the Matching/Credit tab.
5. In the Credit Window you should see the credit. Delete the credit for the original amount.
6. Add a new credit with the adjusted amount with a creditee type of Matching Gift. (Or whichever creditee type is appropriate.)
7. Save the contribution

For a credited gift adjustment load the original contribution; make the adjustment and then go to step 4 of the above steps. In step 6 select the appropriate creditee type.

When you are trying to remove benefits or delete any type of creditee that involves a membership transaction, change the creditee type to a creditee type that doesn't affect memberships. Save your changes.  If you are working in a controlled batch, you have to close and post your batch after changing the creditee type.  Then try deleting the creditee record on the Matching/Credit tab in contribution entry.  Lastly, you have to manually adjust any affected memberships.

Hi Jan,

I've come across this same issue before and sadly I have not had the chance to try all the options below but I did open a ticket and this was the information that was supplied.

 

The two types of credits you can adjust are Matching Gifts and gifts credited on the Matching/Credit tab. When you make an adjustment to a credited gift you will need to make adjustments for the credits as well for T_CREDITEE to be updated properly.
For a matching gift:
1. Make the adjustment to the original gift using the Adjust button.
2. Load the Matching Contribution.
3. Adjust the matching contribution appropriately for the matching ratio.
4. Before clicking saving the contribution on the matching adjustment go to the Matching/Credit tab.
5. In the Credit Window you should see the credit. Delete the credit for the original amount.
6. Add a new credit with the adjusted amount with a creditee type of Matching Gift. (Or whichever creditee type is appropriate.)
7. Save the contribution

For a credited gift adjustment load the original contribution; make the adjustment and then go to step 4 of the above steps. In step 6 select the appropriate creditee type.

When you are trying to remove benefits or delete any type of creditee that involves a membership transaction, change the creditee type to a creditee type that doesn't affect memberships. Save your changes.  If you are working in a controlled batch, you have to close and post your batch after changing the creditee type.  Then try deleting the creditee record on the Matching/Credit tab in contribution entry.  Lastly, you have to manually adjust any affected memberships.

Also I was told that if none of these work and the credit is zero you can run the following statement replacing the *** with the appropriate id numbers.
(testing is of course always advised)

use impresario
go
delete t_creditee
where ref_no = ***
and creditee_no = ***

Thank you, Ryan.  I'll add this to our Development Batch list of things to watch out for.

Jan

Thanks, Ryan, we didn't know about that one. We'll give it a try.

Jan LaRocque
Manager, Patron Database
Houston Symphony
713-238-1419
jan.larocque@houstonsymphony.org

Sign up for Houston SymphonE-News at http://www.houstonsymphony.org






"Ryan Rowell"

l5634@tessiturane To
twork.com> jan.larocque@houstonsymphony.org
Sent by: cc
"Tessitura
Development Subject
Forum" Re: [Tessitura Development Forum]

nt@tessituranetwo
rk.com>


06/03/2009 03:42
PM


Please respond to
"Tessitura
Development
Forum"

nt@tessituranetwo
rk.com>






Hi Jan,


I've come across this same issue before and sadly I have not had the chance
to try all the options below but I did open a ticket and this was the
information that was supplied.





The two types of credits you can adjust are Matching Gifts and gifts
credited on the Matching/Credit tab. When you make an adjustment to a
credited gift you will need to make adjustments for the credits as well for
T_CREDITEE to be updated properly.
For a matching gift:
1. Make the adjustment to the original gift using the Adjust button.
2. Load the Matching Contribution.
3. Adjust the matching contribution appropriately for the matching ratio.
4. Before clicking saving the contribution on the matching adjustment go to
the Matching/Credit tab.
5. In the Credit Window you should see the credit. Delete the credit for
the original amount.
6. Add a new credit with the adjusted amount with a creditee type of
Matching Gift. (Or whichever creditee type is appropriate.)
7. Save the contribution

For a credited gift adjustment load the original contribution; make the
adjustment and then go to step 4 of the above steps. In step 6 select the
appropriate creditee type.

When you are trying to remove benefits or delete any type of creditee that
involves a membership transaction, change the creditee type to a creditee
type that doesn't affect memberships. Save your changes. If you are
working in a controlled batch, you have to close and post your batch after
changing the creditee type. Then try deleting the creditee record on the
Matching/Credit tab in contribution entry. Lastly, you have to manually
adjust any affected memberships.


From: Jan LaRocque
Sent: 6/3/2009 11:44:35 AM


We made an adjustment on a matching gift pledge. The contribution record
is now correct, but the T_CREDITEE still stores the unadjusted amount. Is
there an offical way to fix this?


Thanks,


Jan





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

Great!

Let me know if you are successful doing it within the application.

Cheers!