Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Analytical accounting or project accounting?

(1) ShareShare
ReportReport
Posted on by

We would like to implement either analytical accounting or project accounting. 

We are on GP2016 R2, we do not use SOP, POP, PR or inventory.  We import sales transactions from another system into AR.  We have many "projects" going at the same time.  Right now we add an entire set of GL expense accounts for each new project which has its own GL segment.  We do not normally report on the expenses by project.  Occasionally someone will need the total cost on a project so we need a way to produce that information, which is the only reason we are tracking by project.  These project costs come from AP or GL, any labor comes from a GL entry and there is never any billing associated with them.  In the last 12 months we had 449 transactions consisting of 3724 distribution lines put into 144 projects.  100 of those transactions were GL transactions (3375 distribution lines), the great majority of them being from charge cards that are copied and pasted into a GL entry.  We have a program that will paste in the AA dimension, but not sure if there is anything available to paste into project accounting.  We are trying to reduce the number of GL accounts.  We add over 100 accounts per project and use only about 10 or less per project.  I do eventually delete the unused accounts, but they need to be created and available until the project is completed.

Can someone explain the advantages/disadvantages of using analytical accounting or project accounting in this instance?

Thanks,

Marilyn

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Analytical accounting or project accounting?

    Thanks so much for the information.  This is exactly what I was thinking.  I thought project accounting was overkill in our situation.

  • Verified answer
    Heather Roggeveen Profile Picture
    9,146 on at
    RE: Analytical accounting or project accounting?

    Hi Marilyn

    Based on the fact that you do not currently use SOP, POP, PR or Inventory, I would suggest Analytical Accounting would be the way to go.

    AA dimension codes can be allocated to GL only transactions (as well as all the sub-ledgers).  You have flexibility around reallocating codes if needed - without backing out and reentering transactions.  You can create MR reports based on AA - giving the ability to create a P&L and / or BS per project.

    You can add budgets for AA for projects and all sorts of pieces.

    Project Accounting is a very intensive module.  I think it may end up giving you quite a bit over administrative overhead to have it track correctly.  It really does work well it you want to track full SOP invoicing, purchase items for use, add timesheets.  But that sounds like a level of transaction that you just don't have value with.

    AA can also be quite intensive.  If you have not used it before, it may be worth talking to your GP partner for some guidance on setup.

    Hope that helps.

    Cheers

    Heather

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans