GL_AccountHistory Rebuild?

Question

We have reason to believe that the GL_AccountHistory table in one our companies has been corrupted and is causing a problem with an external program that relies on this table. Is there a procedure for reinitializing this table and 'refilling' it?

Gina Thompson · Answer

Make a backup, Rebuild GL_AccountHistory.m4t then Rebuild GL sorts. That will repopulate gl_AccountHistory file. The record counts should be the same in both GL_Account and GL_AccountHistory files

TomTarget · Answer

Might want to do a G/L | Utilities | Recalculate Account Balances too. Backup first!

Sage 100

GL_AccountHistory Rebuild?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING