Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6100 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:Weekly Dynamic: Unit Allocations in Project Accounting
Description:Feature Pack 1 for Microsoft Dynamics GP 10 added Cost Allocations to the Project Accounting module. I covered the basics in Part 1 so go there for the overview. I was a little stumped by the way unit based allocations worked so this post should provide at least the basics to get started with allocating project costs based on units.

For starters, when you setup a unit based allocation, you don't set an amount. You can only base it off of the units on another cost category. This means that it works like a variable allocation account in that the WHOLE amount will be moved off the base project and on to the allocated projects. If you are using % or Amounts to allocate, you could leave some amount on the base project by moving say 50% to another project.

With Unit based allocations, you set a cost category on the allocate "TO" side to base the allocations off of. If you allocating to other cost categories within the project, unit allocations will move the whole thing since there is only one instance of a cost category per project. But when allocating across projects, the system looks at each projects % of the units charged and allocates accordingly.

For example, you want to allocate travel costs based on time worked to two projects. The TO cost category for basing time would be a labor based cost category. If travel costs were $1,000, Labor for Project A had 20 hrs and Project B had 80 hrs, Project A would get 20 units and $200 in costs and Project B would get 80 units and $800 in costs. No costs would be left in the base project.

Contrast this with a % or $ based allocation where you could say that you want $200 on Project A and $700 on Project B leaving $100 sitting in the base project. This scenario isn't possible with Unit based allocations. But, with Unit based allocations you don't need to know the split, you can just let the system figure it out.

It's also pretty easy to setup a control project to hold depreciation or travel costs and use Unit based allocation to ensure that no costs stay in those projects.

Where it gets a little strange is that you can mix and match the cost categories that you want to use to allocate. So one line in an allocaton setup could allocate based on time and a second line based on copier usage, completely different things. Unit allocations treats a unit as a unit for the allocation calculation. It doesn't distinguish between types of units. Obviously something like "number of copies" could have significantly higher usage and lower cost than "brain surgery consulting hours". Consequently, you'll want to be careful when setting up your unit allocations or you could make a mess.

This is a new feature in GP and the documentation is a little thin so it possible that I've missed something. If I did, feel free to leave a comment and I'll make corrections.

Category:TIPS AND TRICKS BY MODULES: Project Accounting
Link Owner:
Date Added:June 21, 2010 06:11:02 PM
Number Hits:15
RatingsAverage rating: (0 votes)

No Reviews Yet.


Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.