Delete All the Transactions in a Company by keeping the Master Data intact Dynamics AX

Sometimes, you may have a requirement to delete all the transactions in a company while keeping the Master data as it is.
In order to achieve this you can duplicate the company and run SysDatabaseTransDelete class, which will delete all the transactions in the related company while keep the master data intact.

1. Press Ctrl + D.
2. Open Class node in AOT.
3. Find SysDatabaseTransDelete class, right click open, it will show the related company from which you want to delete the transactions.

transactions

Note : Before performing the above steps on production please do it in test so you can come to know what exactly you achieve.

About the author

: Taimoor is a senior software engineer in Systems Limited. He has a vast experience working with Dynamics AX2012R2, AX2009 and AX4.0. He does things like AX development and customization, client support, upgrading, integration, installation and configuration, debugging and performance enhancement. He is also experienced in working with different clients based in different regions. Other than this, he likes to play and watch cricket and hang out.