Getting your data into Axapta is alot easier when you use Axapta. First add a row of data manually, for example an item to the item master. Then look at the data to see what fields were filled in automatically and which fields were required to be filled in before you were able to save the record. This is a great starting point. This will tell you which fields you will need to import. Next is to get familiar with the import function. Stick with comma delimited files. There are plenty of examples of code that you can include in your import definitions to do things like looking up the InventDim value for an item when populating InventTableModule. Sometimes I include fields that have values that I will use as the source data for lookups, for example warehouse and location, when finding an InventDim. I’ve written VB code to handle the translation of our old data into comma delimited tables. Everything else is done inside Axapta. Here is code inserted into the conversion tab on a comma delimited import for a counting journal to import startup inventory counts: InventDim InventDim; InventDimId InventDimId; ; InventDim.clear(); InventDim.InventLocationId = ‘SMC100’; //enter warehouse here InventDim.WMSLocationId = conpeek(inData,2); //enter bin here InventDim.InventColorId = InventTable::find(conpeek(inData,1)).StandardInventColorId; InventDim.InventSizeId = InventTable::find(conpeek(inData,1)).StandardInventSizeId; InventDimId = InventDim::findOrCreate(InventDim).InventDimId; InventJournalTrans.JournalId = ‘IJ-000049’; //enter journal id here InventJournalTrans.TransDate = Str2Date(‘12/23/2004’,213); //enter date here InventJournalTrans.EmplId = ‘Admin’; InventJournalTrans.Dimension[1] = ‘100’; InventJournalTrans.InventDimId = InventDimId; InventJournalTrans.JournalType = InventJournalType::Count; InventJournalTrans.Voucher = ‘IJV-000003’;