When running the report in "Find Tenancy Invoice' it has a box you can tick for "Include Archived Tenancies"

There is no filter in the columns section to see a vacate date. You are unable to identify what tenants are current versus archived on the list, they are all in one.