Audit of Time Sheet Entry changes ?

Hello,

I am trying to create a saved search on “Time” sheet entries to audit if the hours of an employee were changed and who made that change (Approver/PM) and on which date (last modified), what was the original hour entered and  what is the new/changed hour duration?

However, when selecting the fields from the list during  saved search creation, I couldn’t find any option or fields for selection from system_notes table in the list. It only shows workflow_history related fields.

I also tried creating SQL query using NetSuite ODBC to join employee_time with system_notes table but with no luck; since there’s no common link (field’s) between these two tables.

Please suggest/recommend.

Thanks!

Rookie Asked on May 28, 2021 in Saved Searches.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor