Code Snippets · Functional Understanding

Delete All Transactions in a Company

Today i got a requirement from my Functional team to delete only the posted transactions, not the configurations and master data as he has to test some scenarios.

To Achieve this i found a class in AOT named as “SysDatabaseTransDelete” .On further drilling i figure out that this class is checking the table types differently for global and company specific .



To run, Simply go to AOT (CTRL + D) -> Classes ->  SysDatabaseTransDelete ->right click on class and select Open -> Click Yes to delete all the transactions on the current company .


Note : Make Sure you have selected the right company, there is No return point. it is better to take the backup before performing this step.





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s