Announcements
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!
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)
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
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
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.
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.
André Arnaud de Cal...
293,998
Super User 2025 Season 1
Martin Dráb
232,850
Most Valuable Professional
nmaenpaa
101,158
Moderator