Timesheet Exception Report. Help Needed | Community
Skip to main content
E
ElaineHe
May 5, 2021
Solved

Timesheet Exception Report. Help Needed

  • May 5, 2021
  • 1 reply
  • 664 views

I am trying to figure out a way of doing an exception report, whereby, if a user updates a re-opened timesheet that does not belong in that specific reporting period the report will pull it out.

I have tried using the input date against the timesheet date, but the original input date remains.

eg: Reporting period is 1st-30th April, a timesheet for 1st March is re-opened and updated and closed in April, input date still shows 1st March.

Exception report would need to show what timesheets were updated in April but don't belong to that reporting period.

if anyone has any ideas I would be immensely grateful, I can happily admit I am no good with text mode, so I have just been using the standard filters.

TIA

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by imgrund

Hi - have you looked at the Last Update Date? Maybe you can do a filter where Last Update is greater than $$TODAYbm and Input Date is less than $$TODAYbm.

I'll be honest, I'm very new to the timesheet/hour reporting, but I checked the API explorer and both object types have the Last Update Date field so that might work for you. :)

1 reply

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
May 5, 2021

Hi - have you looked at the Last Update Date? Maybe you can do a filter where Last Update is greater than $$TODAYbm and Input Date is less than $$TODAYbm.

I'll be honest, I'm very new to the timesheet/hour reporting, but I checked the API explorer and both object types have the Last Update Date field so that might work for you. :)

E
ElaineHeAuthor
May 6, 2021

Thanks Anthony.

That worked. I think I must have been looking at the report for too long, we use that filter for other reporting too :)

Terms & ConditionsAccessibility statement

Loading footer...