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

Hey ​@ydasari ,

Have you checked out the following?

https://www.youtube.com/watch?v=FhoHPt5g2bU

Hope this helps!!

Hi ​@ydasari,

Please have a look at below post and replies for some suggestions.

Is it safe to clean "Auidit history" and how? | Community

Hi ​@ydasari,

There is no separate logging for Financial and CRM audit logs in Acumatica; both are stored in the same AuditHistory table.

Although separate logging is not available by default, we can implement a controlled cleanup mechanism(Customization) if the client needs to delete audit history data older than 7 years(CRM & Financial both). This can be done by creating a custom processing screen that allows records to be purged based on a selected date range.

However, the initial cleanup of approximately 387 GB is a very large operation. Performing the first purge entirely through the application layer will be time-consuming and may take several days due to the volume of data and system performance considerations.

Recommendation: For the initial bulk cleanup, it is advisable for the DBA to execute a direct SQL script (for On-Premise or Private Cloud environments) to remove the majority of historical records. Alternatively, the data can be deleted in periodic, chunk-wise batches using the custom processing screen to minimize system load and avoid performance issues.

Hi ​@ydasari,

There is no inbuild feature to purge Audit history. It looks like Acumatica is currently gathering requirements for this Product Ideas. You can add your business scenario their, which will help them in gathering more information for implementation of the product.

However, if this your top priority (may be because of DB size grown exponentially), I would suggest you create a custom processing screen to delete Audit History in batches. Processing screen can always be run on schedule so that way you can plan to run it during off business hours.

Hope this helps!