web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Ghosts from the past come back to haunt you. GP 18.x.xxxx

(0) ShareShare
ReportReport
Posted on by 75,852 Moderator

I did an upgrade for a client last year. Looking at their DYNAMICS.SET file I installed all that was there. Today I got a call that no one can get into GP. They were getting 'The selected company not configured' message. That was very odd as they have been running fine for a year. So I ran the INTERID script and that did not help. On a hunch I ran ran GP Utilities. Much to my surprise I received a message about not being able to update products. Looking at the duinstall.log there were products:

1045 - Revenue Expense Deferrals

3180 - Analytical Accounting

4421- Grant Management

What was really strange was the message was about try to upgrade from 9.x to 18.x.

So it appears that a long time ago someone just left these products behind. I know I could just remove them from the SET file but if in the future they did want to use them. Is there anyway I could set the database so that when running GP Utilities it will install them as GP 18.x?

Categories:
I have the same question (0)
  • Joseph Markovich Profile Picture
    4,001 on at

    Richard, would support be able to give you some scripts to clean all that out so you can just start fresh?

    Found this too from a long time ago -- same kind of issue:

    community.dynamics.com/.../removing-gp-modules-for-old-versions-that-were-never-upgraded

    Joe

  • Richard Wheeler Profile Picture
    75,852 Moderator on at

    I wonder if that list that was for internal use only can be sent to an old GP person like myself?

  • Verified answer
    Derek Albaugh Profile Picture
    Microsoft Employee on at

    Richard

    You're correct in that removing features that a customer is not planning on using now, but may want to use the features in the future, there are other places we would need to remove the objects from, besides just the Dynamics.set and DynUtils.set files.

    This blog goes over that information:

    community.dynamics.com/.../quot-problem-ascertaining-version-information-quot-error-when-installing-or-upgrading-microsoft-dynamics-gp

    To use your example of Revenue Expense Deferrals/1045, with this blog, your steps would be the following:

    A. Run these scripts against the GP system database:

        1. Delete DB_Upgrade where PRODID = 1045

        2. Delete DU000020 where PRODID = 1045

        3. Delete DU000030 where PRODID = 1045   (NOTE: The DU000030 can be truncated completely, if not actively doing an upgrade)

    B. Against each and every company database, as mentioned in the SY01500 table, run this script against them:

      1. Drop Table PP000001

    By not only removing the feature from the GP system tables, but also dropping the related sub-feature tables from the GP system and/or company databases, this sets up the databases so, should the customer decide in the future they want to begin using the feature again, they can install it and, instead of upgrading the feature which in your example you wouldn't be able to do from GP 9.x to 18.x anyway, it will install the feature anew, as if it had never been installed previously.

    The other blog mentioned has the same information but the one above actually has the sub-feature tables listed for each and every feature.

    Thank you,

  • Richard Wheeler Profile Picture
    75,852 Moderator on at

    You are the best Derek. I owe you a lunch or more like a dinner by now. This is perfect. Thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 620

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 521 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 430

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans