Thanks for the clarification. Here are steps you can test:
Steps to Uninstall and Reinstall Analytical Accounting for One Company:
*Always make a restorable backup of the databases (including DYNAMICS) prior to making any changes.
Make sure no users are in the system.
1. First determine the company ID of the company from which you will be removing AA.
SELECT CMPANYID FROM DYNAMICS..SY01500 WHERE INTERID = 'XXX'
-- Note that XXX is the company database name (Microsoft Dynamics GP >> Tools >> Setup >> Company >> Company >> Company ID field).
2. Download and run the script associated with STEP 11 only of KB Article 915903 (KB915903_10.sql) against the company database. (Copy this script into SQL):
915903 Steps to remove Analytical Accounting from a computer that has Microsoft Dynamics GP installed:
support.microsoft.com/.../steps-to-remove-analytical-accounting-from-a-computer-that-has-microso
3. Run the following scripts against the DYNAMICS database. Once again XXX is the database name and Y is the CMPANYID value from step 1. (Plug in TEST DB name and ID below)
DELETE DB_Upgrade where PRODID = 3180 and [DB_NAME] = 'XXX'
DELETE DU000020 where PRODID = 3180 and companyID = 'Y'
DELETE DU000030
UPDATE AAG00104 set aaCompanyStatus = 0 where CMPANYID = 'Y'
4. At this point AA is uninstalled from the company, run Dynamics GP Utilities to reinstall the database objects.
Hope this helps!
Andrea
