Today I needed to get a quick list of all our national accounts that we have setup in Dynamics GP and I did not see a SmartList object for this so I went to SQL to get this information. Below is the code that will show you a list of all your national accounts. Please note this query is database specific.
/* Shows a list of all the national accounts for a company in Dynamics GP. */
SELECT * FROM dbo.RM00105
ORDER BY CPRCSTNM ASC
I should also mention that most of the time I would only specify the columns I wanted returned instead of using the SELECT *. But I was in a big hurry so I cheated.