locked
Project Server 2010 Timesheet custom field RRS feed

  • Question

  • All,

    I have a client which require to capture the daily location of a resource in the project server timesheet. Ideally they want to be able to report where the resource was located for each specific day of the week and keep a history as well. This will then be used for billing purposes.

    I was wondering if anyone has done any similar implementation. A resource level custom field would be ideal but not sure how the historic information will be retained.

    Any assistance will be ,much appreciated.

    Thanks.


    Regards, Naweed
    Friday, December 2, 2011 10:40 AM

Answers

All replies

  • Hi there,

    Please look at the Christophe's excellent article :
    http://blogs.msdn.com/b/chrisfie/archive/2010/04/06/project-server-2010-timesheet-custom-fields.aspx

    • Create a lookup table like Reporting location and task level custom field like Resource Reporting location & associate the CF with Lookup table Reporting location
    • Create a new Timesheet view and add the newly created custom field
    • Create a timesheet, select the newly created view and the new column (“Resource Reporting location”) should appear
    • Select the value desired and submit timesheet
    • data is stored in the Reporting database and can easily be accessed using the MSP_TimesheetLine_UserViewCF view, so create your own Excel view (and custom ODC) to easily report against it

    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Friday, December 2, 2011 10:50 AM
  • Hi Amit,

    I have had a look at this option but I believe this will give the location for just one week(timesheet period). we need to be able to get a daily record.

    I have just come across the link below but can be adapted for PS 2010.

    http://gj80blogtech.blogspot.com/2010/05/daily-timesheet-comment-in-project.html

     


    Regards, Naweed
    • Marked as answer by Naweed Jaulim Monday, November 19, 2012 3:12 PM
    Friday, December 2, 2011 10:55 AM
  • Hi Naweed,

    I believe that you can do a similar stuff using PS2010.

    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Monday, December 5, 2011 7:00 AM