Hi Michael,
Here is a SQL script that you can run against the system DB to quickly validate if AA was installed and configured or not.. Installing AA is one step, but enabling it in every company is another one, which may or may not have been done.
-- use this script to check if AA is installed in this GP instance & if so, in which company.
If exists (select * from DYNAMICS..sysobjects where name = 'AAG00104' and type = 'U')
SELECT a.CMPANYID AS CompanyID
,a.INTERID AS SQLDatabase
,a.CMPNYNAM AS CompanyName
,b.aaCompanyStatus AS AAType
,CASE b.aaCompanyStatus
WHEN 4
THEN 'Activated (with possible Data)'
WHEN 5
THEN 'INVALID AA'
ELSE 'Not Enabled'
END AS AAStatusFROM DYNAMICS..AAG00104 b
RIGHT JOIN DYNAMICS..SY01500 a ON a.CMPANYID = b.CMPANYID
ORDER BY AAType DESC,CompanyID
ELSE
Print 'Analytical Accouting not installed on this GP instance'
Excuse the bad formatting, the inline editor isn't really made for this.
