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