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.