Investigate Trial Balance problem

Hello all,

Running B7333 and having a trial balance issue for several companies. I was told I could do something like this to find potential problems:

SELECT SUM(GLAA) FROM CRPDTA.F0911 WHERE GLCO = '00009' AND GLLT = 'AA'
GROUP BY GLDOC

(Company 9 is one of our offices)

All transactions for 1 doc number and company should sum to 0?

Do I need to exclude voided transactions? (GLRE = 'V')

Thanks so much in advance,

- Mark

Mark,
You should run Integrity Reports first go into Periodic Processing menu and you should find it. Run reports related to Trial Balance and it should give you what is out of balance. You can concentrate further on those items.

Hope this helps.

Chan