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

Blackdiamond · 2017-03-02

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 · 2017-03-02

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 · 2017-03-02

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

Blackdiamond · 2017-03-02

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 · 2017-03-02

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 · 2017-03-02

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

Blackdiamond · 2017-03-03

Thanks for helping Mohana.

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

Best Answer

Answers

Categories