web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Chart of accounts set-up

(0) ShareShare
ReportReport
Posted on by 40
We’re re-organizing how our COA is set up in GP as our business grows.  Historically, we had our COA set up to gather expense data by cost center and project, however this required multiple accounts for each "natural" expense account (i.e., one for each cost center).  As our business evolves, the COA is becoming unmanageable (currently we have over 1,000 accounts and if we continue on this path, we’ll have over 2,000 soon!).  I’m a novice to GP and don’t know a whole lot about how it works (or how it can work), but I do know there has got to be a better way to get the information we need (i.e., to be able to accumulate costs by departments and projects without essentially having a separate chart of accounts for each of our departments).   We’re looking in to AA, but again I’m not sure if we know the full capability or how it works with FrX.  Is there any advise anyone can provide (resources, tools, suggested approaches, etc); or is 2,000 accounts reasonable for GP?

 

Thank you in advance. 

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,625 Super User 2025 Season 2 on at

    2,000 acounts is not an excessively large COA.  I have a client who has over 45,000 accounts!  And they use project accounting.  However, I agree with you, I like to keep a COA as lean as possible.  A couple of options for you (depending on budget) are to look at using either GP's Project Accounting or a 3rd party project costing app like Wennsoft.  Personally, I like Wennsoft's product better.  It's easier to setup and maintain and provides more flexibility than GP's.

    Hope this helps,

  • jeffb Profile Picture
    305 on at

    We have over 2700 accounts, but with GP and FRX it is no problem. It allows us to zero in on our revenues and expnses . We have been on GP over 10 years and it is not a problem. That is the advantage of having a high powered system to crunch the numbers.

  • K Day Profile Picture
    7,365 on at

    I have a little experience with Analytical Accounting and found it to be pretty neat and a little clunky at the same time.  I never did get around to figuring out how the Analytical Accounting Add-In worked with FRx; got it installed but the client has never really wanted to see information presented other than what they can get from the AA type reports in the system and from Smartlist.  But if you were using it as you say, to have multiple departments or projects, or things that might otherwise be a segment of a GL account, you would probably want to get that AA for FRx working.  This company used it for more trivial purposes, like which employee was travelling, what country, what airline, what type of expense (taxi, train, subway, etc..).

     

  • Justin Thacker Profile Picture
    40 on at

    thanks for the info guys.. this helps me see that we may not be too far off base in our set-up.  I had worked with SAP previously and their approach is a little different..

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans