We want to create a query to identify clients that haven't had any activity in recent years and then make them inactive. (1) What options should be used to build the query? (2) How do we use the query to then inactivate those clients?

I need a query that displays certain client receipts paid throughout the year that hit a particular GL distribution. Some of the clients paid on charges; others paid on invoices. If I know the same GL code is applicable to all clients, how can I use the payment query to capture this information? Is there...