how to clear all transactions in AX?

Finance and Operations/AX Technical Forum
1

Hi, Could some one provide me a solution how i can clear all transactions from the AX 2012 system - I am using a test database, however, I need to clear all the trans so I can use this as a production. Appreciate it someone can provide a solution

there seems to be a class - but I don’t know how to execute them.

in Ax there is a class "SysDatabaseTransDelete ". Theses class deletes all transactions currently in the system.

2

From AOT we have one class “Sysdatabasetransdelete” just right click and select “Open”. Message window will open and ask you 'do you want to delete all the transaction in “Company name” click ok. It will delete all the transaction (PO, Sales Order. JOurnals, Projects etc etc onlt the master data and setup data will be there).

thanks

3

Hi Patrick,

Not all the transactions are deleted using sysdatabasetransdelete class in AX 2012 as some tables are shared.

This issue has been discussed on forum before also. Use the following link… hope it helps

http://dynamicsuser.net/forums/p/59317/317817.aspx#317817

Pranav…

4

Currently the advice based upon options would be to take a SQL backup of the base data prior to any transaction and use this as the basis of any database by restoring it.

5

How we can take the Backup (of base data) of the database without the transactions data, if the transaction data is there in the database.

Thanks

6

Thanks adam and pranav. In fact, that’s what I am going to follow - keep a master copy without any trans, and replenish that to the Test. After testing, make the corrections in the master and then push it for final testing. Sometimes, some changes made goes unknown and miss that eventually in the master copy (that’s bit time consuming). however, I agree this is the best approach (having a clean copy)

thanks a lot

7

You cannot.