Post#18: Cannot Delete Fixed Asset (not yet Aquired)

I came across an odd case where I could not delete a fixed asset that was not yet acquired, so technically no financial impact.

The error displayed was:

A financial dimension value is based on the XXX record and has been used on a transaction. You cannot delete the XXX record.


Based on discussions with the technical team the following solution was advised.

Since the Fixed Asset number is referred in dimension tables, we have to do the below work around steps to delete the fixed asset master record.

  1. First find out the fixed asset recid from either the AssetTable recid field or just simply from the front end select the asset and right click the same and click on the “Record Info” option. 

  2.  Now select the “select all fields” button.

  3. Scroll all the way to the bottom right to get the recid.

  4. Open the DimensionAttributeValue table via the AOT and filter by the same fixed asset recId in entityInstance field. Please make sure the DimensionAttribute is “SystemGeneratedAttributeFixedAsset”, then  mark the checkbox on the isDeleted flag.

    Now you can open the fixed asset master and filter the record and delete it.

Happy Daxing ppl.


2 thoughts on “Post#18: Cannot Delete Fixed Asset (not yet Aquired)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s