Error: The specified query must be a Gift query. - when automatically generating transactions and payments in Batch

When automatically generating EFT transactions/payments in a gift batch. the following message may occur when clicking Generate Now:

Error: The specified query must be a Gift query.
A gift query can be used in the Automatically Generate Transactions/Payments wizard. If this gift query is deleted, but it was still linked in the wizard, then this message occurs when Generate Now is clicked on. If this message happens, please review the following:
  1. In the affected batch, go to Tools > Automatically Generate Transactions/Payments.
  2. Click Include.
  3. Select All Records, or Selected Records and attach another gift query.
  4. Proceed with automatically generating EFT transactions/payments.



 

Steps to Duplicate

In a sample Raiser's Edge:
  1. Create a dynamic Gift query with criteria that generates recurring gifts and pledges.
  2. In Batch, start a new Gift batch.
  3. Go to Tools > Automatically Generate Transactions/Payments.
  4. Click Include > Selected records and attach the query created in step 1.
  5. Set other settings as appropriate.
  6. Click Generate Now.
  7. Save and close the batch.
  8. Return to Query and locate the query created in step 1.
  9. Delete this query.
  10. Return to and open the batch started in step 2.
  11. Go to Tools > Automatically Generate Transactions/Payments.
  12. Click Generate Now and the message occurs.

Was this article helpful?