Back in February 2017, I posted about a Microsoft Knowledge Base article on removing Analytical Accounting (AA) from Microsoft Dynamics GP. At the time, the KB article was unavailable, but the download links still worked (if you knew what they are).
I was contacted by someone recently asking if I had a copy of the scripts as the download links no longer work (the KB article itself is available).
This was unusual timing as I had just been onsite with a client where we encountered issues upgrading their system from 2016 RTM to 2018 RTM. In that case, the solution was to remove AA from the system as they had the module used, but never implemented it.
To remove AA, I dipped into my script library for the AA removal scripts from KB915903. After being alerted at the scripts were no longer available, I thought it might be useful to others to post them here.
The scripts are available from the following links:
- KB915903_AA_Remove_AACompete_DYNAMICS_10 – this script needs to be run against the system database (typically called DYNAMICS).
- KB915903_10 – this script should be run against all of the company databases.
- KB915903_DYNAMICS_Remove_DB_Upgrade_10 – this script is run against the system database.