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: Project Allocation
Feature Pack 1 for GP 10 added the ability to allocate project costs across multiple projects. Here are a couple of scenarios where this could be useful.
  • Company sends employees to a region to work on multiple projects. Hotel, Airfare, Rental Car, etc. can be collected in a single project and then allocated to all the projects worked on during that time period.
  • Company needs to apply depreciation from a piece of equipment to multiple projects. Depreciation costs could be entered for one project and then allocated among the applicable projects.
In a nutshell, Project Accounting Allocations create a negative Miscellaneous Log transaction to move costs out of one project and positive Miscellaneous Log transactions to allocate costs to the other projects. This works across projects and contracts.

So let's take a quick look at the process.

First, setup a Project Allocation Schedule in Project Allocation Maintenance (Cards-Project-Project Allocation). Here you specify one or more From and To Projects, Cost Categories, Misc. Log Trx and Misc. Log Cost Categories. Available allocation methods are Percentage, Units and Amount. For Percentage or Amount type you'll need to add the percentage or amount. That's it for the actual setup. Keep repeating until you have all the allocation lines setup.

To process an allocation, go to Transaction-Project-Allocation. Select the Project Allocation ID (schedule) from one you created and use the insert button to move it to the right. You can run multiple allocations at once which is nice. You can limit allocation data by date range if you are allocatiing only this month's expenses for example. Pick a GL date and hit redisplay.

Transactions available to allocate will appear below along with the allocation result. So if you are allocating 10% you'll see the original amount and the resulting allocation amount. If there are no transactions of a type matching those set in the schedule, you won't even see those lines.

Click process and unposted Misc. Log transactions are created.

A couple of things to be aware of:
  • If you don't set a FROM Misc. ID the cost will allocate to the TO projects but no Misc. Log trx is created to remove them from the FROM project.
  • The FROM project information defaults after the first line has been completed. Very nice.
  • If you set all your TO information but the method, the next line gets created and you can't go back and change the method, you have to delete and re-enter the line. Very bad.
  • I'm still not entirely sure where unit amounts get set. The documentation photo shows them being entered in the Project Allocation Maintenance window but that doesn't work (and the documentation says it won't work). In playing with it, I can't tell if you change that in the actual allocation run. You cannot change the percentage or amount.
  • I'm not sure if you could actually take a line item negative with an allocation. I haven't had time to test
The Project Cost Allocation is a big step in the right direction. I wish that there were more options for allocation similar to Variable Allocation in the GL. I'd like to be able to allocate travel costs based on the proportional value of the projects I'm allocating to for example. However, you have to start somewhere and this is a nice start, especially as a mid-cycle bonus release!
Category:TIPS AND TRICKS BY MODULES: Project Accounting
Link Owner:
Date Added:June 21, 2010 06:11:03 PM
Number Hits:75
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.