Skip to main content
Solved

Field Level Audit configuration


I’m looking for clarification on how to configure Field Level Auditing. How do you know which Tables and Fields to select on the Audit screen?

 

Example:

I wanted to audit changes to the SALESPERSONS tab of the Customers screen, which corresponds to the “CustSalesPeople” table.

 

I tried to set up field level auditing by selecting the relevant Table and Fields on the Audit screen, as advised in the wiki. I only wanted to track changes to the Customer Salespersons table, so I only selected that Table. However, none of my changes were tracked with this config.

 

Through some trial and error, I was able to get the audit working by also selecting the BACCOUNT and CUSTOMER tables.


Can anyone explain why I needed to select these additional tables? Understanding this would make setting up auditing much simpler in the future.

 

Thanks!

Best answer by Naveen Boga

HI @damonb56  Here is my understanding, hope this helps!.

Yes, in the Audit screen without parent table selection and if you wanted to see the child table info system will not audit the details.

 For the customer screen, BAccount and Customer tables are Header level tables where system will save the Customer Info related Key fields in it and other tables will have the info by having BAccount ID reference.

When we click on the Audit History, system will look for the header level tables from there by having a reference it will pull the  other table information.

 

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

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • January 14, 2022

HI @damonb56  Here is my understanding, hope this helps!.

Yes, in the Audit screen without parent table selection and if you wanted to see the child table info system will not audit the details.

 For the customer screen, BAccount and Customer tables are Header level tables where system will save the Customer Info related Key fields in it and other tables will have the info by having BAccount ID reference.

When we click on the Audit History, system will look for the header level tables from there by having a reference it will pull the  other table information.

 


  • Author
  • Freshman II
  • 5 replies
  • January 17, 2022

Ah that makes sense. Thanks @Naveen B!


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • January 17, 2022

Most Welcome @damonb56  :)


Reply


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