Error in importing vendor account

Dynamics 365 for Finance and Operations/AX User Forum
1

Hi…

Can any one help me to solve this problem. I am importing vendor account from excel to ax 2009. I have used the template wizard of ax 2009. I already set the number sequence in the address book id and vendor account in parameter and but the continuous nor the manual field is not selected.

After the import process this message in info log appeared "Cannot create a record in vendors (vendtable). Vendor account already exist". But there is really no record in the vendor details.

Thank you in advance.

2

hope this helps:

http://shekhardiptiman.wordpress.com/2010/01/14/dynamics-ax-2009-%E2%80%93-import-customer-mastervendor-master-and-their-primary-addresses/

3

Hi,

This issue was reported here before. In that case, for some reason the ‘PartyId’ field was duplicating. Please check this field; if necessary alter the number sequence and give it a go again.

4

hi heylin,

thanks for giving the site but I already did the steps given, still the same error appears.

5

Also check the obvious - the data has to have a unique vendor reference, check there are no duplicates in the data.

6

hi harish,

May I ask if Party ID has something to do with the codes?

7

Hi,

I believe in your case ‘PartyId’ must be getting duplicated. This is generated from number sequence defined in GAB (Global address book) under Basic > Setup > GAB. This is the reason I suggested resetting this number sequence.

Also have you tried to create vendor manually?

8

hi harish,

When I created employee details i used the global address id. Does the global id used in employee defers from the global id in vendor details and in customer detail? Sorry I am just newbie in Ax 2009, I am still confuse. Thank you very much for the help.

9

Hi harish,

I already try to create vendor manually, and there is no problem, but I still want to know the reason why that error appear. thanks.