Is there a report that shows all Sales Orders that are past due by the # of days?

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?

1 Like