I want to find out how many active subscriptions are in a dunning state right now?
Dunning is associated with the invoice that had a payment failure. By filtering the list of invoices in dunning, we can map out the subscriptions associated with those invoices.
You can filter invoices by dunning status from Invoice Index Page using Advanced Filter Option
Chargebee automates the process of dunning and retries to collect the payment during payment failure. We can filter invoices by dunning status.
Navigate to Invoices & Credit Notes > Invoice Index Page > Filter list > Dunning Status > is > In Progress > Apply Filter
After you filter the search criteria, you can download the report from More Actions > Export Invoices CSV
Once downloaded, you will find a invoices zip folder with the list of files. Navigate to the Subscription.csv file and open it.
Now, you can find the list of subscriptions in Progress under Dunning with all the relevant details.