Armanino Blog
Article

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.

Resources
Related News & Insights
IPO Prep & SOX Compliance: Instacart & Armanino Share Hard-Earned Knowledge
Webinar
Know your compliance requirements today to avoid obstacles tomorrow.

December 16, 2021 | 11:00 AM - 12:00 PM PT
General Contractor Trends to Consider in 2022 Webinar
Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Why COP26 Matters for Your Business Webinar
Webinar
Get informed of COP26 developments and how you can act now.

December 15, 2021 | 10:30 AM - 11:00 AM PT