Gifts do not sort correctly when sorting by Letter Code in gift batch

In a gift batch in The Raiser's Edge, rows can be sorted can be ordered by using the sort function available on the Tools menu. However if the Letter field is present and is selected to sort by, the rows can sort incorrectly.

We have evaluated this issue as a bug and we have determined it will not be addressed in the program in its current state.  In this case, we believe the risks and challenges outweigh the potential benefit of resolving this issue. We strive to select the most impactful changes and issues to address with each release to accelerate the rate at which we deliver new features while sustaining the highest level of quality for our customers.

We encourage users to add any program suggestions to our Ideas Community page.  Our developers check here first when building program enhancements to see what our users are most interested in seeing implemented.


Steps to Duplicate

In the Raiser's Edge sample database:
  1. Click on Batch in the Raiser's Edge menu.
  2. Click on New Gift Batch in upper left.
  3. In the batch setup, click on Fields tab.
  4. Move Letter code from the left to the right list.
  5. Click Data Entry.
  6. Enter gifts for five different constituents. In the Letter code column, enter the following letters for each constituent in this order:
    • Row 1: Playground Thank You
    • Row 2: Annual Giving Thank You
    • Row 3: Gift-In-Kind Thank You
    • Row 4: Endowment Thank You
    • Row 5: Capital Campaign Thank You
  7. Click on Tools and select Sort Batch...
  8. In the Sort Batch window, set Sort Order to Ascending and Sort By to Letter code.
  9. Click OK.
Most of the rows will sort correctly except the Playground Thank You row, which will appear as the second row. Sorting in Descending order produces the reverse of the Ascending results with Playground Thank You as the next to last row.


 Raiser's Edge

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.