Skip to main content

Notifications

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 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:
  • Suggested answer
    Eugen Glasow Profile Picture
    6,357 on at
    RE: Importing of Vendors to update certain fields

    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)

  • phyllispang Profile Picture
    283 on at
    RE: Importing of Vendors to update certain fields

    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

  • Phyllis Pang Profile Picture
    42 on at
    RE: Importing of Vendors to update certain fields

    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 

  • Verified answer
    André Arnaud de Calavon Profile Picture
    293,998 Super User 2025 Season 1 on at
    RE: Importing of Vendors to update certain fields

    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.

  • Verified answer
    Eugen Glasow Profile Picture
    6,357 on at
    RE: Importing of Vendors to update certain fields

    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.

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,998 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,850 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans