Is there any way to tell, when an account is made inactive, which accounting period is the first period where that account is not used?

run a transaction query and get the max(trandate) where the account is used and then run a query for the period after that date.