Skip to main content
Solved

Can you report on the changes tracked in Audit History?

  • February 11, 2025
  • 3 replies
  • 57 views
J
Semi-Pro II
Forum|alt.badge.img
  • jzhu
  • Semi-Pro II
  • 124 replies

Hi! I am trying to create a generic inquiry that would show the changes of a specific field, where on the GI a column shows what it was before, and what it is after the change.

This field is enabled for audits. I checked both AuditHistory and AUAuditValues DAC, both data source contains information like change date or what field was modified, but it does not actually show the old and new value of the field.

Are the changes in audit history reportable? If so, what DAC should I be looking at that would show the actual value changed?

Thanks!

Best answer by jzhu

Update on this: I am hard coding the modified field column to pull the description of the attribute instead of its value ID. Example: = IIF( InStr([AuditHistory.ModifiedFields], 'AttributeDISPOSTNNA') > 0, 'No Answer', [AuditHistory.ModifiedFields])

If the field contains the attribute value ID, then show the description of that value.

View original
Did this topic help you find an answer to your question?

3 replies

M
Acumatica Employee
Forum|alt.badge.img

Hi ​@jzhu 

Have you tried using the ModifiedFields data field from the AuditHistory DAC?

It will need to be cleaned up a bit, but this data field mentions the changes that were made.

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
J
Semi-Pro II
Forum|alt.badge.img
  • jzhu
  • Author
  • Semi-Pro II
  • 124 replies
  • February 11, 2025

Hi ​@MinushaWeerasuriya76 Because this is an attribute field, the ModifiedFields is showing the value ID instead of the description that is displayed in the field. Is there a way to change that? 

 

 

J
Semi-Pro II
Forum|alt.badge.img
  • jzhu
  • Author
  • Semi-Pro II
  • 124 replies
  • Answer
  • February 14, 2025

Update on this: I am hard coding the modified field column to pull the description of the attribute instead of its value ID. Example: = IIF( InStr([AuditHistory.ModifiedFields], 'AttributeDISPOSTNNA') > 0, 'No Answer', [AuditHistory.ModifiedFields])

If the field contains the attribute value ID, then show the description of that value.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved