Sage 100

5.3 Premium. End user imported GL accounts into wrong account groups and has posted transactions so now I can't correct them. Ex. expense accounts are in a revenue group. Can anyone explain how I can accomplish this since DFDM isn't an option? Thanks!

If you want to make manual data edits, you need to use SQL Server Management Studio.

Renumber utility?

Unfortunately, renumber utility won't work since there are transactions and the accounts are different types (Rev vs. Exp).

Kevin - I've never done manual edits before. Is it difficult to navigate?

I generally have had to renumber to a new GL account, deleted the old account and recreate in the correct grouping. I then renumbered back once it was in the correct grouping. 1st try this in a backup company to confirm all the necessary steps.

Right-click a table, and Edit top 200 rows. Ctrl + 3 opens a SQL window where you can edit the select statement to show the rows you want to work with by adding a ""where..."" clause. Then you have a spreadsheet type grid to work with. Warning: there is no undo. Move off a line and the change is committed.

Someone could also write an update script if you have someone who is SQL savvy.

@DawnKulbacki How many different account groups do you need to change. I think an update query might be possible.

I only have 1 account group to change. The bigger issue is changing all the accounts, since the account 'type' was pulled in when the account group was wrong. This has been very helpful! Thanks everyone!!

That can easily for in the update query. You can change both. My guess you can use the modified date and use a query to do a change and replace.for both fields. Much easier them editing one at a time.