We have over 100k assets that are yet to be acquired (no posted transaction). yet they can not be deleted because they have dimension values of same asset and journal was raised, having the financial dimension updated on the journal line along side the fixed assets. The user eventually deleted the journal because it was not needed. The user is unable to delete it because the system is referencing a certain DimensionAtributeValue table.

This does not make sense to the users.

My suggestion is that as soon as the assets is being deleted, having a status of not yet acquired, the system delete the record sitting on the dimensionattributevalue table associated with the asset.