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.
- 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.
- Now select the “select all fields” button.
- Scroll all the way to the bottom right to get the recid.
- 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.