Sage 100

If you want to import GL accounts to be deleted, what is the table?? I only see the Change table with no option to delete. TIA!

I think that's it - there's a flag in there for what you want to do change, merge, delete. I always enter one into that table then use Crystal to determine what has to go into the fields through VI.

There is only a change type of A or S which is Account or Segment. How would you delete it??

The delete accounts functionality basically sets the flag to deleted. You could do an import into gl_account and set the status to ""D"". They won't get deleted until the period end processing is run after the years to retain GL History parameter has been met.

Doesn't @JeffSchwenk have a post that says it isn't working for him?

GL_AccountChange - I see a field for ChangeType

What version? I believe there was a problem with this table missing in a previous version and a product update to fix it.

2015.

What version are you referring to @ThereseLogeais - I have encountered this issue in v2015 (PU2) where it seems there are two utility menus - Change and delete. There is no VI for deletions only changes which is what I was dealing with last week. I entered an account for deletion via the utility to find the table populated and there is NONE. It is NOW as @TimEfinger describes, the delete utility just changes the flag in GL Account to Deleted. The THEORY is these accounts will disappear at year end IF there is no it isn't removing it if there is any history. GL_DailyPosting, GL_DetailPosting, GL_BudgetRevisionEntry, GL_PeriodBudgetDetail, GL_PeriodPostingHistory are the tables being checked. My accounts budget history. So it comes back to an answer on my earlier post to MERGE the accounts into one. Plus, the only purpose I see now for the delete utility is that you can change a range or a segment to delete. Here is thread from last week regarding deletions https://90minds-com.socialcast.com/messages/27155265?ref=stream

And it gets even trickier in v2015 (or maybe earlier), when you merge accounts (since this is the quick way to get delete them now, the merge will NOT work if new account number financial type does not match the old account number that you are trying to purge. In a way I can understand that logic, but it certainly complicates life when you are just trying to delete accounts quickly.