New feature in NAV 2013 – Copy from excel into NAV

In previous versions of NAV you have been able to copy rows from NAV to excel but not copy
rows from excel into NAV.  In the next release of NAV due out this October, NAV 2013, you can now paste rows from excel into NAV!!

I have the following in excel that I want to paste into a General Journal within NAV:

Blog1

In NAV I need to ensure I show the fields that match my excel fields. 

Copy the rows from excel, go to your journal and right click on the journal line and select ‘Paste Rows’

Blog2

The lines will then appear in the General Journal:

Blog3

When lines are pasted this will deal with any validation issues and give you any warnings if an error exists on the journal.

An example of a validation error when lines have been pasted into NAV:

Blog4

 

Leave a Reply