another blog

Icon

About Microsoft Dynamics GP :-)

Finding Field Name and Table Name of custom table.

That’s not a good thing to copy and past. 😦

Mr. Phani  copy my this post and publish in his blog without referencing my blog post.

 

phani4dexterity

This post is specially for new comers for GP who find it difficult to know field names and table names of custom table when need to use in sql scripts for their add on application for Dynamics GP.

 

 Let take an example of Customer Maintenance. We have added a table evsTable and it’s two fields on a window.

Field 1 and Field 2.

Image

Now what you have to do is to open the window for whose field information you need, lets say we need to know in which table Field 1 will save data and what is the physical name of Field 1 to use in sql.

 Just focus on some other field and press Alt+F8 and save macro file anywhere.

Image

Now focus Field 1.

Again press Alt+F8.

 

Now go to the path where you have saved macro file and open it on notepad. You will find field…

View original post 55 more words

Advertisements

Filed under: Dexterity Development, My Thoughts

2 Responses

  1. phani says:

    Dear Almas,

    apology for this.

    i kept in my blog for my reference that it

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: