There is no way to run a query to see how many payments remain on a recurring invoice with a fixed number of payments. Nor is there a way to see the last payment date. Please add one or the other to the query fields.
i know it would be nice if that info existed as a field to include in the query. In the meantime you could include the invoice date. That would list out the number of invoices that had been generated. If you also include the # of invoices, you can determine how many are left.
i know it would be nice if that info existed as a field to include in the query. In the meantime you could include the invoice date. That would list out the number of invoices that had been generated. If you also include the # of invoices, you can determine how many are left.