National Accounts in Dynamics GP 2013 R2

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

jcox@hexoma.com
One Comment

Add a Comment

Your email address will not be published. Required fields are marked *