Importing Item Journal Line from Excel.

Dev1978

I am using the Data Migration utility in navision to import the data from excel file. I am inserting the data in Item Journal Line Table.

The issue is that when i import the data it imports every thing and shows the data fine. But it is not importing the Posting Date, Although it is there in the sheet and when i open the form and edit it is saved.

So can any one tell me what is the issue is there any validity issue or format issue of date on excel i also tried to change it to text data type on excel. But every thing is importing but posting date please help needed.

Thanks.

sergisoft

There is some particularity on Journal tables. There is a funtion called SetUpNewLine on these kind of tables that sets "Posting date" and "Document No." using the line before and batch setup. When you write it manually, it is called from FORM.

Take a look on it and invoke before make INSERT.

I hope it could help you.