Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Analytic Accounting - Account Class

Posted on by 22,647

We are using AA in a company database that has 2 segments - FUND ID and MAIN Segments
We are trying to track costs in each of the Funds Projects

Challenge is that the client wants to keep the impact of this work to a minimum in the General Ledger - to that end they want to continue the process started in their first system QuickBooks.  In which the accounts clerk entered the transaction and coded to AP and Contract Expense - it does not matter what the expense is for, it is related to a contract so, it is a Contract Expense - GL 20-7400 or 25-7400

So, question one - I have about 15 to 20 projects - Transaction Dimensions and about 200 Dimension Codes - roughly 10 to 1

How do I set up AA to allow this to happen correctly.

Question Two
The client works on a non-profit mode and so, when they have projects that generate revenue, they apply that to the "Operation" expense.  This could be and is not limited to almost all the expense accounts found for FUND ID = 10 in the current COA.
What this means is that if the Office Rent 10-7200 has 10,000 the controller will want to allocate this expense to the vaious Projects. 
It is our understanding that with AA she should be able to open the related JE that has been posted and ADJUST the AA posting and allocate 5,000 to a project and leave the balance in the Ops account.

IS this a correct assumption?

IF YES - then how do I create this configuration in AA.  As I have been reading a single GL account can only be in one Account Class
So I have been thinking that I have to create one Account Class with all the 20 / 25 Fund Expense accounts and attach them to all the transaction Dimension Codes
Is this making sense?

As you might have figured out, I am new to the AA implementation and need direction in the worst kind of way.  Anyone willing to assist, please get on and do what you can to straighten out this matter.

Thanks.

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans