Merging account numbers

[SpeedBWild]

I have merged two account numbers. When I go into the front end summary or detail (Inquiry-Financial-History Summary/History Detail) I see all the data for the two merged accounts. The amounts for the Debit, Credit, Net Change and Period Balance are correct. When I run a report under Reports- Financial-Trail Balance, then select Summary. The data in the report does not match. Is there a table that holds data for reports? I believe I updated all the correct tables for the account data. I have looked all the tables with account numbers in them or the actindx in them. Any ideas?

One other question when I update table GL10111 I updated(sum) the debit and credit amounts for the two accounts, then for the PERDBLNC I take the DEBITAMT-CRDTAMNT (Is there more to it than that?)

 

[klewis10367]

You need to reconcile your financials. You really didn't need to update the GL10111 manually, all you had to do is run the reconcile for history, and you should also run the reconconcile for current year too. (GL10110). Utilities>Financial>Reconcile. Reconcile history first from oldest to most current. You might want to look into the Professional Services toools to do this in the future, if it is something you plan on doing regularly. It does everthing but reconcile the financials for you.

 

[SpeedBWild]

So, I only have to update data in GL30000 for the history detail and then reconcile it and it will uppdate the data in GL10111? So, then is the same true for the Current Year Summary and Detail (GL20000), that I only have to update the Current year Detail and then reconcile it?

Thanks

 

[klewis10367]

Exactly. What you might want to do is delete your GL00105,GL10110,and GL10111. Run a checklinks on the Account Master and then reconcile the financials. The checklinks will look for any account number problems, and then repopulate the GL00105. Remember to backup first. You should run into no problems, but if you are not familiar with this I would definetly backup first.