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.
Example
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.