Clarity

 View Only
  • 1.  Posted Actuals for a task in timesheet equals 0 when it has posted actuals

    Posted Aug 29, 2014 04:36 PM

    A resource has posted actuals for a certain task that she has been registering time. Post timesheets process has run without problems. Investment Allocation job runs everyday.

     

    The issue is just for 2 resources, other seems to be fine at the moment.

     

    Somebody knows what can cause the problem?

     

    Thanks for the help.



  • 2.  Re: Posted Actuals for a task in timesheet equals 0 when it has posted actuals

    Posted Aug 29, 2014 08:02 PM

    Do you mean that the 'Posted Actuals' column on the timesheet page shows 0 for the resource while the timesheet status is shown as 'posted'? If so what's showing for 'Actuals' on the project task assignment page for this resource?

     

    Some screenshots would better explain the problem here.



  • 3.  Re: Posted Actuals for a task in timesheet equals 0 when it has posted actuals

    Posted Sep 16, 2014 02:20 PM

    Is the timesheet status actually posted?

    Which Clarity version?



  • 4.  Re: Posted Actuals for a task in timesheet equals 0 when it has posted actuals

    Posted Sep 16, 2014 04:28 PM

    As Connie has mentioned, can you share some screenshots ?

     

    NJ



  • 5.  Re: Posted Actuals for a task in timesheet equals 0 when it has posted actuals

    Broadcom Employee
    Posted Sep 16, 2014 08:54 PM

    Once the timesheet is posted, the actuals should be seen under Task -> Actuals against which the user has entered the actuals and there is no pre requisite for any jobs to run. But the big question is - Has the timesheet really posted the actuals from all the task in the timesheet?  As we wait for your screenshots, here is a quick check you can do in the meantime from the DB to see if the actuals are posted for all the task in the timesheet.

    If the user has entered actuals against multiple tasks in the same timesheet and after running the Post timesheet job, the timesheet status might show as POSTED but it does not mean that the actuals against all the tasks are posted. You will have to check from the DB and confirm the actuals against all tasks are posted. This can be done by checking the prrmexported flag. If this column shows 1, then its posted successfully if its 0 then its not posted.


    select prrmexported from prtimeentry where prassignmentid = (get the prid from the prassignment table) and prtimesheetid = (get into the timesheet and in the URL, copy the 5million number from id=5*****)


    If the result is 0, then check for the below


    project financials is open

    Resource financials is open

    Resource track mode is Clarity

    Project status is approved

    Resource is still active

    Resource is open for time entry


    Ideally few of the above conditions should be met for resource to enter timesheet, but I have seen cases where resource enters the timesheet and before the post timesheet job runs, the PM or RM removes his OTE and deactivated..


    Thanks,

    Jerin

    CA Technologies


     



  • 6.  Re: Posted Actuals for a task in timesheet equals 0 when it has posted actuals

    Broadcom Employee
    Posted Oct 24, 2014 08:35 PM

    All,

    There is an IDEA posted in the communities to build an OOTB portlet which shows up all the timesheet records which are stuck in timesheet table because PRRMEXPORTED = 0. If you feel this is going to benefit you to find the 'missing' timesheet hours from UI than writing queries and executing in DB, go vote for the idea.

    https://communities.ca.com/ideas/235716001#comment-233899003

     

    Regards,

    Jerin