web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Results. update not al...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Results. update not allowed for field 'RetailVendTable,AccountNum'

(1) ShareShare
ReportReport
Posted on by Magnolia Stellata 7

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

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 238,322 Most Valuable Professional on at
    72camaross, the message doesn't look the same to me. This thread is about update not allowed for field 'RetailVendTable,AccountNum', but I see no remark of VendRetailTable in your error message. It could be a problem with VendorAccountNumber field of the entity.
     
    Why do you think it's about RetailVendTable?
  • 72camaross Profile Picture
    72camaross 320 on at
    Follow up, I simplified everything

    Opened the vendors in Excel
    - only updated 13 of 2000 vendors by changing the 'reports 1099' to yes.
     
    Failed with this error:
    A row update in data set VendorsV2 was not published. Error message: 'Write validation failed for table row of type 'VendVendorV2Entity'. Infolog: Warning: Field 'Vendor account' does not allow editing.; Warning: Invalid specification of Vendor account; Warning: Number sequence APVENDORS does not allow change to a lower number..'
  • 72camaross Profile Picture
    72camaross 320 on at
    Did you ever find a solution?
     
    I am trying to update a couple of columns on vendors using Data Management and getting the exact same error. I'm not changing the vendor number or the groups or anything. Just the 1099 fields.
     
    Gives me the error even though I export the file, update my columns and re-import. The numbers are identical.
  • Community member Profile Picture
    Community member 2 on at
    Are you resolved ? I also met this error
  • Magnolia Stellata Profile Picture
    Magnolia Stellata 7 on at

    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.

  • Suggested answer
    Anton Venter Profile Picture
    Anton Venter 20,421 Super User 2025 Season 2 on at

    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

    renamePrimaryKey  Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table.

    Source: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/system-tables

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.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 503 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 288 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans