Microsoft Dynamics NAV 2016

General Journals: Is the Paste Rows Option Missing?

In NAV 2013 and later versions, functionality was available to copy and paste rows from journal pages (i.e. General Journals, Sales Journals, etc.)  to Excel, and then back from Excel to the journal page.   The functionality made uploading journal entries from Excel into journals very easy for consultants uploading beginning subsidiary balances and/or end users uploading end of month journal entries.  However, starting in later builds in NAV 2016, this functionality is missing from the general journal page.

Dynamics NAV #1



How to add back the Paste Rows Option:

To allow users to paste from excel to an RTC Page, the property PasteIsValid of the associated table should be set to YES.

Dynamics NAV #2


As per my example, if the paste option is missing on the General Journal Page, then you need to set that property on the Gen. Journal Line (Table 81).  When the user right-clicks on the general journal, the Paste Rows function now appears.

Alternatively a Rapid Start Package can be created using Gen. Journal Line Table 81 to upload journal lines.  This alternative will be faster with large number of journal lines.

Dynamics NAV 3




Written by Mark Stept

Clients First Business Solutions, LLC