GLPOST and GLAFS not matching

[Zak2009]

Hi,

I have a problem in certain accounts when printing the GL transnational(GLPOST) reports there are transactions but the TB(GLAFS) does not have the summary figure.

Is there a script that i can run for particular accounts to calculate the total figure in the table GLPOST and insert it into GLAFS for a particular period.

VERSION 6.0
DB SQL

Thanks,

 

[Jay Converse]

Use a SQL query with SUM and GROUP BY

 

[ettienne]

Run a data integrity on GL - it will report the differences.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net