thanks
ilyas
*This post is locked for comments
Dynamics AX 2012. There will be multiple entries in these tables for a single ledger dimension. Let me explain a hierarchy of these tables here: It start with LedgerDimension field on the table that has a relation to
DimensionAttributeValueCombination -> DimensionAttributeValueGroupCombination -> DimensionAttributeLevelValue->DimensionAttributeVaue->DimensionAttribute tables. You can take a look at view "DimensionAttributeLevelValueAllView" for detail.
Now the problem is if there is any reference data in any of the tables the record cannot be deleted. The problem with the approach of how LedgerDimension stores that data is that the data in those tables will not be deleted (for reusability) even you delete the transaction or change the ledger dimension on the transaction so once you use the dimension it will always stay there in the tables.
The solution will be to make a utility that deletes all the record in those tables that don't have any reference in any other tables. This solution will not harm any of the existing data and when user select the same combination of ledger dimension (that you have deleted) the framework will once again populate the data in these tables.
Hi Ilyas,
There are some Dimension...Value tables which can have a reference to this main account. This is also seen as transaction. If the records are created in these tables, then the account was actually used in and probably directly deleted from a general journal or posting setup. It would be possible to find the records in these tables and delete these references. Then deleting would be possible. Try it in a separate environment first. Then also test all other scenarios if nothing is broken.
Another option might be suspending this account and rename it to another account in future when there is a need for a new main account.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
Martin Dráb 2 Most Valuable Professional
Guy Terry 2 Moderator
