Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / DYNAMICS.dbo.aagGetCom...
Finance | Project Operations, Human Resources, ...
Suggested answer

DYNAMICS.dbo.aagGetCompanyStatus missing

(0) ShareShare
ReportReport
Posted on by michaelq 95

A client gets this message when they try to start a new fiscal year

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: DYNAMICS.dbo.aagGetCompanyStatus missing

    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. 

  • Suggested answer
    agaber Profile Picture
    agaber on at
    RE: DYNAMICS.dbo.aagGetCompanyStatus missing

    Hi Michael-

    Thank you for posting your question on the Forums.  The erring is referencing the Analytical Accounting(AA) module.  Do you know if you are registered for that and/or if you ever tried to install AA at any time?  Note that if you are you are using it with any company database, AA will need to be installed on every workstation.  If the error does not happen on the server(or other workstation), that may be the issue.

    If you are not using AA for any company databases, and you do not want to use it in the near future, you can try completely removing it from the system following the KB article below:

    support.microsoft.com/.../915903

    If you need assistance with removing AA, please open a support case so a support engineer can review your data in SQL.  Let us know if you have any questions.

    Have a great day!

    Adam G.

    Microsoft Dynamics GP

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans