Analytical Accounting Microsoft Dynamics GP 2018 Upgrade Error
January 23rd, 2018 by Ian Grieve
Over the last couple of weeks we have been on a bit of an upgrade splurge with clients; a number of them are doing test upgrades to Microsoft Dynamics GP 2018 from a variety of versions. One client is upgrading from Microsoft Dynamics GP 2016 RTM to 2018 RTM; according to the Upgrading Microsoft Dynamics GP hot topic, Microsoft Dynamics GP 2016 can be upgraded from version 16.00.0439 or later; however, when Analytical Accounting is installed, this is not correct.
To upgrade the client, we upgraded them to the last hotfix for Microsoft Dynamics GP 2016 (KB4056559 which is version 16.00.0641) and then to 2018; however, GP Utilities for 2018 errored saying that it could not upgrade Analytical Accounting from that version. Fortunately, we did not have to go back to a backup and redo the upgrade, as, while AA in installed, this particular client does not use the module.
I used the scripts to remove the tables and other database objects and was then able to run the 2018 GP Utilities to do the database upgrade without further issue.
I have previously upgraded a test system from 2016 to 2018 without issue; this was from KB3194397 (version 16.00.0558). We do have a small number of other clients with AA installed, so we now know what version of GP 2016 to upgrade them from to avoid this issue.
January 22nd, 2018 by Ian Grieve
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.
January 19th, 2018 by Ian Grieve
Belinda Allen has recently done a blog post with download links for all of the What’s New documents from Great Plains 6 through to Microsoft Dynamics GP 2018.
It’s fair easier to find the What’s New document you want from Belinda’s page than it is searching through Partner/Customer Source.