最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Deleting a customer with no transaction generates error message, and customer can not be deleted

Uncategorized William 9104浏览 0评论

Solution 1710335

Deleting a customer with no transaction generates error message, and customer can not be deleted

Product and version
Microsoft Dynamics AX 2012 R2
PROBLEM
When user tries to delete the customer which has no transaction system throws an error “A financial dimension value is based on the ###### record and has been used on a transaction. You cannot delete the ###### record”
Snap1
MITIGATION
Below is an example as to the deletion of fixed assets, similarly one can use this workaround for vendor, bank accounts and main accounts.
There is the workaround which is to delete the associated DimensionAttributeLevelValue (DALV) record and then the user should be able to delete the account. This can be done following the below steps:

1. On Dynamics AX Developer Workspace, go to AOT > Data Dictionary > Tables. Go to table DimensionAttributeLevelValue. Right click on this table and click Open.
2. On Display Value field, CTRL+F and put the Display Value of the account which needs to be deleted. In this example it is 112233:
3. Click OK. The system should select a record with the account information the user needs to delete. Take note (copy) of the value in field dimensionAttributeValue.
4. With this number, go to AOT > Data Dictionary > Tables. Go to table DimensionAttributeValue. Right click on this table and click Open.
5. Now, on field RecID, CTRL+F and paste the number extracted on step 3.
6. On this line, expand the fields and find one specifically named IsDeleted. Mark it.
7. Now go to Fixed Asset, find the account to delete and delete it.

The system WILL NOT show the error anymore.

The reason for deleting the record in the backend is as explained below:

1. Any time a relationship is tied to the existing record AX keeps an audit trail in the DALV table. So for auditing purposes AX creates the record and if there is an audit trail AX will not allow you to remove the record from the front end. If there is no need for the record, one can manually remove the audit trail by removing the DALV record and continue with the normal work.
2. The main design choice here with the DAVL record is for performance issues. With the creation of the DAVL record there is a linking record which AX did not have in previous versions so the system can simply scan for a record rather than go through code to find it’s linking accounts, Account Structure, or any other linking points.
This is actually working by design, and it is not desirable to have end users removing records with a DALV association.

The development team has been informed about this suggestion for future versions at the following link.
http://connect.microsoft.com/dynamicssuggestions/feedback/details/741926/unable-to-delete-main-account-customer-vendor-bank-if-it-was-once-saved-in-journal-line-in-ax-2012

转载请注明:ww12345678 的部落格 | AX Helper » Deleting a customer with no transaction generates error message, and customer can not be deleted

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址