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

1 thought on “National Accounts in Dynamics GP 2013 R2

  1. Jonathan P Cox Reply

    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.

Leave a Reply

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