Skip to main content

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!

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.

 

Ah that makes sense. Thanks @Naveen B!

Most Welcome @damonb56  :)

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