Announcements
No record found.
Hello everyone,
Recently, I encounter Error message: Results. update not allowed for field 'RetailVendTable,AccountNum' when I import new Vendor or update Vendor information in entity Vendors V2 by Data Management or with Excel Data Connector. I googled and there're some posts that said changing Account Number field into an editable field (Allow Edit == Yes). I don't think this is a good idea, because Account number is a key field, it can't be turned to editable field.
So could you suggest a better approach to this error?
Thank you in advance.
Regards,
Magnolia
AccountNum is the primary key of the VendTable so you can't update it using the data entity. Do you want to change the AccountNum for vendors? The you will have to use renamePrimaryKey method on the table from code to do that.
MS documentation
Source: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/system-tables
I don't update Account Number, I only update other information. Besides it also happens with import creating new vendors. That error is like random error, not the real error.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 545 Super User 2026 Season 1
Giorgio Bonacorsi 408
Adis 267 Super User 2026 Season 1