There is some complexity to this task because you cannot remove accounts that have any unpurged transactions posted against them. Also, you need to consider where the account might be used in the configuration of subsidiary modules, as an override, reference, budget or statistical account.

Even though most of the reports and BI views rely on inclusion instead of exclusion logic, probably the easiest way to view this type of activity - or lack thereof - in Sage 500 is to use the GL Transactions and/or Account History BIE views. You can manipulate the columns shown, enable grouping and use the filter to drill-down on the data view you need.

In this example, grouping has been enabled, the GL Account has been added to the group and the filter used to indicate accounts that don't appear to have been actively used in any transactions. You would change your filter selections to indicate the accounts, fiscal years, groups or other criteria you want to review.

Any account you try to delete will roll through the referential integrity constraints and stop you if the account is used in a configuration, or has been used in some GL or other transaction you may not have caught. If you inactivate an account that is configured somewhere in a subsidiary module, the GL posting will generally go to suspense, although you might encounter a posting error depending on how some of the options are configured in the system. That includes overrides configured in the subsidiary modules, as well as the GL structure and whether or not you have enabled "Allow Automatic Addition of New Accounts" in Set Up GL Options.

That last option can bite hard as I've seen sites with a complex GL and override configuration scheme that have experienced the number of accounts increase by hundreds or thousands in a matter or months because of some relatively small misconfiguration. These had to be removed programmatically.

Thank you for the great explanation, will use the Account History to run a report. Once we narrow down which accounts can be deleted, is there a script you can suggest to set status to inactive or deleted?

I forgot about the Delete Accounts task you might be able to take advantage of, but that generally only sets the accounts to a Deleted status, it won't set them to inactive. From what I recall, it will delete accounts with no history or references, but it's best to verify that with some testing.

Quite honestly, you can get yourself into a lot of trouble running any type of update query in the back-end against disparate accounts that aren't included in some type of group. Doing this work in the back-end you would either have to  get creative with the criteria, build a collection of accounts manually or determine some other paradigm to group these logically.

Unless they number in the thousands, or are associated with a natural account you can set to inactive I would suggest setting them to inactive status using Maintain Accounts. You can engage your reseller or a developer if you do have a larger number of them, but compare what the developer work might cost compared to having someone perform this work manually.

If you have a test database, try using the Delete Accounts task, or test it in production on some accounts you want to set to deleted. Use caution when employing this utility. It should be used during non-production hours as the checks it performs can be intensive against all data in the system that references GL accounts (basically everywhere).

From Online Help:

Use Delete Accounts to select multiple accounts that you want to delete. You can select the accounts by account segment or segment value range. The accounts that meet the selection criteria display in the grid. You can change your selection criteria at any time before deleting the accounts either through a manual purge or during period end processing. You can also print a list of accounts selected for deletion before actually starting the process.

Warning After starting, you cannot stop this task until all selected accounts are deleted.

Note You cannot delete accounts that have activity or history. If you select an Active or Inactive account with activity or history, only the status is changed to Deleted. You must purge the account either manually or during period end processing.

Accounts selected for deletion are not removed from the system until all of the transactions against the accounts are posted. Accounts selected for deletion are removed from the system during a manual purge or period end processing.

You can also view or change the account status in Maintain Accounts. You must purge the account either manually or during period end processing.

One other tip, if you want a quick summary of the history or transactions on a specific account, select the account in Maintain Accounts, right-click on the Account field and from the context menu select Previews > Account History. You can also use Drill Into > Account Transactions to review transaction detail against the account.

Great, thank you for all the suggestions! Very helpful

Great, thank you for all the suggestions! Very helpful