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 .

TableHandling

 

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 .

1

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.

 

 

 

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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