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?
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.
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.
Thank you:)
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
Already removed. But I was mentioning the hierarchy of the past log.
try to remove hierarchy -
No.
I am only suspend of the standard organization hierarchy. While there were non active hierarchies, may it not be possible to delete?
Is there any custom table related to this and has relations?
That is the case actually.
I did this but still the button is greyed out.
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.
#1
André Arnaud de Cal...
292,935
Super User 2025 Season 1
#2
Martin Dráb
231,801
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
