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.


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


All replies

  • Hi there,

    Please look at the Christophe's excellent article :

    • 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.



    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