Clarity

Expand all | Collapse all

Clarity report generated does not match with posted timesheet values

Jump to Best Answer
  • 1.  Clarity report generated does not match with posted timesheet values

    Posted 11-07-2017 01:27 AM

    Hi,
    We are using Clarity PPM v12.1 project management tool.
    For generating resource report when we run populate resource allocation report we found some mismatch between the posted timesheets and actuals value in generated report.
    We check all the jobs are running fine and data is getting feed correctly to system but some resource the actuals value are not available in generated report while the timesheet values are shown as posted for the resources.
    Could any one please help us to resolve the issue?

    Thanks,
    Bharat



  • 2.  Re: Clarity report generated does not match with posted timesheet values

    Posted 11-07-2017 02:39 AM

    There could be two approach I can think of 

     

    1. Check the tables to see if the data is there and report not showing up, then report logic needs to be looked.

    2. If the data is not there in underlying tables then it could be mismatch between PRASSIGNMENT.practsum and PPA_WIP.

     

    Try the below steps to see if you can get through 

     

    1. Admin > finance > manage matrix > set the prior rate
    2. Run the full Rate Matrix Extraction job.
    3. Adjust the timesheet/transaction down to 0 hours.
    4. Admin > finance > manage matrix > set the correct rate.
    5. run the full Rate Matrix Extraction job. .
    6. Adjust the timesheet/transaction to positive, non-zero hours
    7. Run the Post Timesheets (PT) job.

     

    Let me know how it goes 

     

    Regards

    Suman Pramanik 



  • 3.  Re: Clarity report generated does not match with posted timesheet values

    Posted 11-07-2017 03:38 AM

    ^ yep as above, but also check the time slicing setup/job - if this not running correctly there can be an obvious mismatch between the timesheet PRACTSUM and the sum of the actuals from the actuals slice (and/or from the timeentry slice)

     

    ( obviously to investigate a perceived "discrepancy" we need to know what values we are looking at  and where the values are generated from - the vague notion of a "discrepancy" doesn't give many clues!  ) 



  • 4.  Re: Clarity report generated does not match with posted timesheet values

    Posted 11-07-2017 04:01 AM

    Hi Suman,

    Thanks for your reply.

    Only for some resources the time sheet data shows as posted but while we try to generate report,the report generated does not contain those few resources while we checked the properties for the resources those are not appearing in report are similar as of properties of  the resources appearing in the report.

    Could you please suggest any reference table name to check whether any data getting stuck at any table?

    Please let me know in case you need any more information on this.

    Thanks,

    Bharat



  • 5.  Re: Clarity report generated does not match with posted timesheet values

    Posted 11-07-2017 05:42 AM

    Timesheet data goes to PRSTIMESHEET joins with PRTIMEPERIOD, PRTASK, PRASSIGNMENT, PPA_WIP



  • 6.  Re: Clarity report generated does not match with posted timesheet values

    Posted 11-07-2017 06:43 AM

    Thanks you so much Suman for your help.

    Could you help me to figure out the issue with Monthly and Weekly timesheet  data mismatch?

    The data generated with monthly and weekly properties value are not matching.

    Again thanks a lot in advance.....



  • 7.  Re: Clarity report generated does not match with posted timesheet values
    Best Answer

    Posted 11-07-2017 07:48 AM

    Hi Bharat,

     

    If Time Slicing job was interrupted at some point we might see some data miss. Please go through the below technical article to see if that helps:

    CA PPM: How to Reslice Time Slice IDs 

     

    Regards,

    Srikanth G