My company sells subscription based software products, we have some clients who purchase as needed, and some who purchase a year at a time. Because of this it is important to know which clients have an active subscription and who has expired.

I have set up an automation that updates the account status to "Active" when an invoice is created. 

I have also set up an automation that updates the account status to "Inactive (Former)" one day after the "Package End Date" passes. The package end date is a custom field on my invoice module. 

I am running into problems because an invoice is frequently created before the the package end date on the previous invoice. 

So based on my rules the account is updated to "active" (even though it already is) when the invoice for the next sub is created, and then updated to "inactive" when the current package expires.

In a perfect world, I would be able to change the Account Status to Active if the account has ANY invoices with a Package End Date that is in the future... but I can't figure out how to do that... any suggestions?