GP SQL TABLE

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I want to know which sql table contain the additional information (Windows : internet information) for the inventory >cards>item> item maintenace –Description : the blue i

thank you.

aissam.

*This post is locked for comments

All responses (4)

Answers (3)

Verified answer

sueconrod 335 on at

Like (0)

Report

Re: GP SQL TABLE

That is actually in the Company tables. Take a look at the SY01200 and I think you will find your information.

Always remember you can go to the Microsoft Dynamics GP>>Tools>>Resource Descriptions and find the tables you need. Once you find the table you think is right double click on it and it will show you all the information on the table.

Or you could just install the debugger tool from Mario Gomez and David Musgrave and it would tell you what field and table you are looking at...

You can get your partner to install this tool and teach you how to use it. Takes care of a whole lot of issues that you typically run into in Great Plains.
Verified answer

Jason Chung 1,110 on at

Like (0)

Report

Re: GP SQL TABLE

As mentionned prior to this post, SY01200 contains internet adresses... I would strongly suggest you to download and install the Support Debugging Tool. It is by far the greatest asset an IT dude supporting GP can have. Go visit David Musgrave's blog at

blogs.msdn.com/.../support-debugging-tool-build-15-update-released.aspx
Community Member Microsoft Employee on at

Like (0)

Report

Re: GP SQL TABLE

it's great thank you very much.
Verified answer

GPDavid 2,250 on at

Like (0)

Report

Re: GP SQL TABLE

Check SY01200 where Master_Type = 'ITM'