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