Microsoft has fixed quite a few AA issues in SP4 for GP 10, including critical fixes with AA CheckLinks. As I mentioned earlier, many Duplicate record problems in AA have also been resolved. So please install SP4 and be good to yourself if you are using Analytical Accounting.
If you run Check Links on the Analytical Accounting logical group of tables but run into the following error messages:
"[Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'aaGLHdrID', table 'DBNAME.dbo.AAG30001', column does not allow nulls. INSERT fails."
"The stored procedure aagGenericGLOpenTOD…