Microsoft Dynamics GP (Archived)

Finding the Table name for Custom Fields in Dynamics GP

(0) Share

Report

Posted on by PavanBujji

192

Hi All,

Can any one tell me the process ,how to find the Table name for the Custom Fields in Dynamics GP .

I have few customer fields in Sales transaction Entry window ( Header level and Line Item Level ), but I didn't get those fields in Sales order (SOP GP Tables) tables.

Thanks & Regards,

Pavan G.

*This post is locked for comments

All responses (3)

Answers (0)

Tim Wappat 5,703 on at

Like (1)

Report

RE: Finding the Table name for Custom Fields in Dynamics GP

An example

https://community.dynamics.com/gp/b/erpsoftwareblog/posts/sql-server-profiler-capture-it-all

Google SQL Server Profiler and trace. Your objective is to capture the queries that the application is running against the database.

Then by looking at the captured information, captured while you updated a value in the field in question, you should be able to locate the table being updated.

Tim
PavanBujji 192 on at

Like (0)

Report

RE: Finding the Table name for Custom Fields in Dynamics GP

@tim, Thanks for Your response.

Frankly, I don't know about sniff .

Could you please share the other process to accomplish my output (FINDING the Table names for new custom fields).
Tim Wappat 5,703 on at

Like (0)

Report

RE: Finding the Table name for Custom Fields in Dynamics GP

There are a few different ways to customise GP.

One of the quickest ways if you are new to the installation and just need the fields, is to use a SQL trace to "sniff" the SQL whilst you make a change to those fields, limiting the output to your SQL user.

Tim