I’m looking to find a screen or maybe a way to create a GI view that shows the history of actions on Invoices and Sales Orders. Specifically, I want to see if records have been deleted and if so, which record and when. Is this possible?
Solved
Is there a screen that shows logs/history of actions on Invoices, Sales Orders, etc.?
Best answer by lauraj46
Hi
If you haven’t already, you will need to configure your audit trail settings to enable the Audit History for sales orders. The audit trails can be configured on very granular basis. To enable tracking, open any Sales Order and choose Tools → Audit History. If the audit history isn’t already enabled for this screen then a dialog box will appear. From there you can click OK and proceed to configure which tabs and other data elements should tracked.
The Audit History (SM205530) screen is used to search the audit history, including deleted records.
Deletion history and other changes are stored in the DAC AUAuditValues. The update data can be difficult to parse, but deletions are straightforward. You could use this DAC as the basis for a GI to see the deleted sales order records including the record id, user, and timestamp.
Hope this helps!
Laura
+8Hi
If you haven’t already, you will need to configure your audit trail settings to enable the Audit History for sales orders. The audit trails can be configured on very granular basis. To enable tracking, open any Sales Order and choose Tools → Audit History. If the audit history isn’t already enabled for this screen then a dialog box will appear. From there you can click OK and proceed to configure which tabs and other data elements should tracked.
The Audit History (SM205530) screen is used to search the audit history, including deleted records.
Deletion history and other changes are stored in the DAC AUAuditValues. The update data can be difficult to parse, but deletions are straightforward. You could use this DAC as the basis for a GI to see the deleted sales order records including the record id, user, and timestamp.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
+19Hello
Most times we cannot see deleted records after the fact.
We see hints that a delete action happened, such as skipped numbers in the Sales Order history.
If Field-Level Audit feature is enabled in Enable/Disable Features screen, and Audits have been configured for Sales Orders and Invoices screens in User Security → Audits screen before the records were deleted, then you will be able to see some details in User Security → Audit History screen.
If your Acumatica is locally hosted, you may be able to view some deleted records directly in SQL Server.
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
1 person likes this
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.