To Delete a company

(1) Share

Report

Posted on by BillurSamdancioglu

19,856 Most Valuable Professional

Hi,

Trying to delete a company in Microsoft AX 2012 R3.

Deleted all the transactions via trans delete but delete button is still inactive.

It was assigned to hierarchies but I had deleted from those. and activated the hierarchies.

Still delete button is inactive.

Is there a way to delete the company?

I have the same question (0)

All responses (10)

Answers (1)

kbendrikar 65 on at

Like (0)

Report

Try to Go to AOT -

Run the Class "SysDatabaseTransDelete" this will delete all the transactions..(make sure if this really wanted )

When all the transactions are deleted go back and try again.

Was this reply helpful? Yes No
BillurSamdancioglu 19,856 Most Valuable Professional on at

Like (1)

Report

That is the case actually.

I did this but still the button is greyed out.

Was this reply helpful? Yes No
kbendrikar 65 on at

Like (0)

Report

Is there any custom table related to this and has relations?

Was this reply helpful? Yes No
BillurSamdancioglu 19,856 Most Valuable Professional on at

Like (1)

Report

No.

I am only suspend of the standard organization hierarchy. While there were non active hierarchies, may it not be possible to delete?

Was this reply helpful? Yes No
kbendrikar 65 on at

Like (0)

Report

try to remove hierarchy -

Was this reply helpful? Yes No
BillurSamdancioglu 19,856 Most Valuable Professional on at

Like (1)

Report

Already removed. But I was mentioning the hierarchy of the past log.

Was this reply helpful? Yes No
Verified answer

kbendrikar 65 on at

Like (2)

Report

Try to delete these records - the delete button will be enabled

delete from OMHierarchyRelationship where ChildOrganization == companyInfo.RecId

delete from OMHierarchyRelationship where ParentOrganization == companyInfo.RecId

delete from OMRevisionEdit where ParentOrganization == companyInfo.RecId

delete from OMRevisionEdit where ChildOrganization == companyInfo.RecId

Was this reply helpful? Yes No
BillurSamdancioglu 19,856 Most Valuable Professional on at

Like (1)

Report

Thank you:)

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (1)

Report

Hi Billur,

You got your solution already. The organization hierarchies are based on date effective tables. When you delete a legal entity from the hierarchy, it will actually set an end date instead of deleting the records in the table OMHierarchyRelationship. For that reason, the solution provided by Kiran was your answer.

Was this reply helpful? Yes No
BillurSamdancioglu 19,856 Most Valuable Professional on at

Like (1)

Report

Thanks André,

The problem is even we removed from the hierarchy, delete button was inactive. So we deleted past records from the table and now the button is active.

Was this reply helpful? Yes No