Notifications
Announcements
No record found.
I am attempting to delete a Vendor without transactions, invoices, PO, nor PR. Nothing. The only artifact on the record is a bank account. I am told by Microsoft by having added the bank account, it has recorded it as a System Financial Dimension record. Now that I have deleted the Bank Account I still cannot delete the record. Following a Trace File, I found in the DIMENSIONATTRIBUTEVALUE table an evidence of for the vendor still there, called a SystemGeneratedAttributeVendor. Has anyone experienced this inability to delete a vendor w/o transactions? Any idea how to correct it so I can delete it?
Solution:
I found this online:
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.
connect.microsoft.com/.../unable-to-delete-main-account-customer-vendor-bank-if-it-was-once-saved-in-journal-line-in-ax-2012
***EDITED BY ADMIN***
The solution is to ##############################################################. Once completed, I was able to delete the vendor
****Caution do not hack around dimension data as it will break your system and require a ticket to fix.
Hello OceanFish26,
What you haves commented is correct. Once the record is written to the DimensionAttributeValueCombination table you will not be able to delete the Vendor records.
The suggestion is to update the Name to Do Not Use until a new Vendor record needs to be created and then update the information as needed to reflect the new Vendor.
Have a great day!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 565 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
