Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Script to see if AA is enable in Microsoft Dynamics GP


View products that this article applies to.

QUESTION

How can I check to see if AA is active or not in Microsoft Dynamics GP?

↑ Back to the top


ANSWER

 

Execute the below SQL script against the Dynamics database:

------------------------------------------------------------------

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 Data'

WHEN 5 THEN 'INVALID AA'

ELSE 'Not Enabled'

END   AS AAStatus

FROM DYNAMICS..AAG00104 b join DYNAMICS..SY01500 a

on a.CMPANYID = b.CMPANYID order by AAType DESC, CompanyID

----------------------------------------------

--if your Dynamics database is not named Dynamics, edit the script accordingly for your named database. 

 

Any results with 'Activated with Data' will mean that AA records are getting populated in that database.  Any database with this result will have a default record created for every journal entry even if you have not begun setting up AA, and for all GL accounts even if no accounts are linked to a dimension.  If you are using Management Reporter 2012 CU10 or newer, you can choose whether or not it will be reading data from the AA tables.  In Microsoft Dynamics GP 2015 or newer, that option is located in (Microsoft Dynamics GP under Administration, then Setup, then under Company and Company and Options).  In Microsoft Dynamics GP 2010 and GP 2013, that option is available in the Management Reporter Configuration Console.  If Enable Analytical Accounting Reporting is marked, MR will read solely from the AA tables.

A result of "INVALID AA" means that AA Activation was started but did not complete correctly.  In this scenario, you will need to start over with AA Activation if AA is needed for the company.  If you do not have a backup to restore to, a support case would be needed to reset the database for re-activation.

 

 

 

query words:  IsAAEnabled?  enables activated disabled not active, analytical accounting

↑ Back to the top


Keywords: kb, gp, kbmbspartner, kbmbsmigrate

↑ Back to the top

Article Info
Article ID : 4316764
Revision : 3
Created on : 5/23/2018
Published on : 5/23/2018
Exists online : False
Views : 318