Answer

GI Last Execution Time/Date

Forum|Forum|3 years ago
August 12, 2022
3 replies
98 views

K2a
Jr Varsity III

Hello,

I see a few tables in the DB for GI's. None of them seem to tell me when the GI was last run and by Whom. I only see created by and modified by.

Does anyone know of how to get this info?

We have some legacy GI's that need to get cleaned up and I was hoping to use this as a starting point.

Cheers,

k2

Best answer by Ahmed

@K2a if your GI has a screen ID, you can review the Access History screen to determine who was last using that screen and when.
Just export to Excel that data and also the list of all the GIs and their screen IDs and then… with some Excel vlookups and other tricks in Excel you can compile a list of when each GI was last accessed.

+19

Naveen Boga
Captain II
Forum|Forum|3 years ago
August 14, 2022

Hi @K2a As far as I know we can able to the know below info by enabling the Field Level Audit for the Generic Inquiry screen, but I don’t think we can get who executed GI last time info.

Created by whom
Modified by whom
What details are modified on the GI
When the user modified

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/

Like

+1

Ahmed
Varsity II
Answer
Forum|Forum|3 years ago
August 14, 2022

@K2a if your GI has a screen ID, you can review the Access History screen to determine who was last using that screen and when.
Just export to Excel that data and also the list of all the GIs and their screen IDs and then… with some Excel vlookups and other tricks in Excel you can compile a list of when each GI was last accessed.

R