90
Hi everyone,
I'm testing for importing vendor master by data management in D365FO. I've met an issue as below:
Results. update not allowed for field 'RetailVendTable,AccountNum'
I use the entity Vendors V2 to import and number sequences of Vendor account is Manual.
Kindly help me if you've any idea. Thank you!
Hi, It´s your environment Cloud or OnPremise ?
If OnPremise Open SSMS --> Execute Query --> SELECT * FROM RetailVendTable WHERE AccountNum = ''"
If Result Is Blank then DELETE FROM RetailVendTable WHERE AccountNum = ''"
After that Go to Dynamics and import
If Cloud, you need create a Job And run on Dynamics (I recommend run it in Dynamics as Custom scripts) https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/deployment/run-custom-scripts
Hope the above can help you.
regards,
Hernan L
Hi Hernan Londono,
Thanks for your answer. I've checked and can see the blank record in my environment too. But can i ask if you know find out the reason? Why we have the blank record in that table?
And could you guide me how to delete the blank record in the RetailVendTable table?
Can i delete directly in the environment by myself or i need to ask technical guy to do that? Thanks again!
Yesterday I was presented with that situation and I found that the problem was due to a blank record in the RetailVendTable table. I proceeded to delete the blank record and perform the import successfully
Thanks for your suggestion. But i checked my file and it didn't have any value in the VENDORPARTYNUMBER field. I also use the auto-generated with this field when mapping but it didn't work. Now i try with the vendors V3 and it's succeeded.
Yes I also check for the Dev environment but it has the same result. By the way, i try to import with the Vendors V3 entities and it work now. Thank you!
Hello huongpm,
Is the column VENDORPARTYNUMBER in your import-file filled? And can it be that it is filled with values from another environment?
If you want to create new Vendors and (thus) Parties, that column should be empty.
Hope this helps!
Hi huongpm,
As per my knowledge, the data entity you are using is not having any reference to the RetailVendTable table. Can you check if you have an extension in your environment which is causing this behavior?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (