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
Note: On the recent UI enhancement you can now scroll the index pages - Customers, Subscriptions, Invoices, and Credit Notes vertically. Earlier, the pages will be paginated which may prolong your search however with the new enhancement as you scroll down the list it will load all other data in a single page as highlighted below on the screenshot. Refer to this link for more information.
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.
How to enable dunning in subscriptions?