Wednesday 17 April 2013

Delete ALL the transactional data in a company

It is interesting that there are times when we keep a TEST company even in production environments. This is a useful procedure but with ever increasing test transactions, the size of database becomes increasingly bigger. There is an in built class 'SysDatabaseTransDelete'. Just follow the steps below to actually delete all the company related transactions in the database.

  1. In the AOT expand Classes node
  2. Find the class 'SysDatabaseTransDelete' .
  3. There is a Main method defined for this class so when you right click and select Open, a message box will appear to ask confirmation. Select Yes.
  4. Depending on the volume of data, an info box will appear once the transactions are deleted.


Note: This only deletes the transactions related to the company selected under AOT. 

Thursday 4 April 2013

Labels in Version Control Environment | Dynamics AX 2012

In general understanding, label files are generally kept identical within a same layer but in reality they can contain different values even within the same layer. Came across a useful article to understand how label files behave when a version control mechanism is on. This can be read here.