Skip to main content

Delete legal entities in AX 2012

Delete a legal entity seems to be a straight forward option in AX, just click on delete button on legal entity form. This does not work sometimes as per your thoughts and you face errors like below.

Cannot delete a record in Ledger (Ledger).
The corresponding AOS validation failed.
Stack trace: Call to TTSCOMMIT without first calling TTSBEGIN.
Stack trace
(S)\Classes\xRecord\Delete
(S)\Data Dictionary\Tables\DirPartyTable\Methods\Delete - line 14
(S)\Data Dictionary\Tables\DirOrganizationBase\Methods\Delete - line 17
(S)\Data Dictionary\Tables\CompanyInfo\Methods\Delete - line 31
(S)\Classes\xRecord\dbOpInTransaction
(C)\Classes\FormDataSource\delete
(C)\Classes\FormRun\task
(C)\Forms\OMLegalEntity\Methods\task
(C)\Classes\SysSetupFormRun\task

OR

Cannot delete a record in Batch job (BatchJob). The corresponding AOS validation failed.

These errors appear when you have transaction data in the legal entity which you are after for delete or there are batch jobs in running state stopping this delete process. 

There are certain steps to get rid of these errors and also to have a smooth delete process without any issue.
  1. Select the company (legal entity) which you need to delete.
  2. Go to AOT (Press Ctrl + D) and find class "SysDatabaseTransDelete" to delete transactions first.
  3. Run class "SysDatabaseTransDelete", it will prompt you Yes/No option to delete transactions. Delete them first it will take a while depend on the transaction data you have in your system in this company.
  4. Open legal entity form from Organization Administration | Setup | Organization | legal entities. 
  5. Select legal entity for which you deleted transaction data in step 1 and click delete button. It will take a while.
Labels:

Comments

  1. Umesh PanditJuly 3, 2015 at 1:49 PM

    good inputs

    ReplyDelete
  2. UnknownOctober 10, 2015 at 12:27 AM

    have tried to delete the transactions even though we did not have any and am still getting the following error:
    Cannot delete batch job in the executing or cancelling state
    Cannot delete a record in Batch job (BatchJob).
    The corresponding AOS validation failed.
    do you have any other ideas please?

    ReplyDelete
  3. Faisal FareedOctober 10, 2015 at 1:09 AM

    Hi Gene, Please change the status of all batch jobs to waiting and then try to delete legal entity.

    ReplyDelete
  4. imranJanuary 12, 2016 at 12:40 AM

    Hi Faisal

    I have created the new legal entity and want to delete the legal entity, this delete option is disable and not only for this company, for all the companies except DAT, there is no transaction at all in this company. How i can delete the legal entity or enable the delete button.

    ReplyDelete
  5. UnknownMay 17, 2016 at 4:14 PM

    Imran, if the entity belongs to any organisation hierarchy the button will be disabled.

    ReplyDelete
  6. AxAugust 27, 2020 at 6:06 PM

    This comment has been removed by the author.

    ReplyDelete
  7. AxAugust 27, 2020 at 6:08 PM

    Hi Faisal, if we run the class SysDatabaseTransDelete so this will delete Master data, setups like module parameters and transaction data even if posted? or it will delete only Transaction data and masters will remain. Kindly advise.

    ReplyDelete

Post a Comment

I will appreciate your comments !

Popular posts from this blog

The Dual Write implementation - Part 1 - Understand and Setup

What is Dual-write? Tightly couples – complete at one transaction level Near real time Bi-directional Master data and business documents – Customer records you are creating and modifying and at this document we are talking about sales orders or quotes and invoice. Master data could be reference data e.g. customer groups and tax information Why Dual-write and why not Data Integrator? Data Integrator is Manual or Scheduled One directional Now, Let's deep dive and understand what is required for Dual-write setup and from where to start. First thing first, check you have access to https://make.powerapps.com/ Choose right environment of CDS (CE) Make sure you have access to the environment too, click on gear icon and Admin Center  Look for required environment and Open it, you must have access as going forward you are going to configure dual write steps in the environment user the same user you are logged in now. Now, go back to power platform admin center and
54 comments
Read more

D365FO: Entity cannot be deleted while dependent Entities for a processing group exist. Delete dependent Entities for a processing group and try again.

Scenario: There are times when you want to delete an entity from target entity list and when you do so, you face an error message which does not tell you where exactly the entity has been used.  "Entity cannot be deleted while dependent Entities for the processing group exist. Delete dependent Entities for a processing group and try again. " Solution: Browse the environment by appending this part  /?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntity&cmp=USMF   at the end.  For example; if the environment URL is  https://daxture.sandbox.operations.dynamics.com then the complete URL will be https://daxture.sandbox.operations.dynamics.com/?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntity&cmp=USMF Filter for Entity and it will give you the DefinitionGroup where the entity has been added or used in data management import/export projects. Get the DefinitionGroup name and search in the export/import projects under data management and either delete the whole
4 comments
Read more

Dual-write connection set error: An item with the same key has already been added

If you happen to see this error message then you have duplicate records in cdm_company entity in CDS environment. Check for cdm_companycode field this is normally not allowed but have a look and delete the ones with duplicates.
1 comment
Read more