Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Finding Database table from each form

Posted on by 155

Hi,

I am a new GP user, Is there any option to find the particular table of Database from the form, where it is exactly storing ?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Finding Database table from each form

    All the previous suggestions would be helpful. I would image there would be at least three tables involved here. The trx work table along with a batch definition table plus a distribution table. I would enter a transaction manually and then see w hich tables get hit. You could use SQL Profiler or search for text strings in tables.

  • Christine.N Profile Picture
    Christine.N 10 on at
    RE: Finding Database table from each form

    I want to build a table import for time card entry in WennSoft.  I see the table WS Time Sheet TRX WORK, is that the correct table?

    Also, Do I have to build all fields in the excel import template or do I just build the fields I need only?  Thank you so much

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Finding Database table from each form

    Rockton Software makes a product called Inspector that I believe may give you exactly what you want. You start the inspector product, open the window in question and then click on the field you are trying to find. The software will suggest the probable table the field exists in. It's part of Rockton's Dynamics GP Toolbox: www.rocktonsoftware.com/.../dynamics-gp-toolbox

    Kind regards,

    Leslie

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Finding Database table from each form

    A simple way is to open the form and then click Tools->Integrate->Table Import. This will give you a list of tables associated with this form. You can then use Tools->Resource Descriptions->Tables to get the table names.

  • Suggested answer
    Pablito Profile Picture
    Pablito 225 on at
    RE: Finding Database table from each form

    If your organisation happens to be using SmartList Builder (by eOne), it comes with a Table Finder utility which is hugely useful for this purpose. If you have it, it is under the tools menu. Simply open the form you're interested in and select Tools | Table Finder to see the various tables associated to the form. I offer a small word of caution: I have seen a few situations where some related tables that should show up in the tool, simply don't. It is rather rare in my experience and I think more so when dealing with 3rd party integration tables (which I assume may not always be doing things in the GP "standard" way), but it is something to keep in mind.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Finding Database table from each form

    Your first port of call should be the Resource Descriptions on the Tools Menu.

    After that you could post here if you need to know specific tables where form data is stored.

    If you have 'Modifier' you could open the window in modifier for a clue as t the main tables involved. (Open the window and click Tools >> Modify Current Window.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans