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