Updating Gift Type Tables

Options
Megan Leap
Megan Leap
Inquirer Level 1
in Blackbaud Raiser's Edge NXT®: General Discussion

I am looking for a way to easily report “restricted” or “unrestricted” in a system that was previously not set up to report on this easily. If I update our Gift Type and Gift Category table options, will this retrodate or will the change only show in gifts added after the change?

Tagged:

Comments

  • Austen Brown
    Austen Brown Community All-Star
    Ninth Anniversary 2,500 Likes 1000 Comments Photogenic

    @Megan Leap - Unfortunately the Gift Type table is locked; meaning you cannot change the options. Rather than creating a new process I recommend utilizing fields that already exist for this. Depending on your Fund Structure - I recommend utilizing the “Is Fund Restricted” check box directly on the Fund Record.

    b7e0c39ce8368ba64e7a73fa07103aa4-huge-im
    This is what this looks like in WV

    From a reporting stand-point, within a gift query - this is an available field to utilize in the criteria.

    ef865934e0208d83787d4229a28d0276-huge-im
    Option within Gift Query


  • Christine Robertson 4
    Christine Robertson 4 Community All-Star
    500 Likes 500 Comments Photogenic Name Dropper

    @Megan Leap You can also group Funds into a Fund query for all Restricted or Unrestricted and then link the query to reports, exports, etc.

    I do this often for clients who have specific Fund groupings so that the groupings are consistently done across all of RE.

  • Karen Diener 2
    Karen Diener 2 Community All-Star
    Ancient Membership 1,000 Likes 500 Comments Photogenic

    @Megan Leap as usual, Austen and Christine have given sound advice.

    I do want to mention that the “Restricted” checkbox is merely a checkbox though, with no special functionality whatsoever. If you need to see a list of gifts and which are restricted and which are not, you will need to include that checkbox as an output field, which may or may not be available depending on what you use to report.

    Another method I've seen is for organizations to use R at the beginning of the Fund ID and / or “Restricted” at the beginning of the Fund description. This can be done without using the checkbox, but I would recommend using both. I don't love using it as part of the description because it can become long, and Fund Descriptions are often output fields in acknowledgement letters.

    Just wanted to offer another option!

Categories