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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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,588

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

I have the same question (0)
  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at

    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

  • chadbruels Profile Picture
    chadbruels 1,588 on at

    Thank you, David.

    Do you create records in the db_Upgrade table as well?

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at

    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,588 on at

    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 ... 14,095 Most Valuable Professional on at

    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,588 on at

    Thank you for that confirmation.

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

  • chadbruels Profile Picture
    chadbruels 1,588 on at

    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.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans