To Delete a company

(1) Share

Report

Posted on by BillurSamdancioglu

20,825 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)

Sort by

kbendrikar 65 on at

Like (0)

Report
Copy link

Link copied!

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 20,825 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No
BillurSamdancioglu 20,825 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

try to remove hierarchy -

Was this reply helpful? Yes No
BillurSamdancioglu 20,825 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 20,825 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Thank you:)

Was this reply helpful? Yes No
André Arnaud de Cal... 304,900 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 20,825 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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