Share
ReportA client gets this message when they try to start a new fiscal year
You’re offline. This is a read only version of the page.
95
A client gets this message when they try to start a new fiscal year
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.aaCompanyStatusWHEN 4THEN 'Activated (with possible Data)'WHEN 5THEN 'INVALID AA'ELSE 'Not Enabled'END AS AAStatusFROM DYNAMICS..AAG00104 bRIGHT JOIN DYNAMICS..SY01500 a ON a.CMPANYID = b.CMPANYIDORDER 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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (