Sage 100

We have a customer who just went live last month who entered their own chart of accounts using the GL exchange function. Low and behold after entering transactions, they realize that the account groupings are incorrect (cash in other income and expense). Per Sage, the only way to fix this (because transactions have been entered) is to create new accounts, reverse the original transactions and then import the transactions into the new accounts. As this is a relatively new customer, it would seem better to keep the account structure they want in a new company and import the transactions there (potentailly copying the data files for other modules between the two), or some creative VI (DFDM) type work to fix the darn thing. Any ideas or suggestions would be appreciated.

How many accounts are incorrect? What I have done in the past is DFDM the Account Maintenance (GL_Account) table and the Main Account Maintenance (GL_Main) for the corrections. You should also verify that the Account Group Maintenance table is set up correctly. Correct the two tables seems to do the trick. Not sure if the VI will work because of the business framework rules. Worth a shot though. If trying VI, fix the Account Group maintenance table first, then go after the GL_Main table.

I agree with Jeff. While it is a tedious process to change the tables it is usually faster than starting over.

Can we safely assume that changing the account table and main account table are the only two tables? In the old days data was written many places and I am not the DFDM dude any more!

Had to do something similar and seem to remember Jeff's though process was the way that I did it as well.

As Jeff said you have to make sure the account group table is set up properly and then work with the other two tables to change the affected fields. In any of the tables you may have the account type, account group and account category that need to be corrected.

Verifying how the client wants it and then will try DFDM in the test company. Will update on success (failure is not an option).