Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Sign Up Now!Log In
mark nelson 2/14/2016 11:17:50 AM

Trying to look up all available GL account numbers by segment

I was given a request by our finance department to find all available GL account numbers filtering by segment two.

I naturally looked at GL40200 to see what was available by segment, however our finance department routinely activates and deactivates posting accounts.

So what I found was that not " used " were actually accounts that had descriptions and were simply marked as inactive, so these were not what I was looking for. I am trying to fulfill this request to assist our entire finance team in a massive way I am told they will need to know over 7400 accounts to be setup for internal reporting to our parent company.


I am honestly not sure how this would be possible without some sort of logic to locate all available accounts that have never been setup, I am looking for all available second segments in all nine of our companies. But not sure how to query something that has no record yet created.



10100-25000-05679 Cash discount Active

10100-25002-05679 Cash rebate Inactive

10100-25001-05679 " this should be available for usage" this is the type of info I am trying to determine, I would expect a massive list of potential   account numbers.


Version: GP 2010
Section: Dynamics GP, SQL Scripts

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables