Solved

GI Data Audit

  • 10 July 2023
  • 1 reply
  • 80 views
M

I’m working on a GI to display the following information for future audits. Basically, the auditor wants to see a list of field changes on vendors within a given time frame. They want to pick one of the changes and have the team pull the necessary approval paperwork for that change. I’m currently using PX.SM.AuditHistory and PX.SM.Users. Here are the needed fields:

Operation
ChangeDate
Username
TableName
ModifiedFields
ScreenID
ChangeID
Old value
New value

I was able to get the fields listed except for the old field value and the new/updated field values. Doing some research, I think that this information is stored separately, but wanted to ask the community first. Is that “change” information stored separately?

icon

Best answer by Laura02 24 July 2023, 11:53

View original

1 reply

Laura02
Rank
Badge +18

Hello @mjesse ,

How to see the data before/after values for Field-level audit in screens where Audits are turned on. Post answered by Benjamin C. of Acumatica:

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~

Reply


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