How do I query on donations to a certain Tribute account?

At times, you may need to generate a list of any donations given in honor of/memory of a specific Tribute account.  You can do this by creating a query using the Transaction Tribute Name field.
A query of all donations to a specific Tribute account can be created by following these steps:

1. Click Queries
2. Select a category that you want to store this query in (Ex: Base)
3. Click New Query under the tasks menu
4. Name the query
5. For the Starting Query choose Category: Base and Query: All Constituents
6. Set the Data Return Type to Journal Entries
7. Under Criteria Matching select Match Each Criteria
8. Under Criteria select 'Individual Transaction received'
9. Enter greater than or equal to 1.00
10. Under Criteria select Journal from the drop down
11. Click Transaction Tribute Name
12. Click the '...' next to Transaction Tribute Name and find the Tribute account you need
13. Save and Preview

Environment

 eTapestry

Was this article helpful?