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.
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.
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.
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