Thursday, December 1, 2011

Importing Vendor Master in Dynamics AX 2009


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