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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Importing of Vendors t...
Finance forum

Importing of Vendors to update certain fields

(0) ShareShare
ReportReport
Posted on by Shaun Hawkshaw 977

Hi there,

If I reimport vendors to change specific fields I get the following error:
Results. update not allowed for field 'Party ID(VendorPartyNumber)'

How do i import over a vendor (the import is done with entity Vendors V2).

I could possibly do it with excel but please try advise on the data management route.

Thank you!

Categories:
Data Integration
I have the same question (0)
  • Verified answer
    Eugen Glasow Profile Picture
    Eugen Glasow 6,359 on at

    Remove the stuff from the file you don't need, leave only VENDORACCOUNTNUMBER and the field(s) you are updating. Recreate your mapping with this reduced file. This is even much faster this way.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

    Hi Shaun,

    Was the PartyId field provided with a value in your source file? If so, an update would trigger table validations. One validation is that you cannot change the PartyID manually. Then like Eugen mentioned, remove the columns which were not touched for the fields to be updated.

  • Phyllis Pang Profile Picture
    Phyllis Pang 44 on at

    Hi, 

    i'm facing the same problem : I need to update Vendor address and payment terms in batch

    so, i using the data management to import the vendor again with SAME vendor "ACCOUNTNUMBER",

    and only left the "Address" and "Payment terms" columns in the excel

    but when import, system prompt error as below :

    Results. Field 'Vendor account' does not allow editing.
    Results. Invalid specification of Vendor account
    Results. Number sequence BG_VEN02 does not allow change to a lower number.
    Results. Validations failed while writing entity record

    Please advise how to solve this issue, and how can I update the address and other fields in vendor master in batch through data management ?  thanks 

  • phyllispang Profile Picture
    phyllispang 283 on at

    HI, 

    i'm facing the same issue : want to update the vendor file with Address and payment terms information only

    when import the vendor file through Data management (Vendors V2 data entity) - only leave the vendor ACCOUNTNUMBER, and columns of "Address" and "Payment terms",

    but system still prompt error as follow:

    Results. Field 'Vendor account' does not allow editing.
    Results. Invalid specification of Vendor account
    Results. Number sequence BG_VEN02 does not allow change to a lower number.
    Results. Validations failed while writing entity record

    Please advise how to solve this issue ?

    How can I update the vendor address and payment terms information in batch through excel file ?  Many thanks 

    Phyllis

  • Suggested answer
    Eugen Glasow Profile Picture
    Eugen Glasow 6,359 on at

    This is a known behaviour. You have to turn off the parameter Call validate field method in the entity:

    Overwrite a read-only configuration in D365FO - ER-Consult (erconsult.eu)

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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans