Is it possible to Delete Audit History?

​@Jupiter Hi You need to delete the audit history either from UI And DB,

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

Hi ​@Jupiter 

There is No native purge by date; logs are tenant‑specific. in cloud you’ll need either an approved customization (e.g., AcuPurge like mention above) or vendor/DBA involvement direct DB access is generally not available to end customers.
Visit Link.

​@mohammadnawaz51 , ​@Abhishek Niikam thanks for a quick response.  I also found AcuPower, is there any preference between the two?  And are these paid subscription or how does it works?  You can tell I am in learning stages here because we got told by MYOB official support that is something we can manage ourself which I am finding is not true.

Hi ​@Jupiter,

The same idea has already been submitted in the Ideas section of the Acumatica Community. You can vote for it to help increase its visibility and priority.

If you have any other use cases or scenarios where this functionality would be beneficial, please add them to the idea.

https://community.acumatica.com/ideas/audit%2Dhistory%2Dpurge%2Dwith%2Dability%2Dto%2Dschedule%2D22853

​@Jupiter You can work with ACUPOWER or work with the developer to truncate the data.

Thanks ​@Dipak Nilkanth , I can’t open that link it show 403.  Whom can I ask for access?

We have a full team of developers, is this something we can develop ourself without any further access from MYOB?  FYI - We already have customisation in our setup which is not accessible to us, only MYOB support has access to the code.

​@Chris Hackett, can you please help ​@Jupiter on this?

Hi ​@Dipak Nilkanth - I responded to ​@Jupiter in PM that they are in the community as a registered guest. That role doesn’t have the access rights needed. Acumatica Portal controls that access through what’s entered in their business account in Acumatica CRM. They would need to work with the account administrator to get the proper user role access setup there.

​@Chris Hackett I check with our account manager and they say the ’Guest’ access should be fine to access that URL.  Can I confirm that URL actually is working and if you can share a screenshot?

No need to pay anyone. Create a customization to attach an SQL audit record delete script. Use AI if you don't know how to write the script.

​@Jupiter  - The link you are referencing goes to an Idea. Ideas, KBs, and other areas are only open to the customer or partner role, not guest. Yes, the link works fine.

Thank you Naveen for the direction here, is there any guides written on this that I can refer too.

Hi ​@Jupiter , there isn't one single official Acumatica guide for this specific use case since audit purging isn't a native feature, but here's the general approach:

1. Look at Acumatica's "Customization Projects" framework and the "Automation Steps" / Business Events documentation in the Acumatica Open University these show how to trigger custom code (including SQL) on a schedule.
2. You can create an Automation Schedule that calls a custom Business Logic (BLC) method, and inside that method execute a parameterized SQL DELETE against the audit history table filtered by date, using PXDatabase.Execute or a stored procedure call rather than raw ad-hoc SQL.
3. Always test in a sandbox/snapshot copy first, take a full backup before running any delete, and keep the date-range filter conservative audit tables can have foreign key relationships depending on your version.
4. If your dev team isn't familiar with Acumatica's customization APIs, Acumatica's "Customization and Development" training on Acumatica Open University (openu.acumatica.com) is the best starting point.

Hi,

I just responded to your request. If you are still running into issues, feel free to send me your specific requirements. I would be happy to put together a sample script and send it over to you.

Best regards,
Naveen