A financial dimension value is based on the ” record and has been used on a transaction. You cannot delete the ” record – Dynamics 365 for finance and operations – AX2012 R3

Scenario:

Sometime user trying to delete a record from the customer master or any data that relates to financial dimension. So, user is facing above error upon deletion.

Reason:

Error occurred because data exists in the table DimensionAttributeLevelValue

Solution:

1. Access the open the table DimensionAttributeLevelValue 
2. filter the record by Display Value field with the desired record to delete like customer number or employee number etc etc
3. Select the filtered records
4. Delete the selected records
5. Then go back to customer master or where you facing the error
6. Now try to delete you will be able to delete

 

AX 2012: you can directly delete the record by opening table

D365 : you can delete by access the SQL or write the runnable class to delete