query on next transaction amount for recurring gifts

Kris Pearson

Does anyone know if you can query on next transaction amount for recurring gifts?  I am in a gift query and see the option for next transaction due date, but can't find next transaction amount.  We need the amount to output for a report.

Dan Snyder

Kris Pearson‍, if set up as a recurring gift, you could just export the gift amount because that is what is charged each month/quarter, etc.

Kris Pearson

I had considered that.  My report currently includes both pledges and recurring gifts.  It is adding the installment amount due on the pledges.  If I pull in gift amount I'm going to have to do some editing or do 2 reports, 1 for pledges and 1 for the recurring gifts since I do not want the total gift amount of the pledges.