AuditHistory Cleanup – Is it possible to separate Financial vs CRM audit logs?

Hi Community,

We are working with a customer where the AuditHistory table has grown significantly (currently around 387 GB), and we are evaluating cleanup and retention options.

Background:

• The client wants to reduce database size and improve manageability.

• Similar cleanup work was performed several years ago for this same customer.

Client Requirements:

1. Separate Financial audit logs from CRM audit logs.

2. Remove all CRM audit logs.

3. Retain only the last 7 years of Financial audit logs.

Information received from Acumatica Support:

• Financial and CRM audit logs are stored together in the same AuditHistory table.

• There are no built-in retention settings for specific audit log types.
  
   

  

   

Questions:

• Has anyone implemented a workaround or customization to separate Financial vs CRM audit logs?

• Any best practices for managing large AuditHistory tables in similar scenarios?

Any insights or recommendations would be greatly appreciated.

Thanks in advance!