Is it possible to find the date and time for user entered timesheet.
can you please advise on this
The timesheet table stores the last modified date and time and not the submitted time in particular.
This means, if the timesheet has been submitted and later approved/rejected, then the last action time on the timesheet will be in the tables. However you can find who submitted the timesheet.
PRTIMESHEET is the table you might want to look into for these info.
Thanks for your Reply..
I want Date and Time when the time entries were made on entire timesheet..
Like as I said, if the timesheet is already approved/rejected or posted, then we cannot get he date and time when the timesheet was submitted.
prtimesheet.promodtime is what gives the latest activity on the timesheet.
If the timesheet is still in submitted status, then check the above column and you should get the details.
When a timesheet is created a record is created in prtimesheet.
When a timeentry is made a record in prtimeentry is created.
The prdmod field will tell the time the entry was last updated which is regardless of the timesheet creation or status.
1. The PRTIMESHEET.prmodtime will be updated when the timesheet is edited, saved, approved, or returned.
2. After the Post Timesheets job processes a timesheeta. PRTIMESHEET.posted_time will be setb. PRTIMESHEET.prmodtime will get set to the PRTIMESHEET.posted_time
3. If the goal is to obtain the latest PRTIMESHEET.prmodtime when it approved, a customization will need to be considered.
Retrieving data ...