Microsoft Dynamics GP (Archived)

How to Find how many table used in a single form of dynamic GP

(0) Share

Report

Posted on by Community Member Microsoft Employee

hi please provide step to find list of table used in a dyanmic GP Customer form.

*This post is locked for comments

All responses (5)

Answers (0)

Thomas Newcomb 1,810 on at

Like (0)

Report

RE: How to Find how many table used in a single form of dynamic GP

Hi Kirit,

I just wanted to see if you have any additional questions on this issue.

Please don't hesitate to ask!

~Thomas Newcomb

------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights
Richard Wheeler 75,730 on at

Like (0)

Report

RE: How to Find how many table used in a single form of dynamic GP

Another thing you can try is this in your test database. Enter a transaction and take note of the transaction number. Then run a script like the one in this link and search all tables for that string. Keep in mind that a transaction will move from one table to another as it gets posted or applied so timing is critical.

gallery.technet.microsoft.com/.../Discussions
Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

RE: How to Find how many table used in a single form of dynamic GP

Tim Explains it very well, and also explain at what extent running sql profiler works as suggested by waseem. : )
Suggested answer

Tim Wappat 5,701 on at

Like (1)

Report

RE: How to Find how many table used in a single form of dynamic GP

Go to Microsoft GP >> Tools >> Resource Descriptions >> Windows

Select the series and window of interest. A list of tables attached to that window will be supplied in the tables list.

You may then need to repeat this process, this time using Microsoft GP >> Tools >> Resource Descriptions >> Tables -for the tables themselves in order to identify the SQL name for the tables, as the tables listed will be using the Dexterity alias name.

Alternatively GP Power Tools gives a lovely user interface for exploring GP resources, however it is a pay for 3rd party product.

SQL trace gives a clue about the interactions between form and database, but often when checking the tables you find interactions with tables you never even thought of that may only happen through certain logic paths.
Suggested answer

waseem 230 on at

Like (0)

Report

RE: How to Find how many table used in a single form of dynamic GP

you can get required information via SQL Profiler trace log.

start profiler . apply filter with current GP user id. clear trace, open GP form and also open any existing record.