How to export and then import excel into General Journal - no using rapidstart

Blackdiamond

Hi all,

NAV 2016, 9.0.44974.0

I am supporting a customer(end user) who wants to import lines from Excel instead of writing them manually in General Journal. For safety sake the customer is not allowed to use RapidStart.

I have been doing this:
Being on that General Journals, I am exporting to Excel, see attached


Before I export to Excel, I enter Data to check that I can import same data again in Dynamics NAV 2016.

I delete my General Journal --> Standing on action tab on ribbon --> Import from Excel.

I choose these option before I import.

Then I received this fault:


How can I proceed from here or what to do?
Thanks

mohana_cse06

on action tab on ribbon --> Import from Excel.
It doesn't seem to be a standard functionality.
you need to check how it was developed.

mohana_cse06

and how does your sample excel file look like? how is it developed? using report or xmlport etc?

Blackdiamond

Hi Mohana,

At the moment I haven't develop anything. Data is standard NAV. I have enter data in Dynamics NAV 2016, exported it, save the file, delete data from General Journal in Dynamics. Import the same Excel file which was created earlier in process. Mibuso won't allowed me to attach Excel file. Here is a picture:

mohana_cse06

on action tab on ribbon --> Import from Excel.
It doesn't seem to be a standard functionality.
you need to check how it was developed.

Blackdiamond

You are right. This is not a standard functionality. I have to wait till my developer comes back. Thanks a lot

Blackdiamond

Thanks for helping Mohana.