Make Status column available in Advanced Queries

please add in status unpaid Option

1 Like

EDITED!!
Except for Paid in full and Overpaid all others are different versions of unpaid. However, despite my earlier reaction it would indeed make sense to have an Unpaid option to capture all the due ones in the Query at once.

I believe this is why @lubos separated the overdue days from the status column.

I’m going to split this topic and place it under ideas.

1 Like

In the latest version (24.3.26) you can now specify is not modifier on statuses so this allows to exclude statuses you don’t want leaving you with the ones you want.

In this case, to get all unpaid invoices, you’d do something like this:

image

2 Likes