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:
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’
The lines will then appear in the General Journal:
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: