Finance | Project Operations, Human Resources, ...

Errorr when Import vendor by data management

(0) Share

Report

Posted on by Huong Pham

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!

I have the same question (0)

All responses (8)

Answers (0)

André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
N Merkx 8 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
JPJooste 10 on at

Like (0)

Report

Hi huongpm

Where you able to identity the cause and find a solution to this error?

Regards

Was this reply helpful? Yes No
Huong Pham 90 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Huong Pham 90 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Hernan Londono 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Huong Pham 90 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Hernan Londono 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No