Paste Rows option is missing on RTC Pages

June 28, 2016     less than 1 minute read

One of the feature on the Navision RTC page is ability to copy rows and paste to excel and also copy rows from excel and paste into the page, mostly this option is heavily used on the worksheet pages i.e. Journal pages.[](https://lh3.googleusercontent.com/-ULodFx9bHis/V3M-zNrWTGI/AAAAAAAALQ4/99t-F4k7mzI/s1600-h/image%25255B3%25255D.png)

But recently i have noticed this option is missing on most of the pages, that is due to a bug/ or change made by Microsoft in the recent Cumulative Updates. The reason why this option does not appear on the page is because of the property PasteIsValid on the associated source table is set to NO. The default value of this property is yes but for some tables in the recent builds it is set to No.

So in order to have the option Paste Rows you need to set the PasteIsValid property on the table to yes.

[](https://lh3.googleusercontent.com/-Gn1wD_JYshg/V3M-3cp_TCI/AAAAAAAALRI/xDP_vGUEHms/s1600-h/image%25255B7%25255D.png)

For example if the option is missing on the General Journal Page, then you need to set that property on the Gen. Journal Line (Table 81).

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.