Tribute Revenue report gives incorrect totals when filtering by designation

When viewing the Tribute Revenue report and filtering by a specific designation, you would expect to see the total revenue for just that designation.  However, the report shows the total revenue for that tribute, including revenue from other designations.
The total amount displayed is the total amount of funds raised for the tribute for all the designations.  The designation filter is specific to listing the individual gifts made to the tribute with that specific filtered designation.

Steps to Duplicate

  1. Go to any constituent and add a Tribute on the Tributes tab
  2. Go to another constituent, and add a payment as follows:
  • Enter an amount
  • Enter a designation
  • Add
  • On the Transaction details tab of the payment form enter the Tribute created above in the Tribute field
  1. Go to a different constituent and add a payment as follows:
  • Enter an amount
  • Enter a designation that is different from the one in the previous step
  • Add
  • On the Transaction details tab of the payment form enter the Tribute created above in the Tribute field
  1. Go to the Tribute Revenue report
  2. Select Include, Specific record
  3. Enter the Tribute in this field
  4. In the Designation field, enter the designation from the first payment above
  5. The date field needs to reflect the date of the two payments above
  6. Select View report
  7. Observe that the total tribute amount is the sum of both payments even though they are different designations while the specified designation payment is also detailed
  8. Change the Designation field to the designation of the second payment
  9. Select View report
  10. Again observe that the total amount is the sum of the two payments, and the second designation payment is detailed

Environment

 Blackbaud CRM
 4.0

Was this article helpful?