Revenue Attribute does not show in Ad-Hoc Query for GL Distribution

When a donation with an Revenue attribute that should post to GL Distribution/Attribute/Value is posted and then an Ad-Hoc Query for that table is ran the field appears blank. 
To query on Revenue attributes please use the Revenue\Attribute node

Steps to Duplicate

  1. Go to Administration
  2. Under Data click Attribute Categories.
  3. Click Add
  4. Add a Attribute with Record type of Revenue
  5. Make the data type text
  6. click save
  7. Choose a constituent and go to the record
  8. Click Add a payment
  9. Make a Donation and Save
  10. Go to the resulting Revenue record
  11. Click Attributes
  12. Click Add
  13. Add the Attribute created earlier
  14. Click Save
  15. Go to Analysis
  16. Click Information library
  17. Click Add an Ad-Hoc Query
  18. Include records where: GL Distribution\(The Attribute created earlier)\Value is not blank or (The Attribute created earlier)\Value is not blank and Revenue ID is equal to (The donation made earlier)
  19. Results dields to display: Amount, Date, GL Distribution\(The Attribute created earlier)\Value, (The Attribute created earlier)\Value, Revenue ID, Amount, Account System, GL post status
  20. Notice that GL Distribution\(The Attribute created earlier)\Value is Blank.


 Blackbaud CRM
 4.0 SP13

Was this article helpful?