Customer is getting error when attempting to activate Analytical Accounting(AA).
"Installation of analytical accounting has failed as there are other users logged into the system"
There are other users logged into DYNAMICS, but not that particular Company where you are adding AA. You are wondering if everyone has to be out of Dynamics GP to create default records as well as running the AA Activation Wizard itself.
Users logged into Dynamics GP while activating Analytical Accounting.
All users do need to be out of the system (all companies in same Dynamics database) when going through the AA activation process. This is mainly because Analytical Accounting uses the dynamics table (AAG00102) to populate the next record values in the AAG work, open, and history tables for all of the companies. When you activate AA, those tables will have default records created so that you can go back and add dimensions (using the AA edit analysis window) to posted journal entries should you need to. It will also update a flag setting in the dynamics AAG00104 table after the activation is completed. Since the Dynamics tables are impacted, all users need to be out of all company databases.
Run these scripts to see if anyone else is in the system and ask them to exit properly through the front-end. If all users are out, these tables should be empty, so provided ‘delete’ scripts below as well.
SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION