web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... *CHALLENGE* GP "old ti...

Finance | Project Operations, Human Resources, ...

Suggested Answer

CHALLENGE GP "old timers", tell me, can you name the legacy products in the database?

(2) Share

Report

Report

Posted on by Tim Wappat

5,721

So I've been having a seriously deep clean out of Dynamics GP database and have figured out what 99% of the tables are but have these left over.

I'm removing them as they are mostly from year 2000-2004 and mostly empty, but curious if anyone can name the product that they relate to as Google has failed me.

So these are all company database except for the one marked DYNAMICS.

Fun game.... can you put a name of the product against the column?

Column0 :

Column1 :

Column2 :

Column3 :

Column4 :

Column5 :

Column6 :

Column7 :

Column8 :

DYNAMICS:

Column9 :

/Table

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Beat Bucher GP Gee... 28,069 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Tim,
The tables from the column 9 (DYNAMICS) seem to be related to some 3rd-party product.. the others are common company table modules, but you should be extremely careful by not removing tables or content that belongs to “core” GP modules..
This site from a former Dynamics GP MVP (@Ian Grieve ) has a reference catalog for about 99% of the tables in GP company & System DB's.. https://gptables.azurecurve.co.uk/
This should help you identify the tables you're looking for.
Beat
PS: Column 6 tables look like a 3rd-party too.. BOMxxxx tables are related to MfG and Inventory, POPxxxx to the purchasing module. PCBxxxxx, RFQxxxx, POTxxxxx, seems all to be related to 3rd-party.. That's even more concerning if you haven't clearly identified which module they belong.
PPS: another excellent tool to identify tables related to GP forms is the GP PowerTools add-on. It has a resource finder that helps identify tables and fields inside of GP. The tool can be installed with a free 30-day trial : https://winthropdc.blog/gp-power-tools-portal/ (written by @David Musgrave MVP GPUG All Star Legend Moderator )

Was this reply helpful? Yes No
Tim Wappat 5,721 on at

Like (1)

Report
Copy link

Link copied!

Thanks Beat,

I had checked the tables are not referenced by GP before removing them, and did lots of research in the database too. I don't like dealing with issues arising, so very risk averse on this.

3 years later since posting that, and upgrades applied etc, nothing broke yet…!

I even tried AI on it today just to see if it could find anything.

It suggests Analysis Cubes for Excel for the "DYNAMICS” col. Which we did have at one point. So plausible.

But I can tell its guessing with the other answers, in same way I am. It was just a curiosity. I'm sure they are old modules that never got used. Or ISP products that were installed for demo but disappeared a long time ago.

Tim.

19 Sep 2023

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

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

#1

Martin Dráb 330 Most Valuable Professional

#2

CU10121822-0 310

#3

André Arnaud de Cal... 242 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans