Hi,
I have changed the description. I want to know where the previous value is store.
OldValue = ‘RMA-3693 - General Returns’
NewValue = ‘RMA-3693 - General Returns- AAA’
It’s a record from ScreenID = ‘SO301000’
Answer
Audit History in Database
Best answer by meganfriesen37
Have you checked out the information on the Field Level Auditing capabilities here: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=5732218e-d1ad-4d3b-b6c3-47ed62d23a87
Typically this needs to be turned on in advance to start storing this information and it needs to be turned on screen by screen for certain items, as it will consume additional storage space.
+12Have you checked out the information on the Field Level Auditing capabilities here: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=5732218e-d1ad-4d3b-b6c3-47ed62d23a87
Typically this needs to be turned on in advance to start storing this information and it needs to be turned on screen by screen for certain items, as it will consume additional storage space.
Megan Friesen, Contego Software Solutions, Canada
Field level audit in Acumatica is wonderful. We probably have it turned on for too many tables currently.
On our old ERP I used to teach a class on the field level audit capability. And my first rule for students was that, if you’re going to turn on Audit, your first step is to plan how and when you’re going to purge that audit data. Acumatica doesn’t offer a built in purge function unfortunately, but there are ISVs that have good tools for it. We subscribe to Acupower’s Acupurge product for this. We’ve documented each table we’ve turned on field level audit for (Acupurge actually helps with this if it’s gotten away from you) and how long we keep the data. Then it’s just a series of jobs (we run it once a month) to purge anything outside of those thresholds.
(I don’t have any connection to Acupower, I just like the product...but I do think this should be standard functionality.)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.