How to get previous amount on an adjusted gift

Divyesh Khatri 2 · February 2018

any ideas on how to get previous amount on a gift query for a gift that was adjusted

James Andrews · February 2018

Divyesh Khatri:

any ideas on how to get previous amount on a gift query for a gift that was adjusted

You can't in query, through RE. You have to either run the adjusted gift report to find that info, or have access to and know how to use SQL to query the database directly.

Divyesh Khatri 2 · February 2018

James Andrews:

Divyesh Khatri:

any ideas on how to get previous amount on a gift query for a gift that was adjusted

You can't in query, through RE. You have to either run the adjusted gift report to find that info, or have access to and know how to use SQL to query the database directly.

what about using Gift Adjustment Previous Funds - Split Amount. Is that not the same things as previous amount

James Andrews · February 2018

Divyesh Khatri:

James Andrews:

Divyesh Khatri:

any ideas on how to get previous amount on a gift query for a gift that was adjusted

You can't in query, through RE. You have to either run the adjusted gift report to find that info, or have access to and know how to use SQL to query the database directly.

what about using Gift Adjustment Previous Funds - Split Amount. Is that not the same things as previous amount

Wow, I guess it could be -- I've never used that before. It's as good as anything I guess, although it's interesting they have that but not previous campaign or appeal, or overall amount. Test it out and let us know!

Divyesh Khatri 2 · February 2018

James Andrews:

Divyesh Khatri:

James Andrews:

Divyesh Khatri:

any ideas on how to get previous amount on a gift query for a gift that was adjusted

You can't in query, through RE. You have to either run the adjusted gift report to find that info, or have access to and know how to use SQL to query the database directly.

what about using Gift Adjustment Previous Funds - Split Amount. Is that not the same things as previous amount

Wow, I guess it could be -- I've never used that before. It's as good as anything I guess, although it's interesting they have that but not previous campaign or appeal, or overall amount. Test it out and let us know!

It looks correct but it would jsut make sense if they called it PREVIOUS AMOUNT

James Andrews · March 2018

Divyesh Khatri:

James Andrews:

Divyesh Khatri:

James Andrews:

Divyesh Khatri:

any ideas on how to get previous amount on a gift query for a gift that was adjusted

You can't in query, through RE. You have to either run the adjusted gift report to find that info, or have access to and know how to use SQL to query the database directly.

what about using Gift Adjustment Previous Funds - Split Amount. Is that not the same things as previous amount

Wow, I guess it could be -- I've never used that before. It's as good as anything I guess, although it's interesting they have that but not previous campaign or appeal, or overall amount. Test it out and let us know!

It looks correct but it would jsut make sense if they called it PREVIOUS AMOUNT

I wrote a query that had this field as an output so I could look at what the SQL it generated does. It pulls the amount from GiftPreviousSplit, which is the table where the original gift split amounts are stored when you do an adjustment. If you don't use split gifts, that should be fine.

If you do use split gifts, it should pull a row for each split amount -- you're right that they shouldn't have called it fund split, they should have just called it previous split amount, because any of the fields that split the gift (campaign, fund, appeal, package) could be the cause of the amount you're seeing.

How to get previous amount on an adjusted gift

Comments

Categories