Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Errorr when Import vendor by data management

(0) ShareShare
ReportReport
Posted on by 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!

  • Suggested answer
    Hernan Londono Profile Picture
    Hernan Londono 10 on at
    RE: Errorr when Import vendor by data management

    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

  • Huong Pham Profile Picture
    Huong Pham 90 on at
    RE: Errorr when Import vendor by data management

    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!

  • Suggested answer
    Hernan Londono Profile Picture
    Hernan Londono 10 on at
    RE: Errorr when Import vendor by data management

    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

  • Huong Pham Profile Picture
    Huong Pham 90 on at
    RE: Errorr when Import vendor by data management

    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.

  • Huong Pham Profile Picture
    Huong Pham 90 on at
    RE: Errorr when Import vendor by data management

    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!

  • JPJooste Profile Picture
    JPJooste 10 on at
    RE: Errorr when Import vendor by data management

    Hi huongpm

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

    Regards

  • N Merkx  Profile Picture
    N Merkx 8 on at
    RE: Errorr when Import vendor by data management

    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!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 284,876 Super User on at
    RE: Errorr when Import vendor by data management

    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?

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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,876 Super User

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,425 Super User

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans