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:
- Access the open the table DimensionAttributeLevelValue
- filter the record by Display Value field with the desired record to delete like customer number or employee number etc etc
- Select the filtered records
- Delete the selected records
- Then go back to customer master or where you facing the error
- 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