I have a portlet where I do have multiple entry of same task under same project with 2 timesheet status Adjusted and Posted. Eg : Resource A is charged twice under the Project task X with Timehseet status Posted as 20 hrs, and again with status Adjusted, same resource A is charged 20 hrs. Now that I need to eliminate the posted record if I have both Posted and Adjusted for same project task.
Is there any field to check when the timesheet status change from Posted to Adjusted? I tried with PRISADJUSTMENT and PRADJUSTEDID fields in PRTIMESHEET table. But that is of no help. Can you guys suggest me with a workaround please to extract only Adjusted time record from both?