Being able to report on activity where balances cancel out

Content

We are looking for a way to report on the activity on the recs and if a rec doesn't have activity or a balance for 90 days then we need to set the profile to inactive so that the rec isn't created anymore until or unless there is a balance that starts coming in. Right now there isn't an easy way to do that. We can report on the balances from GL, and the balance from the subledger, and the acitivty, but the activity is only the balance change from the prior period, so if in one of the periods