Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / duCompanyVersions + Cl...
Microsoft Dynamics GP (Archived)

duCompanyVersions + Client Customization?

(1) ShareShare
ReportReport
Posted on by chadbruels 1,582

Twelve years developing for Dynamics GP and this is the first time someone has asked me to create a record in duCompanyVersions for the Dexterity customization we built for them.

I am only vaguely familiar with the duCompanyVersions table. Before I go adding a record to it, I want to make sure I know how I should do that and what I'm potentially impacting down the road. I understand this table is leveraged in the upgrade process, but I do not know how to anticipate my customization's records would do, if anything, to that process. What should I be doing with my customization to keep these records properly up to date as time goes on and patches and upgrades are applied?

*This post is locked for comments

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,917 Most Valuable Professional on at
    RE: duCompanyVersions + Client Customization?

    Rockton Software's Toolbox has VersionPro which can check dictionaries installed.

    Also, in your code, you can check the duCompanyVersions table and show a dialog if the server has a later version in the tables than the dictionary installed.

    David

  • chadbruels Profile Picture
    chadbruels 1,582 on at
    RE: duCompanyVersions + Client Customization?

    This is interesting. I believe further discussions have revealed what the client is truly looking for in version control. They have something like 20 terminal servers and wish to easily determine the version of our product installed on each so as to ensure a consistent deployment across all. Let the brainstorming commence - I need more tea.

  • chadbruels Profile Picture
    chadbruels 1,582 on at
    RE: duCompanyVersions + Client Customization?

    Thank you for that confirmation.

    As always, your depth of knowledge and time shared with this community is most appreciated.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,917 Most Valuable Professional on at
    RE: duCompanyVersions + Client Customization?

    Hi Chad

    db_Upgrade is specifically used by Dynamics Utilities during the upgrade process. Unless you are writing your own code to integrate with Dynamics Utilities, I would suggest leaving this table alone.

    Adding records into it for products not supported by Dynamics Utilities could cause upgrade errors.

    David

  • chadbruels Profile Picture
    chadbruels 1,582 on at
    RE: duCompanyVersions + Client Customization?

    I have request to also create records in db_Upgrade and I am considering why it would be desired. The client sites our product having "no version control in DYNAMICS..db_Upgrade". Can I trouble you for a brief background on this table which might aid me in understanding its purpose and interpreting the request I face?

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,917 Most Valuable Professional on at
    RE: duCompanyVersions + Client Customization?

    Hi Chad

    Nope, just duCompanyVersions.

    My upgrade code can bring any old format to the current format and does not need duplicate table definitions kept in Dexterity.

    David

  • chadbruels Profile Picture
    chadbruels 1,582 on at
    RE: duCompanyVersions + Client Customization?

    Thank you, David.

    Do you create records in the db_Upgrade table as well?

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,917 Most Valuable Professional on at
    RE: duCompanyVersions + Client Customization?

    Hi Chad

    I use this for all my products. It does not cause any issues with Dynamics Utilities having additional products in the table.

    I update the record for system and company once tables have been installed/upgraded for that database.

    David

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans