Upon further review, we found that the feature is available for anyone that has access to the Transaction Entry window in GP. However, if any errors are detected in the data that the user is attempting to paste, the GL Transaction Paste Validation Report will need to print. This report is new to GP2013 R2, specifically made for the Excel Copy Paste feature. The report will display the data that needs to be revised in the Excel Spreadsheet. The GL Transaction Paste Validation Report will not appear if the data is correct- it will bypass this report and paste the data into the Transaction Entry window.
To resolve the error, we navigated to the Security Task Setup and added the “GL Transaction Paste Validation Report” to the TRX_FIN_001* task.
By Saher Ahmed, Consultant in Armanino's Gold Certified Microsoft Dynamics Practice