Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How to generate list o...

How to generate list of GL accounts within a Category?

(0) Share

Report

Posted on by Justin Unertl

I am trying to generate a list of all GL accounts within a category. For example, I want to look at the entire list of accounts we have mapped to the "COGS" and "SG&A" categories. Does anyone know a quick way to do this? Thanks.

*This post is locked for comments

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: How to generate list of GL accounts within a Category?

Well Justin

Select Microsoft dynamics GP menu then select smart list. In smart list select Financial then accounts after clicking account select a tab menu of smart list search and define criteria of searching.
Example
Column Name Filter Value
Account Category Number is equal to Cost of goods sold

and then save it to Dynamics Favorites.
Cheer
Justin Unertl 40 on at

Like (0)

Report

Re: Re: How to generate list of GL accounts within a Category?

Perfect. Thanks for the quick response. I appreciate it. -J
Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to generate list of GL accounts within a Category?

Accounts SmartList - sort by Account Category Number (which is actually Account Category name).