Sage 100

Sage 100 v2017 PU 1 Standard - is there a way to import a list of general ledger accounts to be deleted from the chart of accounts. My memory is that this occurred in CHANGE ACCOUNTS however that seems to be faulty as CHANGE ACCOUNTS only seems to support merge and renumber. There is a DELETE ACCOUNTS option but I'm not sure how to import to that file. I tested on a local Sage 100 system and selecting accounts in DELETE ACCOUNTS seems to populate a work file GL_DeleteAccountsWRK.M4T. There doesn't seem to be a way to import to that WRK via visual integrator. What am I overlooking?

From what I can tell, my options for deleting a large list of GL accounts is: a. Merge them into a ""dummy"" account (I think this can only be done between accounts of the same financial statement type - so not practical for large lists of different type accounts) b. Flag them in account maintenance as ""deleted"" and presumably they purge during year-end <- This is what I did with a simple VI job into GL_Account and just change status to D. c. Manually delete

It looks like all the DELETE ACCOUNTS utility does is change the STATUS flag in GL_Main. Presumably these accounts are purged as part of year-end as Sage checks if they also have any history during the time period that GL Options stipulates.

You are correct.

I can see why Sage removed that mass deletion capability though, as I had customers in the past remove accounts with history and wonder why financials/trial balances were no longer in balance. It would be helpful if Sage had a utility that offered to ""purge deleted accounts"" instead of presumably waiting until year-end.

I suppose you could be daring and run the YE period close then open it back up to the period you want it to be. Be sure all of your history retention settings for GL are way out there so history is not accidentally purged.

Was also wondering if accounts might be cleared during a GL - Period End for the month but I have yet to research