Armanino Blog

Dynamics GP Excel Copy Paste Error in 2013 R2

August 28, 2014

We recently received a call from a customer with issues using Dynamics GP Excel copy paste function. She said she did not have access to the Excel Copy Paste function in GP2013 R2. When she attempted to paste data, she received this error message: Not privileged to run this report.

Upon further review, we found that the feature is available for anyone who has access to the Transaction Entry window in GP. However, if any errors are detected in the data the user is attempting to paste, the GL Transaction Paste Validation Report will need to print.

This report is new to GP2013 R2 and is made specifically for the Excel Copy Paste feature. The report will display the data that needs to be revised in the Excel spreadsheet. If the data is correct, the GL Transaction Paste Validation Report will not appear, and the data will be pasted into the Transaction Entry window.

To resolve the error, we navigated to the Security Task Setup and added "GL Transaction Paste Validation Report" to the TRX_FIN_001* task.

Copy Paste Task ID

Learn more about Dynamics GP for more tips and tricks like this one to remedy this Dynamics GP copy paste function error.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Related News & Insights
Costco Travel Webinar
One of the world’s top retailers reveals their cloud upgrade process.

May 19, 2022 | 11:00 AM - 11:30 AM PT
Overview of Sage Intacct R2 Release Webinar
Learn the newest features and enhancements in Sage Intacct from the 2022 Release 2.

May 18, 2022 | 01:00 PM - 02:00 PM PT
Foundation Cuts Manual Data Entry, Empowers Staff With Robotic Process Automation
Case Study
RPA tech enables lasting growth, boosts savings and frees up staff to redirect their time to meaningful strategies.

May 18, 2022