mburnham
Member
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
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