This can be done in the Raw Data Explorer, although I appreciate that the date filters can be a bit confusing at first.
To filter on invoices due over 30 days ago, for example, you could use:
due_date < "30 days ago"
We also have a guide on date filtering which you might find useful.
You can combine this with your other filters to:
order_status = "Invoiced" and payment_status != "Paid" and due_date < "30 days ago"
Note, that instead of payment_status = "Unpaid"
, I have used payment_status != "Paid"
. This is because we have another status of “Part paid” which if you have any invoices in this status are probably useful to see. The !=
means “not equal to”, so “show me invoices not paid” is slightly more encompassing than “show me unpaid invoices”. I hope this makes sense and is useful.
I hope this covers what you’re looking for?