Importing Vendor Master in Dynamics AX 2009

Views (0)

Mohamed Asarafali

445

Like(0)

Report

01-11-2011

Importing Vendor Master through Excel sheet in Dynamics Ax 2009

Problem: I was asked to import vendor master table. After i created the definition group for vendtable then i import the data from excel sheet but the error occurs “the data already exist”.

Solved: The problem occurs because of addressBookId. In my excel sheet my addressBookId was empty. I need to fill that field with unique id or run some scripts to satisfy the error.

I solved this problem by using Number sequence set the number sequence for address book Id. Navigate to Basic>Setup>GlobalAddressBook>Parameters. Click the number sequences tab and select the number sequence for Address Book Id

This was originally posted here.