Re-allocating Actual Costs and Actual Work from one project to multiple projects RRS feed

  • Question

  • My company would like to track costs in one project and then re-allocate those costs to multiple projects.  Example: An end user would submit a timesheet against a task named 'Analysis' for Project A.  Once accepted and published, the costs for those hours would be subtracted from Project A and 60% of those costs would be transferred to the 'Analysis' task for Project X and 40% of the costs for those hours would be transferred to Project Y. 

    We believe we can accomplish this through reporting, but before we go this route, we wanted to make sure there was not a logical, supported way in MS Project Server to complete these actions.  Could a script be developed to accomplish this?

    Thank you!


    Thursday, July 17, 2014 8:52 PM

All replies

  • Out of the box Project and Project Server do not support this. However with VBA anything is possible. You could also use PSI to work directly with project data in teh Server db but that would take much longer to develop. Check you can do what you want in VBA then you can use the result to spec the server version afterwards.

    Rod Gill
    Author of the one and only Project VBA Book

    Friday, July 18, 2014 8:21 AM
  • I should point out that this specific scenario is supported through our UMT 360 add on to MS Project Server.

    Andrew Lavinsky [MVP] Blog: Twitter: @alavinsky

    Sunday, July 20, 2014 2:35 AM