Microsoft Dynamics NAV 2016


Business Central

Table of Contents

By Chris Young

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.

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.

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.

Chris Young

Chris Young

Partner, Clients First Business Solutions New Jersey

Chris Young is your go-to resource for all things Dynamics NAV and Dynamics 365 Business Central at Clients First. Highly skilled in ERP solution architecture and financial planning, Chris has spent the last 30 years helping clients select and implement the right financial, manufacturing, and distribution software for their needs. When he’s not presenting to captivated crowds or sharing his knowledge through product demos, you can find Chris in the garage working on a car or fixing something around the house.