I have a need for SOX compliance to prove that a User’s account has been deactivated promptly upon an employee’s termination. I have created a custom report from the framework of the User List Report and need to pull in the date/time the user’s account is deactivated OR date/time a user’s role is removed. I have auditing turned on for these, but am not sure how to relate the audit values with User’s table. Any ideas?
Howreport on the Date/Time of a User's Deactivation
Hi
I just created a generic inquiry for audit history associated with the Users screen after activating audit history for the Users. Attached is the sample generic inquiry in XML so you can load it into your system. You should be able to take it from here in terms either using the GI on a screen or if you want to create a report with similar fields from the AUAuditValues table.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/e261486b-160f-4740-9c94-f8ba7afe2c18.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/992f67cc-0b6c-416b-ab62-3e95c09732cc.png)
Hope this is helpful.
David Eichner, CPA
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.