Skip to main content
Answer

Can you report on the changes tracked in Audit History?

  • February 11, 2025
  • 3 replies
  • 152 views
J
Semi-Pro III
Forum|alt.badge.img

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.

3 replies

M
Acumatica Employee
Forum|alt.badge.img+1

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
J
Semi-Pro III
Forum|alt.badge.img
  • jzhu
  • Author
  • Semi-Pro III
  • 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 III
Forum|alt.badge.img
  • jzhu
  • Author
  • Semi-Pro III
  • 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.

Terms & ConditionsCookie settingsAccessibility statement
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